Did anyone tried creating a restricted key fig based on an attribute of an Attribute View which is of Type SCD. The restricted key fig is not giving correct results.
Data Foundation Table has below records:
EmpNo EMPCount Country
100 1 USA
101 1 USA
102 1 USA
Type2 SCD as Attribute View has data :
EmpNo Status StartDate EndDate
100 InActive 01/01/2013 01/15/2013
100 Active 01/16/2013 12/31/9999
101 Inactive 01/01/2013 12/31/9999
102 InActive 01/01/2013 01/15/2013
102 Active 01/16/2013 12/31/9999
In the Analytic View I created a Restricted Measure based on Status attribute from SCD Attribute View:
Restricted Measure definition: Count based on Status ='Active'
Count based on Status ='Inactive'
If I view the data then the values are as below:
EndDate Status StartDate EMPNO Country EMPCount Active InActive
1/15/2013 InActive 1/1/2013 100 USA 1 1 1
12/31/9999 Active 1/16/2013 100 USA 1 1 1
12/31/9999 InActive 1/1/2013 101 USA 1 ? 1
1/15/2013 InActive 1/1/2013 102 USA 1 1 1
12/31/9999 Active 1/16/2013 102 USA 1 1 1
Even though the Status is Active/Inactive the count is displayed for both columns Active and Inactive. Ideally it should count either in Active or Inactive for a record but not for both the columns. No matter what join we use or cardinaility we specify it is not giving me the correct result.
Is this is a known issue that restricted measure based on attribute of a attribute view does not work OR am I missing anything in this concept understanding..........
Please let me know if you have any thoughts. How to address Analytical Views which has restricted measures with SCD Attribute View????