cancel
Showing results for 
Search instead for 
Did you mean: 

formula variable in CKF

Former Member
0 Kudos

Hi.

I am trying to use formula variable with replacement path (hierarchy sign) in CKF, but system shows error

Variable ZSIGN is not allowed in a calculated key figure.

Is it possible to bypass this issue?


Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

See this link may help u:

http://scn.sap.com/thread/1745240

former_member182470
Active Contributor
0 Kudos

I think you are trying to replace with a ZSIGN variable in the replacement tab of your formula variable.

From the dropdown of your variables in this tab, do you see ZSIGN variable in the list? Even if it is not available, you can directly enter the variable in the screen and ignore the warning messages.

anshu_lilhori
Active Contributor
0 Kudos

Hi,

What are you trying to replace ?

Can you throw some light on your requirement so that we can give some inputs on the same.

Regards,

AL

Former Member
0 Kudos

ZSIGN variable returns 1 or -1. it depends on signs of nodes of hierarchy.

in definition of CKF i write:

amount * zsign

Then i save report and all ok.

but when i execute it

appears message mentioned above with type error, not warning.



anshu_lilhori
Active Contributor
0 Kudos

Hi,

can you tell the definition of zsign variable means how its being created.

Regards,

AL

former_member182470
Active Contributor
0 Kudos

Hi,

I got your problem. Look at "Subha Banerjee's " reply for the complete steps to get rid of your problem.

http://scn.sap.com/thread/799384

REgards,

Suman

Former Member
0 Kudos

these are values in domain RSZFLAGR

1    Key

2    External Characteristic Value Key

3    Name (text)

4    Attribute Value

5    Query result

6    Hierarchy Attribute Value

it seems problem occurs only when formula variable has value

6    Hierarchy Attribute Value

in field FLAGR of RSZGLOBV table.

in include LRRI9F04 line 779 there is code which raises message:

if     i_kflag = rs_c_true
      and <l_sx_var>-flagr = rro04_c_flagr-hierattr.
*   ersetzen aus Hierarchieattributen ist nicht in berechneten
*   Kennzahlen erlaubt
     perform msg_raise using g_cs_wrong_hierattr
                             <l_sx_var>-vnam
                             space space space.

endif.


former_member182470
Active Contributor
0 Kudos

I tried to get rid of this problem in my system. I too got the same error when i use Hierarchy Attribute in the Replacement tab. I used hierarchy Infoobject in the variable general tab. Did you follow the steps which were told in the link which I gave you?

I tried to see some documentation in help.sap, but nothing such found there.

Former Member
0 Kudos

yes, i did that steps. still error..


Subha Banerjee's answer was in


former_member182470
Active Contributor
0 Kudos

Is there any chance for you achieve your requirement without using hierarchy attribute? If not, then contact SAP on how to use this?