Open document URL

[Former Member]

Hi,

I have a report with the dimensions: [Name], [Summary], [Create Date], [Last Modified Date], [Submitter], [Count], [Organization], [Group]

and a filter [Name&Operator&Value&Audit] with a formula:

= (    TableA.ATT01_Name = @prompt(P_Name)

AND TableA.ATT01_Operator = @prompt(P_Operator)

AND TableA.ATT01_Value = @prompt('Value',A,,,)

AND TableA.ATT01_Audit = @prompt(P_Audit) )

OR

(    TableA.ATT02_Name = @prompt(P_Name)

AND TableA.ATT02_Operator = @prompt(P_Operator)

AND TableA.ATT02_Value = @prompt('Value',A,,,)

AND TableA.ATT02_Audit = @prompt(P_Audit) )

...OR

(    TableA.ATT50_Name = @prompt(P_Name)

AND TableA.ATT50_Operator = @prompt(P_Operator)

AND TableA.ATT50_Value = @prompt('Value',A,,,)

AND TableA.ATT50_Audit = @prompt(P_Audit) )

I would like to open the report with Open Document. I do not know how I pass the parameter to URL. Help me please

http://.../BOE/OpenDocument/1409232052/OpenDocument/opendoc/Param...???

Moreover, with the filter above, I just can filter the report with only one group of values (Name, Operator, Value, Audit) per a report's execution. If I would like to filter the report with more than one group of values (Name, Operator, Value, Audit), I think I have to create 2 or more copy of the above filter, but it is not a good solution. Please help me.

Thank you.

[former_member207052 · Accepted solution]

Check the Opendoc guide (page 22 is what you are looking for):

https://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_opendocument_en.pdf

Suggestions:

1. Instead on "=" operator, you can use "in" operator and pass multiple values. So this will substitute your requirement of having multiple groups.
2. You can design the web-I query with combined queries option and you can change the filter dimensions in each query. It will make your report look more organized.

[Former Member · Accepted solution]

Thank you,

[Former Member]

Hi,

Check out this document for Open doc parameters

https://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_opendocument_en.pdf

[Former Member]

Thank you Manish Vaswani