Skip to Content
0
Former Member
Jan 31, 2013 at 11:46 PM

Restricted Measure in Analytic View with SCD Attribute View

30 Views

Hi,

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.

For Ex:

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

Problem:

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????

Regards,

Vijay