Skip to Content
author's profile photo Former Member
Former Member

question on dataproviders & filters

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 24, 2004 at 03:39 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 24, 2004 at 04:16 PM

    Thanks for answering most of my questions so promptly

    Prasad

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2004 at 11:15 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.