CODEWITHSUNDEEP
ssasmdxcubeolap-cube
Dodi
Dodi

Reputation: 111

Create a region calculation in the cube SSAS

I have a hierarchy of customers which include details of Country,City, Postal code with customer key. All I want to do is to group these countries according to their territories, Europe - North America - South America, to show the total sales for each one. How do I achieve this?

Any help would be highly appreciated

Upvotes: 0

Views: 78

Answers (1)

SebTHU
SebTHU

Reputation: 1405

You could total the data by Country (the highest level you currently have under ALL), and then externally group the results by Region (e.g. in Excel with a lookup mapping Countries to their Region).

There's no other sensible way to add an extra hierarchy level (which is what your Territory is) to cube data on the fly. The best way is to design the Region into the hierarchy as a level: meaning adding a Region column to the dimension source data, populating it, adding a Region attribute to the dimension, and putting this Region attribute into the hierarchy, below ALL and above Country.

Upvotes: 2

Related Questions