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
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:
Regards,
Stratos
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