cancel
Showing results for 
Search instead for 
Did you mean: 

Using Row Selection in Analysis Web Item & Filter Command

Former Member
0 Kudos

In the 7.0 WAD (Web Application Designer), I have two analysis items that both have different data providers, DP_1 & DP_2. The two data providers are views from the same query.

In the properties of the first analysis item (DP_1), I'm using the Row Selection - 'Single with Commands', and I want to have a command that will filter on the value of the characteristic in the row selected and transfer that filter to the second analysis itme (DP_2). Is this possible?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

And if I want to select single to another URL? How can I change this?

Former Member
0 Kudos

Hi,

i had a similar issue.

I just created some variables for the second DP-query for selecting the appropriate line(s).

At the row selection i just used SET_SELECTION_STATE in combination with a data binding.

So just choose for all variables the binding based on the appropriate variable, Type SELECTION_BINDING, ITEM_CHARACTERISTICS, your first analysis table and the characteristic.

For us it works fine.

Former Member
0 Kudos

Hi,

I have set up an RRI command and when I click on the command, my receiver web template does show up in a seperate window. However, it does not pick up my selection criteria. I tried the set_selection_state and it still didn't work. Any suggestions?

Former Member
0 Kudos

Hi Ryan,

We have a similar requiremnt. Were you able to achieve this.

Thanks

Ashwin

Former Member
0 Kudos

I have not been able to do this yet. Please inform me if you make progress. Thanks

Former Member
0 Kudos

yes, you can do this. There is XHTML code:

<bi:SET_SELECTION_STATE_BY_BINDING xmlns:bi="http://xml.sap.com/2005/01/bi/wad/bisp">

<bi:TARGET_DATA_PROVIDER_REF_LIST type="ORDEREDLIST">

// target data_provider:

<bi:TARGET_DATA_PROVIDER_REF index="1" value="DP_2">

</bi:TARGET_DATA_PROVIDER_REF>

</bi:TARGET_DATA_PROVIDER_REF_LIST>

<bi:SELECTION_BINDINGS type="UNORDEREDLIST">

<bi:SELECTION_BINDING type="COMPOSITE" index="1">

// target infoobject

<bi:CHARACTERISTIC value="0DOC_ITEM__0VENDOR" text="0DOC_ITEM__0VENDOR">

</bi:CHARACTERISTIC>

// selection type

<bi:SELECTION_BINDING_TYPE type="CHOICE" value="ITEM_CHARACTERISTIC">

<bi:ITEM_CHARACTERISTIC type="COMPOSITE">

// source analysis table

<bi:ITEM_REF value="ANALYSIS_ITEM_1">

</bi:ITEM_REF>

// source infoobject

<bi:CHARACTERISTIC value="0DOC_ITEM__0VENDOR" text="0DOC_ITEM__0VENDOR">

</bi:CHARACTERISTIC>

</bi:ITEM_CHARACTERISTIC>

</bi:SELECTION_BINDING_TYPE>

</bi:SELECTION_BINDING>

</bi:SELECTION_BINDINGS>

</bi:SET_SELECTION_STATE_BY_BINDING>

Or you can do this using command wizard! good luck!