on 04-06-2011 7:41 AM
hi
i have a webi where i need to link two more reports based on if .. then ...else condition, here is my scenario,
Name amount
A 100
B 200
I have to create to a hyperlink on name object, so it should link to the next report based on its cell value like,
if name = A then link Report2
if name = B then link Report3
Else link Report4
is this possible ?
how to get this in open document syntax ?
Regards
Dineshkumar
Hi Dinesh,
refer to http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_opendocument_en.pdf
for more info on Opendocs.
Thanks,
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
=If [name]="A" Then "<a href=http://yourservername:portnumber/OpenDocument/opendoc/openDocument.jsp?iDocID=yourReport2Id&sWindow=New&sKind=FullClient>MyLink</a>"
Else If [name]="B" Then "<a href=http://yourservername:portnumber/OpenDocument/opendoc/openDocument.jsp?iDocID=yourReport3Id&sWindow=New&sKind=FullClient>MyLink</a>" Else "<a href=http://yourservername:portnumber/OpenDocument/opendoc/openDocument.jsp?iDocID=yourReport4Id&sWindow=New&sKind=FullClient>MyLink</a>"
where yourReport2Id is the Id number of Report2, you can find it right clicking on Report2 to see its properties. There you can find wht's the numeric Id of the report.
Same applies to Report3 and Report4, you have to write down their Id numbers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't know the correct syntax for openDocument, I let you create them.
About the condition, in a column of the tab I should go like this.
if [mydimension] = "A" then "openDocumentLinktoreportA" else if [mydimension] = "B" then "openDocumentLinktoreportB" else "openDocumentLinktoreportB"
I think you should right click your cell and select "HTML text" in the properties.
I prefer to use alterters for colors and format a text.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try to apply alerter here Name = A than in formate paste the hyperlink for report Report 2
In the same alerter now add another Alert
Name = B than in formate paste the hyperlink for report 3
now add another subAlert
Name "Not in List A and B han in formate paste the hyperlink for report 4
Whenever you click on any value in the Name column it will open the respected Report.
Try this hope this will work out for you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.