October 14, 2008 at 6:18 am
Hi 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 as
Executing the query ...
Query (2, 50) Parser: The syntax for '.' is incorrect.
Execution complete
At [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,
Alok
October 14, 2008 at 6:05 pm
Try:
With Member [Revenue Energy]
As ([Measures].[Total Revenue], [Dimension Sector].[Sector Group].&[Energy])
Select [Measures].[Revenue Energy]
On columns from [EUS Fin Mart]
October 14, 2008 at 9:25 pm
Boyan,
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,
Alok
October 14, 2008 at 9:41 pm
If 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:
October 14, 2008 at 10:44 pm
Hi 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
October 15, 2008 at 12:20 am
Well, 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 COLUMNS
FROM [EUS Fin Mart]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply