Interval selection via BICS connection

You may also like...

11 Responses

  1. Hello Pieter,

    in the blog you mentioned that a variable in the underlying BEx query would limit the complete data set and would prompt automatically, which is not 100% accurate.

    First of all the usage of BEx variables is recommended as the variable is offering more capabilities – for example being able to limit the list of values based on user authorizations.

    A variable in the BEx query will only prompt the user using the BEx variable dialog when the prompt is mandatory and the value has not been filled in the Xcelsius dashboard.

    In addition the variable will only limit the data from the one connection it applied to and not the data from the complete dashboard.

    And last but not least the variable used in the BEx query and the corresponding list of values which then also is part of the connection will guarantee the best performance because in case you are sending a value like shown “200802” to the underlying BW system it needs to be translated to the technical name, which the variable has automatically as part of the provided values.

    so in short – the recommended approach is to use the variables as part of the BEx query.

    regards
    Ingo Hilgefort

    • Hi Ingo,

      Thanks for your response, I agree with your comment. But I have a question about the BEx variables. In my query I’m using a non-mandatory interval BEx variable on the object 0CALMONTH.
      My dashboard has two connections to BW, one connection for getting the months and one for the transactional data. How can I fill the variable in the Data Manager with an interval value? I tried to select two cells but it doesn’t work. What’s the best practice for this scenario?

      Regards,
      Pieter

  2. Hi,

    there is no need – assuming you use the BI CS connection – to use two connection as the connection provides you input and output areas. the output area also includes access to the list of values and the input area includes the variables and the filter.

    Ingo

  3. Liz says:

    Hi guys…

    Can you help us with an issue we’re facing?
    We have a Dashboard using BICS Connection, our queries have mandatory variables and we’re “filling” those values trough the dashboard, but the prompt still appearing and our user doesn’t want it. The big issue is that this only happes in our Productive environment in QAS doesn’t appears this prompt.

    Any suggestion?

    • Hi Liz,

      This is a very strange issue. Are the QAS and Production on the same SP level?
      I recommend to create a message by SAP support.

      Another option will maybe work: try to use the optional variables? Did the prompt still pop up?

      Regards,
      Pieter

  1. February 21, 2011

    New blog post: Interval selection with #BICS connection in #Xcelsius. http://bit.ly/hQGvg0 #SAP #BI #BOBJ

  2. February 21, 2011

    RT @pverstraeten: New blog post: Interval selection with #BICS connection in #Xcelsius. http://bit.ly/hQGvg0 #SAP #BI #BOBJ

  3. February 21, 2011

    RT @pverstraeten: New blog post: Interval selection with #BICS connection in #Xcelsius. http://bit.ly/hQGvg0 #SAP #BI #BOBJ

  4. April 5, 2011

    Updated blogpost: Interval selection via BICS connection http://bit.ly/hQGvg0 #SAP #xcelsius #bobj #BI

  5. April 5, 2011

    RT @pverstraeten: Updated blogpost: Interval selection via BICS connection http://bit.ly/hQGvg0 #SAP #xcelsius #bobj #BI

  6. April 5, 2011

    RT @pverstraeten: Updated blogpost: Interval selection via BICS connection http://bit.ly/hQGvg0 #SAP #xcelsius #bobj #BI

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.