Skip to Content

Analysis Office Variables

Hello,

I use queries which are ready for input.

They use variables with the selection of (e.g.) one company code and not multiples like "from...to".

If I switch to "from...to" the data fields are no longer ready for input.

How can I overcome that one?

Thanks for any tip.

Thomas

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 14, 2016 at 09:51 AM

    Hello,

    May be for some company code data is not loded in the cube. If data is not loaded for some compnay code then you have to change the setting in the query to "Read from the master data".

    Regards,

    Anand Kumar

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2016 at 09:56 AM

    Hello, Thomas! Unfortunately, I can't clearly understand your problem. Could you post any screenshots of this one? Where you select "From...to" ? On the selection screen or not?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Thomas Langheim

      Thomas,

      Thumb rule for input ready query is each characteristic used in aggregation level should have value associated with it,it could be through filter restriction (hard coded or through variable).

      Now in your case where query is input enabled for single value selection and not for range,there could be 2 possible case -

      1) Variable is not defined correctly - Create selection option variable where it is ready for input (basic settings for variable).

      2) Ensure all characteristic in aggregation level is alike for both cost centers means its compounding object controlling area and other attributes are same for all cost center used in variable.

      Thanks.