how to pass multiple values in webi document

[Former Member]

Hi All,

I have got a webi document in this fashion

Tier                                  Household Count             Revenue 

Greater than 1M                         48                              3548454

500k-1M                                      25                             464354

Less than 500K                         29                                  175533

The above field Household Count is nothing but Count([Household Id]), i.e. we have 48 household's whose value is greater than 1M.

Now I have another document , document 2 with household id related data, my question is how do I link them respectively. For example if I click on 48 it should give related data to those 48 household's. Please help me out.

[Former Member]

Yes, open doc and most likly a dummy filter of sorts, unless you  have that "greater than 1 mil"/etc dimension in your data.  So you would pass something like A,B,C to the 2nd report, and it would know what to filter based on the A/B/C values. 

[former_member198519]

Pass it using open doc link. Attached is a guide for the same:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0daee1d-0e38-2d10-0c91-8bb4ab5aa...

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

[Former Member]

Im not successful using opendoc link, can you be more specific

[former_member198519]

Did you had a look at the first link in my post. it shows you how to pass a single/ Multiple value from one document to another.

[Former Member]

I had a look into it, Im getting #multiplevalue instead of the hyperlink

[former_member198519]

Can you share the screenshot of where you are getting #multivalue Error

[Former Member]

What are you trying to pass? Like I said earlier, you will have to pass some static values or the category you are using...you can't pass something that's on mulitple records from your summarized line. 

Another good way to setup opendoc is to use the HTML WEBI editor, not the Rich Client or Java web.  Go to Design mode, right click on the table cell where you want to create your hyperlink and go to Linking> Add hyper link  - much easier this way than to write the syntax yourself.  

[Former Member]

Passing from summarized values is something I'm looking for, i.e. if you have a look at my actual post, Household count is Count(Household Id), for example In the Tier >$1M I have 48 households, so if I click on 48 I should get into the report 2 where I have that 48 households data, similarly clicking on 25 should get 25 households data. Is there any way to achieve this???