cancel
Showing results for 
Search instead for 
Did you mean: 

variable offset for calday is not working - urgent

Former Member
0 Kudos

Dear experts,

I need to create RKF on PO count by 0calday. I need PO count for last 3 cal days in columns.

I have a standard variable on 0calday, characteristic type, single value, mandatory.

I have created 3 RKF -having offesets: 0calday, 0calday-1, 0calday-2.

I can see three columns with date headers correcly.

But I see only data in 0calday column. I have data for previous 2 days, but those columns are not showing any data.

Please help me in fixing it.

Regards

Lisa

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I figured it out.

Former Member
0 Kudos

Hi,

I'm getting a similar error with a variable, how did you fix this?

Thanks,

Shannon

Former Member
0 Kudos

Hi,

Thanks anyway, but I've fixed the problem.

Thanks,

Shannon

Former Member
0 Kudos

When I am trying to change variable during navigation: I am getting following error

Diagnosis

The Can be changed in query navigation property has been set for variable Z_OD, characteristic 0CALDAY. However, the variable is used in the query in such a way, that the system is unable to apply this change-option.

This can, for example, occur under the following conditions:

Characteristic 0CALDAY is filtered by additional restrictions (the restrictions must be joined using an OR-connection)

A second characteristic, which is restricted by a variable, is compounded to charcteristic 0CALDAY.

Variable Z_OD is a hierarchy node variable, but the hierarchy has not been determined uniquely.

A variable can be changed during query navigation only if it is used exclusively in a drilldown-characteristic, and there are no further restrictions to the characteristic other than this variable. There must be no additional characteristics with variables compounded to the characteristic you are working with. For variables for hierarchy nodes, the hierarchy must be determined uniquely and agree with the set display hierarchy.

Also, if the characteristic value is moved, for example (Z_OD - 1), the variable is no longer able to be changed when navigating queries.

System Response

The entry Z_OD Can be changed during query navigation is not applied.

Procedure

Check the query definition.

Former Member
0 Kudos

Please help !