Skip to Content
author's profile photo
Former Member

Xcelsius 2008 SP3 with SAP BW

Hi,

I am using the SAP bw as a source for the Xcelsius, I have two query and want to pass the query one data to query 2 for the selection during the drill down. is it possible and how ?

query one has band and sales and query two has sub brand and sales , i want that when user select any brand my query should be able to brind the the sub brand from the second query.

thanks for your help.

Regards,

Sanjeev Kumar

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 04, 2011 at 10:01 AM

    That should be possible. You can trigger the second query to run when drilling is done in the related XCelsius graphical component. Parameters to the queries can be binded to specific cells. So your first query wirtes data into the Excel model and the second query uses some if the written values as parameters when it runs.

    I would recommend to take a look at the user's guide:

    http://help.sap.com/businessobject/product_guides/xcelsius2008SP3/en/Xcelsius2008SP3_user_guide_en.pdf

    Regards,

    Stratos

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 04, 2011 at 10:54 AM

    Yes. This is possible.

    Map the result of drill down ie, the brand (selected for drill down), to a cell in the data sheet.

    Then you need to use a combo box with filtered options that has to be hidden, as used in the example shown

    http://xcelsiusandme.blogspot.com/2009/10/xm-sample-15-how-to-display-previous.html

    Regards,

    Anju Saseendran

    Add comment
    10|10000 characters needed characters exceeded