Passing "Not assigned(#)" value to webi from Dashboard

[former_member200750]

Hi All,

          I have created a Dashboard using Bex Queries in from which I need to pass the parameters to webi. All the parameters are passing correctly to the webi report except when I select Not assigned-"#". By passing the key "#" to the webi report when Not assigned is selected on the dashboard the Webi report is not returning correct results also it is ignoring the other prompts as well when I select the "not assigned".  I understand that the Opendoc URL that we use in Dashboard is Encoded the special character "#" will be converted to something and hence the Webi is not working as expected. Is there a possible solution on the dashboard end or should this issue be addressed at BW level?

Can anyone help me on this issue?

Cheers - Dilip

[Former Member · Accepted solution]

Hi Dilip,

I have gone through the same issue where I had to pass around 7-8 prompts to detail reports and all of them would hold data for "#" value. I was able to pass the"#" value by referring to it as "%23" via URLEncode on opendoc, but it was inconsistent among different browsers, it was working sometimes in explorer and was not working at times and was not working the same in Chrome.

So to avoid such inconsistencies, We have ensured that at BW layer we get the data related to"#" assigned to some dummy value as "UNKNOWN" and after that we converted "#" to "UNKNOWN" on the dashboard too at the dashboard source report layer. So finally we were able to pass "UNKNOWN" value to detail report and get the data related to "#" in the detailed report.

Hope this helps

Thanks

Mallik

[Former Member]

Hi,

Try to make prompt as optional in Webi Report and check whether it will be helpful to you or not. To remove the '#' Character from the URL do it at BEX Query level itself.

Cheers,

Suresh Babu Aluri.

[former_member200750]

Thanks Suresh & Mallikarjuna for your replies. Yup we were about to do the same, changing the # to unknowns or some other character in BW but I wanted to see if there were other alternatives before doing so.

FYI: Some of prompts are mandatory and some are optional and I had to pass # to both of them. I had tried various things and interestingly one of the things worked. Since the prompt is mandatory the webi report accepts "#" and shows it as the text [EMPTY_VALUE] in the prompts window and returns the correct results. For this to happen I had to change the Mandatory Prompt that accepts this "#" value to be the last (order of prompts) meaning the Variable Sequence in the BEX query had to be changed it worked fine. But if you make the same prompt "optional" it won't work when it is optional and if it is the first Prompt then the webi ignores the other prompts values that are being passed to it from dashboard.

Thanks all for your help!

[Former Member]

hi Dilip,

I faced the same issue when passing # to bex query variable to invoke a Bex report at runtime !! but when i pass it via a url, url don't take up characters like "#". SO i tried using %23 but that too didn't work( %23 is the hex value of #)!!

My possible values for that dimension was 1,2,3,4,5,6,7,8,9,#. I wrote a formula in excel stating when the user clicks Not Assigned or # or the input cell for that particular characteristic is #, i hard coded it as !1;!2;!3;!4;!5;!6;!7;!8;!9 so the variable took up #... this works only for launching a Bex report from my dashboard during run-time and my variable type of that characteristic should be selection option !

Try the same for invoking Webi Report, It may work !!! Do let me know if this approach works!!

Regards,

Arathy

[Former Member]

Hi Dilip,

Are you using BEx in dashboard design using Query Browser or Are you developed a WebI report and then connecting to WebI report using BI services?

Please provide more details about the data connection used in dashboard. If possible please attach screen-shot.

Regards,

Aashutosh

[former_member200750]

I built the dashboard using BEX queries by importing them using SAP Netweaver connection in to the dashboard and as for the WEBI report I built it using the BeX Query (using BICS connectivity) that I created.

The dashboard shows the summarized level of data where as the webi shows detail level of data for the same parameters seleceted on the dashboard.

Here's my issue, the below URL is converting #(hash) -> %23 (HEx code value of # - i substituted %23 instead of # in dashboard using Excel logic but nothing worked) and the webi report returns an error or just simply returns empty report though there is data for this selection. Is there a way to resolve this issue without having to change the empty value to some character other than "#" in the BW.

http://server/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=XXXX&sIDType=CUID&sType=wid&sRefresh=...