Skip to Content
author's profile photo Former Member
0
Former Member

Xcelsius 2008 SP3 with SAP BW

Posted on May 04, 2011 at 09:38 AM 11 Views

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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Efstratios Karaivazoglou
    Efstratios Karaivazoglou
    Posted on May 04, 2011 at 10:01 AM
    1

    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 a comment
    10|10000 characters needed characters exceeded

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

    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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.