cancel
Showing results for 
Search instead for 
Did you mean: 

DSO Fox change value of characteristic used as key figure

former_member199573
Active Participant
0 Kudos

Hi,

I have a real time DSO using one key figure, one time characteristic and 2 data fields.

The data fields are a characteristic and a key figure. I select the option to use the characteristic as key figure.

The aggregation level is,

The FOX code used in planning function to change the values is,

ZFISCPER TYPE 0FISCPER.
DATA ZFISCPER2 TYPE 0FISCPER.
DATA ZCOMPC TYPE ZCOMPCODE.
DATA ZCOMPC2 TYPE ZCOMPCODE.
DATA ZFISCVAR  TYPE 0FISCVARNT.
DATA K_SITEFLAG TYPE F.
CLEAR K_SITEFLAG.

*Formula variable to capture Flag value

K_SITEFLAG = VARV(ZVAR_SITEFLAG).
*Fiscal Variant
ZFISCVAR
= Z1.
*Fiscal period selected
ZFISCPER
= VARV(ZVAR_PREVFPER).
*Site selected in Dashboard
ZCOMPC
= VARV(ZVAR_CC_INP).
FOREACH ZFISCPER2, ZCOMPC2.
 
IF ZFISCPER2 = ZFISCPER AND ZCOMPC2 = ZCOMPC.
    {1KYF_0BBP_FLAG
,ZFISCPER,ZFISCVAR,ZCOMPC} = K_SITEFLAG.
    {0NUMDAY
,ZFISCPER,ZFISCVAR,ZCOMPC} = K_SITEFLAG.
 
ENDIF.
ENDFOR.

The filter is restricted by the variables,

0FISCPER Fiscal year / period @QQ\QIncluded Variable Value@ var:ZVAR_PREVFPER

0FISCVARNT Fiscal year variant @20\QSelect: Equal to@ Z1

ZCOMPCODE Company code @QQ\QIncluded Variable Value@ var:ZVAR_CC_INP

The data set is,

When I test the planning sequence for period 005.2015 and company code 1100, it shows the following,

I am unable to understand how the Indicator(0bbp_flag) column is fetching the value 3.

I think it is aggregating the data in a different way than the key figure as it is a characteristic used as a key figure.

The key figure is working as expected and always saving the new value entered using the formula variable.

But, the characteristic is causing and error and short dump related to SID not found with the above design.

Thanks for any hints to solve the issue.

Raja.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Raja,

the feature 'characteristics as key figures' is only supported in some planning function types, cf.

Planning Functions - Planning Business Data with BW Integrated Planning - SAP Library

The reason is that the characteristics are exposed as artificial key figures (characteristics are represented as SID) and thus all kind of computations with this artificial key figures make no sense. FOX is not supported here.

Regards,

Gregor

former_member199573
Active Participant
0 Kudos

Hi Gregor,

Thank you for the information.

Can you please help me to find where it is mentioned in the help link about the 'characteristic as key figure' not supported with FOX in planning funciton?

Thanks again.

Raja.

Answers (0)