InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 17:29:40 GMT20http://www.sqlservercentral.com/Forums/Topic585392-147-1.aspxWell, if you want to get Energy Revenue - Utility Revenue you could write MDX to do it. You can either create [Energy Revenue], [Utility Revenue], and [Energy - Utility Revenue] which subtracts the two calculated measures, or you can alternatively just create the [Energy - Utility Revenue] and write the MDX to calculate it. In example:WITH MEMBER [Energy - Utility Revenue]AS ([Measures].[Total Revenue], [Dimension Sector].[Sector Group].&[Energy])-([Measures].[Total Revenue], [Dimension Sector].[Sector Group].&[Utility])SELECT [Measures].[Energy - Utility Revenue] ON COLUMNSFROM [EUS Fin Mart]Wed, 15 Oct 2008 00:20:24 GMTBoyan Penevhttp://www.sqlservercentral.com/Forums/Topic585392-147-1.aspxHi Boyan,Thaks to reply , What i understand from Calculated member is that we can perform different operation on measure data as par the business requirement . But after reading that details mention in Calculated member i found that I can not perform any mathematical operation between measure & dimension directly because in dimension we are having only details like Dimension Sector I have : Energy ,Services , Utilities . and in measure like revenue i Have numeric data like revenue in some million value .Like there is any other way so that after running this query (With Member [Revenue Energy]As ([Measures].[Total Revenue], [Dimension Sector].[Sector Group].&[Energy])Select [Measures].[Revenue Energy]On columns from [EUS Fin Mart] )so I can put directly it as measure value.Regards, Alok Tue, 14 Oct 2008 22:44:06 GMTalokkumar_srivastavahttp://www.sqlservercentral.com/Forums/Topic585392-147-1.aspxIf you want to have this as a calculated measure in your cube you can create one from Visual Studio Business Intelligence Dev Studio.You may find this useful:http://msdn.microsoft.com/en-us/library/ms166568.aspxTue, 14 Oct 2008 21:41:05 GMTBoyan Penevhttp://www.sqlservercentral.com/Forums/Topic585392-147-1.aspxBoyan,Thanks to reply it's working now . But I am facing one problem , Can you please tell me how i can add this particular sector wise revenue in Cubes So i can directly drag it as Column for generation of the Reports . Thanks & Regards,AlokTue, 14 Oct 2008 21:25:27 GMTalokkumar_srivastavahttp://www.sqlservercentral.com/Forums/Topic585392-147-1.aspxTry:With Member [Revenue Energy]As ([Measures].[Total Revenue], [Dimension Sector].[Sector Group].&[Energy])Select [Measures].[Revenue Energy]On columns from [EUS Fin Mart]Tue, 14 Oct 2008 18:05:46 GMTBoyan Penevhttp://www.sqlservercentral.com/Forums/Topic585392-147-1.aspxHi All, I want to get sector wise revenue in percentage form Measure & dimension I have mention below :Measures:[Measures].[Total Revenue]Dimension data : [Dimension Sector].[Sector Group].&[Energy][Dimension Sector].[Sector Group].&[N/A][Dimension Sector].[Sector Group].&[Services][Dimension Sector].[Sector Group].&[Utilities]I am running this Query : With Member [Revenue Energy]As [Measures].[Total Revenue], [Dimension Sector].[Sector Group].&[Energy]Select [Measures].[Revenue Energy]On columns from [EUS Fin Mart]It’s showing me execution error asExecuting the query ...Query (2, 50) Parser: The syntax for '.' is incorrect.Execution completeAt [Dimension Sector].In the query mention below .With Member [Revenue Energy]As [Measures].[Total Revenue], [Dimension Sector].[Sector Group].&[Energy]Select [Measures].[Revenue Energy]On columns from [EUS Fin Mart]Please help me .Regards, AlokTue, 14 Oct 2008 06:18:25 GMTalokkumar_srivastava