on 04-26-2010 8:22 AM
Dear All,
I am passing one value (Fiscal Year) to WebI from Xcelsius URL Button.
http://<Server>:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=ATJUDThT5S5DivTWVfoq6Rs&sIDType=CU...Year(SingleValueEntry,+Required):= [K4/2010]
When I click on this, I am able to open Infoview and even the report in which I want to pass parameter value, But the report is not getting refreshed with newer value (In this Case 2010).
My Prompt Name is Fiscal Year (Single Value Entry, Required) and technical name is 0P_FYEAR, I have used both the name technical & Description to pass the Parameter, but could not success.
Can anyone tell me how I can resolve my problem?
Hi,
I am having the same problems passing the cell values from 1 Webi report to another target Webi report using OpenDocument on BW universes. The target Webi report returns no data another I can confirm OpenDocument has successfully passed a value into the prompt. I have tried the BW key, name, and medium text but the target Webi returns no data. Any information would be appreciated, thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please try to pass the key.
Regards,
Stratos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
this should be the technical name fo the value. WHat you can do is to activate the tracing of the MDX query and runs the report with the desired parameter values. Then you can check how the values are inserted in the MDX statement and use the same format when adding them into your openDocument statement.
Please take a look at the folloowing SAP notes about how to activate tracing in WebI
Unix : Note 1235111
Windows : Note 1260004
(http://service.sap.com/notes)
Regards,
Stratos
HI Stratos,
Thanks for another help. I got the log details and key for the parameter value.
I found below syntax for Parameter from SOFA.log file,
<FILTER KEY="[0P_FYEAR]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="[0FISCYEAR].[K42010]"/></CONDITION></FILTER>
and according to above syntax, I have change my URL Link to
http:/<Server>:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=ATJUDThT5S5DivTWVfoq6Rs&sIDType=CUID&lsS[0P_FYEAR]=[0FISCYEAR].[K42010]&sRefresh=Y
but still I am not able to refresh the report with 2010 value.
Can you please look into the above link and please let me knew where I am doing something wrong.
Regards,
Rishit Kamdar
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
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.