Hi everyone, Has anyone done any OLAP cubes for cost of sales analysis/reports? I am considering doing this for a customer and am just wondering if there is any potential dangers/risks?
>From what I can see there is an 'OLAPCostValue' on the custinvoicelines table. Can I use this field and if so is there any extra step I need to do (i.e. is this field populated by normal invoice update and inventory closing). I plan to make the cubes directly in SQL (as the customer does not have the Business Analysis module) and so I believe there is some challenges to getting the cost per invoice line (since this is a method rather than actual field). Should I think about first creating a view in Axapta and then using that to make my cube (e.g. I have not really used views but I guess I can use Axapta methods to get a cost in the view but in a direct SQL to the view will such a cost field exist and be already populated?) I look forward to hearing your experience and advice Thanks James ------------------------ Yahoo! Groups Sponsor --------------------~--> Has someone you know been affected by illness or disease? Network for Good is THE place to support health awareness efforts! http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/