OpenDoc for Range of values

[Former Member]

Hi Experts,
 
I have a requirement of calling a  child webi document by passing a Range of values for Category from my webi using Opendoc.
 
So in the webi report created a prompt for Category with Inlist as operator with optional promt.
 
I created the below URL to access the child webi from webi but it not taking the specified range. Instead of that it always asking for prompt values.

To access the webi report -

http:../../opendoc/openDocument.jsp?sIDType=CUID&iDocID=ATmmMaij5dREu9oSzlCkPEs&sReportName=AC&sRefresh=Y&lsREnterCategory=[6000..6009]

please suggest whether anything is wrong in my URL syntax or in the webi prompt operator.
 

Thanks in advance

Prasanna.

[Former Member · Accepted solution]

Hi Prasanna

check this bellow document

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0daee1d-0e38-2d10-0c91-8bb4ab5aa...

[Former Member]

Hi Prasanna

  If you are still having trouble with passing the range of numbers, try capturing the minimum and maximum values in the report

ie; create two variables

RangeMin=min (UserResponse([value]))

RangeMax=max(UserResponse([value]))

Now you get the minimum and maximum values. Now in child report create the [Category] in between prompt  and try to pass the 2 values (Rangemin and Rangemax) to those fields.That should work.

Let me know if it works.

Cheers!

[Former Member]

Hi Josh,

Thanks for Reply

where I need to create these two variables at report level or universe level

1. If it is at universe level then I  don't have access to universe

2. If it is at report level then how can I pass these two variables in to query panel level to give prompt.

Can please elaborate your view a bit more clarity..

Thanks..

[Former Member]

Hi Prasanna

  You have to create those variables at the report level.

Ok so you have parent report and child report.

You jump from parent to child report ie; you are passing your values from Parent to child report.

So to pass the max and min values you need to capture that in the parent report.So you create the 2 variables in the parent report as described earlier.

RangeMin=min (UserResponse([value]))

RangeMax=max(UserResponse([value]))

Now in the child report you need to capture your range but you can get the max and min values from the parent report.

So create a filter for the [Category] and function [Between]  and make those both boxes as prompts and enter the prompt statement in the 2 boxes like Enter_Min_value and Enter_Max_value.

Now go back to the parent report and create the hyperlink/opendoc linking and create 2 parameters (  lsSEnter_Min_value=[Rangemin]&lsSEnter_Max_value=[RangeMax]  )

So that should do it. Also if you want to include the min and max values as well you can change the variables to

RangeMin=min (UserResponse([value]))-1

RangeMax=max(UserResponse([value]))+1

and then do the between function so it includes those numbers as well.

Let me know if this works out.

Cheers!

[Former Member]

Hi Prasanna,

Please check your URL

lsM[Name] — Used to specify a prompt with multiple values, such as an “In List” or “Not In List”

http://<servername>:<port>/OpenDocument/opendoc/openDocument.jsp?

sDocName=World+Sales+Report&lsSEnter+Year=2010
&lsMEnter+States=[Pennsylvania],[Maryland]

Thanks,

[Former Member]

HI Shankar,

Thanks for reply

I think lsM is for muliple values there we need to specify the list of values like lsMEnterCategory=[6000],[6001], but her I need to give range of values as a prompt category range in 6000 to 6999