Skip to Content
avatar image
Former Member

Open document URL

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    May 27, 2015 at 03:37 AM

    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.


    1.jpg (10.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 27, 2015 at 06:47 AM
    Add comment
    10|10000 characters needed characters exceeded