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