Hello! I hope some OLAP - guru is online again. I have a problem with calculated member when making an OLAP - cube. I need to calculate amount of invoices where SalesType = 'Returnitem'. How do I make such function to a calculated member. I tried this:
Sum(Descendants([WMDLaskKplPr_Dimension].CurrentMember, [WMDLaskKplPr_Dimension].[Invoice]),IIf([WMDLaskKplPr_Dimension]. [Invoicetype]='ReturnItem',[Measures].[PCS],0)) but it does'nt work. How to make the logical comparison to ReturnItem - type? ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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/