Query Browser - How to Pass Range and Multiple Values to Prompts?

[former_member221140]

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

[former_member194862]

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

[former_member221140]

Hi Amit,

Thanks for reading and for the reply,

yes, this is the case, I tried mapping the Query Browser prompt to read the excel cell with the values concatenated and separated by semicolon. It works like this using BICS, but not when connected via Query Browser to the variable prompt

[former_member194862]

Hi Gary,

You must be passing the text so for testing purpose just hardcode values of the corresponding keys in the excel separated with semicolon for the prompt values and check if it works.

Amit

[Former Member]

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

[former_member221140]

Hey Amit,

I can assure it is keys. I am passing material numbers, movement types, and dates in dd/mm/yyyy format to my variables.

[former_member221140]

Hi Abhilasha,

I don't get the option to add it as a prompt as I must bind it to a cell in the spreadsheet due to logic on the excel side.

[Former Member]

If you  check the properties of Query prompt selector you can insert the selected value in the destination i.e. excel cell.

Will this help??

[former_member221140]

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)

[Former Member]

ever get this to work?  what you tried last sounds like the opposite of what you originally intended. 

[former_member221140]

yes! for passing to interval variables you have to put both values in separate cells E.g. In A1 1234 in B1 456 then map the interval variable to A1:B1. For selection options, 1234; 456 in the same cell and map that should do it. (note the space after ";")