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

[Former Member]

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

[former_member186338 · Accepted solution]

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

[Former Member · Accepted solution]

Dear Vadim,

If the filter can only be scoped to a specific user, then using it within a DM script seems quite unworkable.

Regards,

Mark

[former_member186338 · Accepted solution]

If we are talking about some scheduled DM package (like retract in the mentioned link) then filter is fine (the package will be launched always under specific user).

For general purpose DM packages this trick is not very useful...

Vadim

[Former Member · Accepted solution]

Isn't it easier to hard code the selection directly into the DB script rather than have an additional saved filter?

[former_member186338 · Accepted solution]

If you have a fixed list of members - then you can put this list directly in the advanced DM script.

But sometimes you don't have a fixed list - new members are added each day. Then filter based on the property can be a good option!

Vadim

[former_member200327 · Accepted solution]

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