1

Topic: MS SSAS hierarchy taking into account changes in time

All good afternoon.
There is a fact table with the approximate data:
Date, region, . The managing director, the linear managing director, a city, separation, columns of the facts
There is a reference manual:
Region, . The managing director, the linear managing director, a city, separation, the beginning with (date), the termination (date).
That is submission during a time frame which can change.
At each level the region, managing directors, cities can be on some subtotals, that is at . The managing director some subordinates; at the linear some cities; in a city some separations.
Want to see hierarchy in the same sequence as it is enumerated in the fact table (except the facts :-))
That I can make and it is made:
To lead the reference manual to a type:
Date, region, . The managing director, the linear managing director, a city, separation
That is accurate submission for each date from the fact table.
It is necessary to make so that in Excel at lines it was possible to transfer hierarchy, and to date columns. On intersection to count the facts.
Now each of measurements (region, . The managing director, the linear managing director, a city, separation) it is implemented separately, as select distinct from the fact table.
Accordingly, if in Excel of them to do similarity of hierarchy, the part of the intermediate data disappears, but grand totals are considered correctly.
Who can that advise?
Yours faithfully, Ilya

2

Re: MS SSAS hierarchy taking into account changes in time

IlyamI;
Read M2M Revolution section Cross-Time