Range prompt parameter hyperlink in Web Intelligence report

[LargePie04]

My range prompt parameter hyperlink that was working on 

SAP BusinessObjects BI Platform 4.3 Support Pack 2 Patch 10 Version : 14.3.2.4537.10

is broken in 

SAP BusinessObjects BI Platform 4.3 Support Pack 4 Patch 6 Version : 14.3.4.5014.6

The working hyperlink was

="<a href=\"../../opendoc/openDocument.jsp?iDocID="+URLEncode("AYSqscJEsZ9LrFFwE5ku22c")+"&sIDType="+URLEncode("CUID")+"&sType="+URLEncode("wid")+"&lsSZSM_PROJECT2="+URLEncode("" +UserResponse([LabFac];"ZSM_PROJECT2";Index))+"&lsRZRM_FYEAR="+URLEncode("" +Replace(UserResponse([LabFac];"ZRM_FYEAR";Index);" - ";".."))+"&sWindow="+URLEncode("Same")+"\" target=\"_self\" nav=\"doc\">"+HTMLEncode("" +[LabFac].[Project Definition].[Project Definition - Key] + " - " + [LabFac].[Project Definition].[Project Definition - Text])+"</a>"

It looks like some items are deprecated in the new version but I tried a few variations and none of them seem to work.

In the new version I tried this, but it's not working. When I remove the fiscal year range bit, it seems to be okay.

="<a href=\"../../opendoc/openDocument.jsp?iDocID="+URLEncode("AYSqscJEsZ9LrFFwE5ku22c")+"&sIDType="+URLEncode("CUID")+"&sRefresh="+URLEncode("Y")+"&lsSProject%20Definition="+URLEncode("" +UserResponse([LabFac];"ZSM_PROJECT2";Index))+"&lsRFiscal%20Year%20Range%3A%20E.g.%20(2000%20-%202010)="+URLEncode("" +Replace(UserResponse([LabFac];"ZRM_FYEAR";Index);" - ";".."))+"\" target=\"_self\" nav=\"doc\">"+HTMLEncode("" +[LabFac].[Project Definition].[Project Definition - Key] + " - " + [LabFac].[Project Definition].[Project Definition - Text])+"</a>"

The resulting link URL it creates is the following. It doesn't work in new patch but works in old patch

link/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=AYSqscJEsZ9LrFFwE5ku22c&sIDType=CUID&lsSZSM_PROJECT2=A10198610000000000&lsRZRM_FYEAR=2022%2E%2E2022

How do I pass in a range prompt in the new version?

Thank you!

[ayman_salem]

Your syntax is incorrect.
Spaces in the prompt Title should be +, not %20

Fiscal Year Range: E.g. (2000 - 2010)

incorrect:

lsRFiscal%20Year%20Range%3A%20E.g.%20(2000%20-%202010)

correct:

lsRFiscal+Year+Range:+E.g.+(2000+-+2010)

Note:  IsR parameter for SAP BW and SAP HANA prompt allow you to specify a range

see examples on Help Page
https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/954ffd91a37d45c093d80dd...

[LargePie04]

Thank you for the reply, however, no luck there as well. I tried the + sign as well as created a new BEx prompt and renamed the entire title to have no spaces or special characters and still no luck. There aren't any issues with %20 in lsS, only in lsR. Also webi itself write the formula with %20.

[MichaelGrackin]

Look into the Authorized URLs option for the Web Intelligence application.  This feature was added in SP3 or SP4.  This MIGHT be the issue.  Just a guess.

[LargePie04]

I've tried that but no luck. The link works fine with "lsS" single prompt. It's only an issue with the "lsR" range prompt. Not sure if there's a new format for it. In the old version the range used to be aaa..bbb (1st value, followed by two periods, followed by 2nd value)