• 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