Skip to Content

Characteristic relationships and input layout

Dear Experts,

I have an input layout on a planning infocube. By saving new data in the layout I want to start a characteristic relationship and derive some characteristics. In the theory to be executed the characteristic relationship should get all the source characteristics filled with values. I have 2 source characteristics and one of them is # in some cases. When char2=# my Characteristic relation does not start. Is there a trick to start it for the combination char1 = value 1 and char2=#?

This happens only when I am using layout. When I execute copy function for example and the data in some rows is exactly the same char1 = value 1 and char2=# the characteristic relationship starts and derives value for the target characteristic.

We are on BW on HANA system.

thanks,

Maria

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 16 at 09:28 AM

    Hi Maria,

    if one source field of a derivation relation is initial, the DERIVE method will not be called. These combinations are call 'automatically valid', you might use your favorite search engine to get more information about this topic. You can use the setting EXCL# = X, then DERIVE and CHECK will also be called for automatically valid relations.

    Regards,

    Gregor

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Maria,

      you say that you have set the source 'char1 = #', here for me it is unclear whether you talk about the internal value or the external value. Any client uses external format; '#' is the external format of the initial value. The client converts the external value to the internal value and the latter is used in BW to process the data. To use '#' as interval value would be wrong.

      Do your have more information about the 'Invalid characteristic combinations exists' message (this is message RSPLS070 I gess, e.g. other messages with information about the combination)? The following notes might be helpful to analyze PAK messages:

      2375039

      2085284

      Regards,

      Gregor

  • Apr 11 at 02:29 PM

    Hi Maria,

    I am not sure what you mean by "source characteristics".

    in a char relationship you define as "Source char" the one that is filled in query or function and as "target" the one that shall be fileed by the derivation rule.

    derived char = target char MAY NOT be part of the aggregation level, otherwise the derivation will not start.

    here in my example, we always use 0FISCYEAR in all queries and functions and from this for instance 0CALYEAR is derived.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12 at 11:04 AM

    Hi Cornelia,

    thanks for answering. This rule is kept. All the target char. are not in the aggr. level. The source char. are in the level, but one of them gets value=#. It is set in the query and it is used so in the planning model, so I can't change it. So, for the combination of char1 =val1 and char2=# I want to derive a value for the target char1=val1 and target2=val2. The problem is that the char. relation does not start at all.

    thanks and regards,

    Maria

    Add comment
    10|10000 characters needed characters exceeded