Not only by generating cube, it's triggered every time you 'send' data to
the cube. I mean normal there is no value in OLAPCostValue or it's possible
there is a wrong (old) value. So it's not posssible to use the value from
the field, you have always to use the methode if you want actual data.
Michael
>From: "James Flavell" <[EMAIL PROTECTED]>
>Reply-To: [email protected]
>To: <[email protected]>
>Subject: RE: [development-axapta] OLAP cubes for cost of sales
>Date: Thu, 14 Apr 2005 18:00:33 +0900
>
>
>Thanks Michael,
>
>I looked at the configuration key and realised that the field my customer
>wont get any way because it requires 'Business analysis' license but I am
>still interested to know the class you mention is being triggered during
>cube generating is it?
>
>Thanks
>James
>
>
>-----Original Message-----
>From: Michael Niemeyer [mailto:[EMAIL PROTECTED]
>Sent: 14 April 2005 18:26
>To: [email protected]
>Subject: RE: [development-axapta] OLAP cubes for cost of sales
>
>
>
>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: [email protected]
> >To: <[email protected]>
> >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]
><mailto:[EMAIL PROTECTED]>
>
>
>* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
><http://docs.yahoo.com/info/terms/> .
>
>
>
>
>[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.
