Skip to Content

Syntax error Accessing INFOPROVIDER Fox

Hi all,

We are currently trying to access data from other aggregation level within another aggregation level using a Fox formula. The formula seems to be working if both aggregation level definition is similar( same level of dimensionality ). The system throws a syntax error if we try to access another aggregation level which has different dimensionality ( more number of dimension/characteristics ).

Based on the help.sap.com , we are trying to use the formula.

"When the InfoProvider is accessed, the name of the Provider and the character `.` are inserted in front of the curly brackets. In this example, 0CALYEAR is the characteristic to be changed. With InfoProviders, all the characteristics to be changed must be specified as well as the characteristics that are not available in the aggregation level. Block characteristics can be accessed using the known notation.

{ 0VCPL_INT, 2013 } = DSO_REF.{ 0VCPL_QUAV, YEAR | 0PLANT = PLANT }."


Appreciate any suggestions.

Thanks

Sri

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 07, 2016 at 07:45 AM

    Hi Sri,

    if the external provider has additional characteristics, those have to be specified when accessing the provider. So you will have a different number of arguments in the curly brackets for external providers.

    The "Operants" button will also help for external providers: put the just write "ZALPTEST1." and then press the "Operands" button. You should get the list of characteristics for the external provider.

    Best regards,

    Marc

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2016 at 02:26 PM

    Hi,

    try to use '#' for missing info characteristics.

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded