CODEWITHSUNDEEP
ssasolapolap-cube
Suhandy Chow
Suhandy Chow

Reputation: 259

is it possible to calculate data between two different cubes?

I have two SSAS cubes (wages and sales) in one project. I need to find wages to sales by dividing wages with sales. to achieve that i need to get wages value in wages.cube then dividing it with sales value in sales.cube, is it possible to calculate between two different cubes?

Upvotes: 1

Views: 67

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300529

No. Not directly in a calculated measure.

Are wages and sales in different cubes because of different security concerns?

It would be more usual to have a wages measure group and a sales measure group in the same cube. You could just add the wages measure group to the Sales cube and hide it from users

Upvotes: 1

Related Questions