RE: [development-axapta] OLAP cubes for cost of sales
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: development-axapta@yahoogroups.com To: development-axapta@yahoogroups.com 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: development-axapta@yahoogroups.com 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: 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] 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.
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: 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.
RE: [development-axapta] OLAP cubes for cost of sales
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: development-axapta@yahoogroups.com 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: 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] 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.