Hi Thanks to reply that is really helpful to learn .

But i am stuck to write one xmla script that will take back up for all ssas database in one...

Thanks to reply .Yaah there must be some problem with Excel .

Thanks,

Alok

Actually from that Excel sheet it inserting data randomly not in sequnce . I mean not as from the starting 26000 row .

Thanks,

Alok

Yaah I am using SSIS .

Hi,

Thanks to reply . Basically the problem i am fascing is that below the drop down menu of data set there is one eclips where my all cubes are located...

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...

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...

Hi,

Thanks to reply , actually i am using this function :

(IIF([Dimension Sector].[Dimension Sector] <> 0,

[Measures].[Total Revenue]/[Dimension Sector].[Dimension Sector],0),

"##.00;(##.00);0.00;#.00")

in IIF function if [Dimension Sector].[Dimension Sector] in equal to 0...

Thanks to Reply .

Actually i am working on Reporting services there i need to implement some business logic to get required data from OLAP Cubes , basically from measures...

Hi Vijay,

Thanks to reply , I solve that problem.

Regards,

Alok