I found instructions on msdn library on how to add the Master Company Reporting Currency. (Walkthrough: Creating a Cube). However, I am surprised that in my case I need to do this even for standard AX cubes!
Actually, initially I did not need to do this. All the KPIs displayed fine with demo data loaded. Then I wanted to experiment with a virtual company to share the LedgerTable. I was experimenting for learning - trying to do what is suggested in the document "Extending Microsoft Dynamics 2009 Default Cubes for Analytics across Virtual Company Accounts". As soon as I had modified AX to do share the Ledger Table, I could no longer process the cubes, even when I had created the LedgerTableView and fixed the LedgerTable select statement. I get the error mentioned below in this email stream. I do not understand why the standard cube would start to require the master company reporting currency if it was not needed before! I am using SQL 2008 and Visual Studio 2008 on Windows 2008 R2 with AX 2009 SP1, I am unable to create the Reporting Currency Named Query. When I click Finish, the error shows the SQL for the query which needs to be fixed, but there seems to be no way to edit the query. If I quit, I do not have a Query to edit! So, I have three questions for anyone who has succeeded in working with virtual companies and this problenm with the Master Company Reporting Currency: 1) Is there any way with default cubes to avoid getting this error. 2) If not, is it required to map the Master Company Exchange Rate to the Time dimension for every one of the "time" dimensions (because there are multiple times (dates) listed among the dimensions of each cube)? Or is it sufficient to do this only for the dimension that is labeled "Time" without extra clarification. 3) How can the Reporting Currency Named Query be created correctly without needing to use the wizard and then (if you can) open and edit the query (which may not exist!) ---------- Forwarded message ---------- From: Rahul <ra...@rahulsharma.in> Date: Wed, Dec 16, 2009 at 1:45 PM Subject: [development-axapta] Re: AX 2009 - Reporting Service- Error To: development-axapta@yahoogroups.com Hi, It looks like cube is missing "Master COmpany reporting Currency dimension". This dimension provides reporting of financial measures in all the currencies used by the companies implemented in Dynamics AX and this dimension is not automatically created when you generate a BI project for a cube. You must manually create this dimension. This dimension is neccessery to display the KPIs for a cube in a Business Overview Web part in Enterprise Portal. Regards, Rahul Sharma <http://settings.messenger.live.com/Conversation/IMMe.aspx?invitee=e7579\ 4c17db3...@apps.messenger.live.com&mkt=en-in<http://settings.messenger.live.com/Conversation/imme.aspx?invitee=e75794c17db3...@apps.messenger.live.com&mkt=en-in> > www.RahulSharma.in <http://www.rahulsharma.in/> <http://www.rahulsharma.in/> blog.RahulSharma.in <http://blog.rahulsharma.in/> <http://blog.rahulsharma.in/> --- In development-axapta@yahoogroups.com<development-axapta%40yahoogroups.com>, TOM SEBASTIAN <tomvaya...@...> wrote: > >  > Dear Reyaz, >  > Thanks for your quick reply, >  > I process all the dimensions and cube and restarted the Reporting Service and AOS but i have still the same error. I have a shared datasourse in reporting server the connection string is as following : >  > SharedLibrary.DynamicsAXOLAP > Provider="MSOLAP";Data source=localhost;Initial Catalog="Dynamics AX";Integrated Security=SSPI >  > In my Role center all the KPI's are alos not working it gives the following error >  > QuQuery (1, 196) The dimension '[Master Company Reporting Currency]' was not found in the cube when the string, [Master Company Reporting Currency].[Currency].&[Local], was parsed.ery (1, 196) The dimension '[Master Company Reporting Currency]' was not found in the cube when the string, [Master Company Reporting Currency].[Currency].&[Local], was parsed. >  > please reply >  > Thanks > Tom >  > > --- On Mon, 16/11/09, reyaz ahamad reyaz_mc...@... wrote: > > > From: reyaz ahamad reyaz_mc...@... > Subject: Re: [development-axapta] AX 2009 - Reporting Service- Error > To: development-axapta@yahoogroups.com<development-axapta%40yahoogroups.com> > Date: Monday, 16 November, 2009, 14:52 > > >  > > > > > hi dear ur problem is from the analysis server .have u installed analysis serevr > if u installed analysis server then u go to the sql server and connect to analysis server > and process all the dimenssion and cube .This process will resolved ur problem. > > Best Regards > Reyaz Ahamad       > CorporateServe Consulting & Outsourcing| 51, Moulsari Avenue, DLF Phase-3| Gurgaon 122 002 >  Member of Microsoftâs Presidents Club 2009 > Web:www.corporatese rve.com | email: reyaz.ahamad@ corporateserve. com > > --- On Sun, 15/11/09, TOM SEBASTIAN tomvaya...@yahoo. co.uk> wrote: > > From: TOM SEBASTIAN tomvaya...@yahoo. co.uk> > Subject: [development- axapta] AX 2009 - Reporting Service- Error > To: "AxaptaGroup" <development- axa...@yahoogrou ps.com> > Date: Sunday, 15 November, 2009, 12:29 PM > >  > > Dear All, >  > I sucessfully installed AX 2009, Reporting Services and Reporting Extension sucessfully. I can i aceess http://localhost: <http://localhost/>81/Reports and http://localhost: <http://localhost/> 81/Report Server. >  > I have deployed the AX reports but while the SRS reports through AX am getting this error >  > Error during processing of âAX_CompanyNameâ report parameter. (rsReportParameterP rocessingError) >  > Please reply >  > Thanks > TS > > [Non-text portions of this message have been removed] > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo. com/ > > [Non-text portions of this message have been removed] > > > > > > > > > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed] [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/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/development-axapta/join (Yahoo! ID required) <*> To change settings via email: development-axapta-dig...@yahoogroups.com development-axapta-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: development-axapta-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/