Hi,
I did create a sample dashboard. With just ComboBox and a spreadsheet table to show data.
The Data is coming from BI service and using Qaaws in the xcelsius Data tab. There is a Month dimension object in webi which has been set as prompt (values: Jan, Feb, Mar and Apr)
In the excel sheet, I have put in the values for the prompt and cell G1 is where the Combo Box will throw the selected value.
However, it is not working so far. Now , how should I tie the prompt filter to the tab below?I had mapped to cell G1 earlier for the highlighted object (valueofPrompt).
It didnt work.need help!!!
Launch Webi Rich Client, select Universe as a document source and click on Next.
Select the desired universe from the list of available universes and click on OK.
Drag City to Result Objects pane and State to Query Filters pane.
Change State filter to Equal to.
Make State filter as Prompt.
Click on Run Query
Select prompt value and click on Run Query.
Notice the query result.
Now export the Web Intelligence Report to CMS.
Right click on the block and select Publish Block.
Click on Next.
Make sure Enter State is checked and click on Next. This is the prompt for our BIWS.
Now enter the name and click on Set Filters.
Uncheck City and click on OK.
Click on Next.
Select a location to save Web Service and click on Create.
Enter Web service name and click on OK.
Test2 web service is created successfully.
Click on Finish.
Now select Show BI Services from the right top corner.
Notice that the Web Service Publisher window appears.
Note: WSDL URL is the url of the web service Test2 that we just created.
Now launch Query As A Web Service tool. Notice that Test2 BIWS is listed under QaaWS. Select Test2 and click on To Clipboard.
Launch Xcelsius designer, go to Data Manager and add new Query As A Web Service Connection. Paste the copied query in front of WSDL URL and click on Import button.
Bind query output with excel spreadsheet.
Bind query prompt with excel cell B1 and pass State value DC to the query.
Pass refresh= true to the query.
Go to Usage tab and check Refresh Before Components Are Loaded.
Take Spreadsheet table component on canvas and map its Display Data with query output in excel spreadsheet.
Preview the dashboard. Notice that the dashboard shows list of Cities for the State DC.
I am able to see the cities of DC as you said, but I tried out the below scenarios
when I try to change the state as Texas and preview the dashboards refresh is not happeninng automatically. I will have to bind refresh to TRUE for every run when I make a change in the prompt value
My requirement is prompt should accept the dropdown selected values in the run time which is not happening when the dropdown selected value is binded to valueOfPrompt as Darren has mentioned below.
what needs to be done to make the prompt to accept the dropdown selected value ???
(BOB member since 2013-02-22)
(BOB member since 2012-07-13)