Skip to Content

Scope of Saving a Filter in Member Selector in Data Manager Packages

Dear All,

In thread http://scn.sap.com/thread/3702142 it is mentioned that you can save a filter then use this within a data package avoiding the need to prompt for the user to select members.

Using BPC 10.1 NW SP5, EPM Add-in SP20 patch 2 I have saved a filter and have checked to see if other users can also use the filter.  I have found that they don't.  Although for the user creating the filter, it is available for all packages using the same dimension in the model where the filter is created.

If you are going to link the filter in directly to a script, as per the comment of Vadim Kalinin on 26-Feb-2015 09:04 in thread http://scn.sap.com/thread/3702142, then only users who create a filter with exactly the same name will be able to use the package.

I have been unable to find any documentation about saving of filters within the EPM add-in user guide.

I would like to know how this feature should work, especially when linked to packages via it's script.  It would be good to know where in the system the filter is stored.

Thanks in advance for your input.

Cheers,

Mark

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 27, 2015 at 12:00 PM

    UJA_FILTER is the table to store filters in xml format.

    xml is like:

    <?xml version="1.0" encoding="utf-16"?><asx:abap xmlns:asx="http://www.sap.com/abapxml" version="1.0"><asx:values><ROOT><APPSET_ID>SIM</APPSET_ID><TYPE>M</TYPE><USER_ID>V.KALININ</USER_ID><APPLICATION_ID>INFILE</APPLICATION_ID><DATASET_ID>PERIODS</DATASET_ID><NAME>NODY</NAME><T_SEL_ATTR><UJ0_S_SEL><DIMENSION>PERIODS</DIMENSION><ATTRIBUTE>NUMBER_OF_DAYS</ATTRIBUTE><SIGN>I</SIGN><OPTION>EQ</OPTION><LOW>Y</LOW><HIGH/></UJ0_S_SEL></T_SEL_ATTR><T_SEL_ATTR_LONG/><T_SEL_HIER/><F_OR_MODE>X</F_OR_MODE><DATEFROM>0000-00-00</DATEFROM><DATETO>0000-00-00</DATETO></ROOT></asx:values></asx:abap>

    USER_ID is also a field in UJA_FILTER

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mark,

      Yes, this kind of filter is user dependent. If you want using same filter for multiple users then there is a workaround. You can copy that recordĀ  in UJA_FILTER with a different user ID.This works in case you know list of users who are going to use same filter.

      Usually it's not the case. Only a few users will use same filter value; many users can use same filter type, but different filter values must be created manually.

      Regards,

      Gersh