Hi,
in OLAPCostValue Axapta calc the actual CostValue every time you update
'custinvoiceTrans' in the cube (s.
\Classes\OLAPCreateAmount\fieldMethodName).
Michael
>From: "James Flavell" <[EMAIL PROTECTED]>
>Reply-To: development-axapta@yahoogroups.com
>To: <development-axapta@yahoogroups.com>
>Subject: [development-axapta] OLAP cubes for cost of sales
>Date: Thu, 14 Apr 2005 08:46:26 +0900
>
>
>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 inovice 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
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.