question on dataproviders & filters

[Former Member]

Hi

In a url like :

//http:....&CMD=LDOC&TEMPLATE_id=TP2&FILTER_IOBJNM_1=F1&FILTER_VALUE_1=FV1&FILTER_IOBJNM_2=F1&FILTER_VALUE_2=FV2&FILTER_IOBJNM_3=F1&FILTER_VALUE_3=FV3

if there are 2 dataproviders in the template -say DP1 & DP2

if i dont give the Dataproviders in the url do the filters get applied to the whole templAte?.

HOW do i target a particular filter to a specific dataprovider.

secondly I dont want to hide the filtered column .

if i say '&CMD=EXPAND' instead of &CMD=LDOC will it work.

or do i have to have a command sequence with both ?

thirdly if i add a nav block for drilling down one of the tables is there a setting for displaying the hidden (filtered) column in a particular location -as defined in query.currently it shows up in the table before the key figures at the end when i press the drill dow icon on nav bloc.

finally do i use variables instead of filters?

further background:

I have a template say TP2 to be displayed with 3 tables T1, T2, T3, each with different data providers say DP1, DP2, DP3

T1 is the parent of T2 & T3 i.e. T2 & t3 are triggered by differnt charcteristics(columns) of T1.

TP2 is called by another template TP1 containing table say TA with Data provider DP1.

T1 (in template TP2) is actually TA with just the 1 row selected in the TP1

I have a Table modify class & Characteristic_cell for Table TA in se24

The url is created in the Charcteristic_cell method for table TA(in TP1) . where im getting 2 filter values by clicking on just one cell(the second filter comes form another column of table TA in the row selected)

any help appreciated

Prasad Badal

[Former Member]

Hi,

In a similar vein I am have been trying to use either the 'Expand' or 'SET_NAV_STATE' commands to show a further characteristic dependent on the user selection in a BSP. The command lines I have tried are as follows:

I post a form from a BSP page with the 'action' value set to <%= webAddress %>&CMD=LDOC<%= templateID %><%= command %> where webaddress is the address of the BW server and templateID is the Web template. I have then tried the following command lines to try and alter the two data providers navigational state.

This command doesn't change anything:

'&CMD1=SET_NAV_STATE%26DATA_PROVIDER%3DDATAPROVIDER_1%26ALL%3DX%26IOBJNM_1%3DZC_FUNCID__ZC_BUGRID%26AXIS_1%3DY&CMD2=SET_NAV_STATE%26DATA_PROVIDER%3DDATAPROVIDER_1%26ALL%3DX%26IOBJNM_1%3DZC_FUNCID__ZC_BUGRID%26AXIS_1%3DY'

This command line returns the error 'Error loading item TABLE_1.'

'&CMD1=SET_NAV_STATE&DATA_PROVIDER=DATAPROVIDER_1&ALL=X&IOBJNM_1=ZC_FUNCID__ZC_BUGRID&AXIS_1=Y&CMD2=SET_NAV_STATE&DATA_PROVIDER=DATAPROVIDER_2&ALL=X&IOBJNM_1=ZC_FUNCID__ZC_BUGRID&AXIS_1=Y'.

I have also tried adding the command lines as hidden fields in the form and still nothing happens.

The queries are made up of a structure in the rows and the characteristics I am trying to add are in the free characteristics with a few amount fields for columns.

Any help would be greatly appreciated.

Regards

Paul.

[Former Member]

Thanks for answering most of my questions so promptly

Prasad

[Former Member]

Hi,

here the answers:

a) If you apply the filter-command at the ldoc command the filter will be distributed to all dataproviders (please see http://help.sap.com/saphelp_nw04/helpdata/en/27/6c013a53271a05e10000000a11402f/frameset.htm )

b) to specify a specific dataProvider you have to use a command sequence

for example:

//http:....&CMD=LDOC&TEMPLATE_id=TP2&cmd_1=FILTER_IOBJNM_1%3dF1%26FILTER_VALUE_1%3dFV1%26data_provider%3dDP2

c) for not removing the filter from the drill-Down use the parameter filter_collapse

http://help.sap.com/saphelp_nw04/helpdata/en/59/edfe395dd76846e10000000a114084/frameset.htm

d) The Navigation block uses the command expand. The expand command will always add the characteristic on the last position. If you want to change the behaviour you have to program a table Interface class for the navigation block with your own command logic (command SET_NAV_STATE; you have to find the correct position in your ABAP logic)

http://help.sap.com/saphelp_nw04/helpdata/en/fa/09433ab9fb960ee10000000a11402f/frameset.htm

e) I don't understand your question about the variables.

Heike