Skip to Content
0
Former Member
May 09, 2010 at 07:21 AM

Record statement *REC - How to pass dynamic value in a Tuple

14 Views

Hello,

I am generating a new record using *REC.

I have defined values in Tuple as per the record in the cube and at the end i am passing new values to my dimensions.

REC(EXPRESSION = ([P_ACCT].[NONE],[ENTITY].[NONE],[P_DATASRC].[MANUAL],[RPTCURRENCY].[USD],[UNIT].[FT],[CATEGORY].[PLAN],[MATERIAL].[MAT_NONE],[TIME].[XXXX]),P_ACCT=INPUT,TIME=XXXX)

in the above expression for the UNIT i have specified value FT as i was running for a specific record i was able to generate the new record with values, however in real time i will not know the Unit Value so i cannot specify any value.

So, if the unit value i am going to read the record using tuple is different from the target records which iam going to generate them my keyfigure values are coming '0'.

So now if i can some how manage the units also then i can generate records.

How this can be handled without passing any unit value as i did above.