on 07-29-2014 2:45 PM
Hello,
I am on Dashboards 4.1 SP4 (same with the BI platform). I originally built the current dashboard I am working on using BICS connections to BEx queries. Doh! I forgot I will ultimately have to publish this on BOE, so of course BICS to BEx queries doesn't work in BOE, no BEx wrapper. I find the BEx --> Universe --> QaaWS route quite cumbersome to connect the dashboard to BEx queries so I started trying to do it using the Query Browser, which I've never used before.
I have a few variables for one of my many queries. These variables for this query are intervals and selection options. I can't seem to get it working with passing a range or with multiple single values in the same way you would for BICS.
For passing intervals I am using the method of concatenating a " - " between my start and end range values.
For passing single values for my selection options I am padding each value with a "; " to delimit them.
On to my question...
This method isn't working, what do I have to do to pass both interval values and selection options (multiple single values) to a BEx query prompts connected to dashboards using the Query Browser?
Cheers,
Gary
Hi Gary,
In the query browser you can map the BW variable selected values option to the excel cell.
This cell has all the values for the variable hardcoded separated by semicolon.
Let me know if this is the case.
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gary,
Have you tried using the Query prompt selector component ??
Go to query browser, expand the query, select the prompt variable click on it and drag to canvas.
Else select Query prompt selector from the components and later go to its properties to map it to the desired prompt variable.
Let us know if this helps you or what is the behavior.
Regards,
Abhilasha
Out of curiosity I tried doing this. I removed my Selected Values assignments and dragged in Query Prompt selectors for each variable. I then selected excel cells for "Insert List of Values" When I click the apply button on the query prompt selectors, I don't see anything being outputted to the locations I designated. (Watching the cells using a list view)
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.