Business Intelligence Question Forum

Do you have questions about SQL Server, Power BI, Azure, or anything else business intelligence related?  You can use this forum to ask technical questions and receive responses from members of the BIDN community.  As you post you gain the permissions to vote up or down, vote on questions or answers and moderate the direction of the forums.

Note: SPAMMING or advertising is strictly prohibited and will result in your account being terminated and your IP address banned. SPAM is taken seriously and is immediately removed by administrators.

Slowly Changing Parent Child Hierarchy with Time Intelligence for Leaves in SSAS

At long last I have finally been able to build a slowy changing organization structure in SSAS.  The effect is awesome. When I select date in the cube the org dimension structure reflects what it looked like at the time. 
He is in  general  what the org structure looks like:

Division
​     Group

​       
Team
​           Employee

Example:
In H1 2016 Joe Salesman belonged to this org
                                  Sales            YTD Sales
East Division                 1,000,000  1,000,000
     Sales Group 5              250,000    250,000
           Sales Team 10         60,000      60,000
                 Joe Salesman    12,000      12,000

In H2 2016 Joe Salesman belonged to this org
                                              Sales   YTD Sales
West Division                 1,500,000    3,350,000
     Sales Group 3              350,000       550,000
           Sales Team 14         40,000       140,000
                 Joe Salesman    15,000           NULL

When someone looks at Joe Salesmans Records YTD using the org structure it looks like he had no sales from the previous year because it was part of a different org structure.  I want it to look like this:

In H1 2016 Joe Salesman belonged to this org
                                  Sales            YTD Sales
East Division                 1,000,000  1,000,000
     Sales Group 5              250,000    250,000
           Sales Team 10         60,000      60,000
                 Joe Salesman    12,000      12,000

In H2 2016 Joe Salesman belonged to this org
                                              Sales   YTD Sales
West Division                 1,500,000    3,350,000
     Sales Group 3              350,000       550,000
           Sales Team 14         40,000       140,000
                 Joe Salesman    15,000         27,000

Any help appreciated even suggestions on where to look.

asked 5 months ago
Sam Kerr2
Sam Kerr

0 Answers

Your Answer

In order to provide an answer to this question, you must Login

I am flagging this question because...




10 inform moderator flags remaining

I am deleting this question because...




I am flagging this answer because...




10 inform moderator flags remaining

Flagging a Post

You have already flagged this post. Clicking "Remove Flag" below will remove your flag, thus reducing the count by one as well.

I am deleting this answer because...