Skip to Content
0
Former Member
Jun 30, 2015 at 02:58 PM

How can I select the data based on propriety of member ID selected in the package?

16 Views

Hi experts,

How can I select the data based on propriety of member ID selected in the package?

Example:

I select in the package the TIME: 2013.01

This member 2013.01 has a propriety called BASE=2013BASE.

And I have a MEMBER in TIME dimension as 2013BASE.

I want to run a logic script to clear data in 2013BASE member, according the select in package 2013.01.

I have data just in 2013BASE

In the package the users select 2013.01:

Logic incorrect because is looking for data in 2013.01 and not 2013BASE

//DELETE YEAR BASE RECORDS PRIOR TO RECALCULATING

*XDIM_MEMBERSET ACCSALES = BAS(KSD50)

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET DATASOURCE = INPUT

*XDIM_MEMBERSET RPTCURRENCY=IC

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET MFGPLANT = BAS(MFGPLANTS)

*XDIM_MEMBERSET PLANT = %PLANT_SET%

*WHEN ACCSALES

*IS *

*REC(EXPRESSION= 0,ACCSALES=KSD51.2.1,TIME=TIME.YEAR_BASE)

*REC(EXPRESSION= 0,ACCSALES=KSD58.1,TIME=TIME.YEAR_BASE)

*REC(EXPRESSION= 0,ACCSALES=KSD14,TIME=TIME.YEAR_BASE)

*REC(EXPRESSION= 0,ACCSALES=KSD90,TIME=TIME.YEAR_BASE)

Attachments

2.png (120.9 kB)
1.png (61.6 kB)