filters for Data Manager packages

[former_member461591]

Hi,

I have a Data Manager TD_EXPORT_TO_FILE package in BPC NW 10. I have removed the prompts and am hard coding the dimension selections. Currently I do this with a list of members as shown here.

INFO(%SELECTION%,/FINANCE_LATROBE/FINANCE/PRIVATEPUBLICATIONS/CSTINSON/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:ACCOUNT||DIMENSION:AUDITTRAIL|AT_BALANCESHEET_PLAN|DIMENSION:COSTCENTRE||DIMENSION:FUNCTIONAL_AREA||DIMENSION:PROFITCENTRE||DIMENSION:PROJECT_TYPE||DIMENSION:RPTCURRENCY|AUD|DIMENSION:TIME|2020.001,2020.002,2020.003,2020.004,2020.005,2020.006,2020.007,2020.008,2020.009,2020.010,2020.011,2020.012|DIMENSION:VERSION|BV2_2020|DIMENSION:WBSELEMENT)

The help tell me I can use a filter as shown here.

INFO(%SELECTION%, //APSHELL_DAVY75_MIT/PLANNING/PrivatePublications/I045795/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:CATEGORY|[FILTER: FILTER_NAME]|DIMENSION:ENTITY||DIMENSION:P_ACCT||DIMENSION:P_ACTIVITY||DIMENSION:P_DATASRC||DIMENSION:RPTCURRENCY||DIMENSION:TIME||)

This seems to say that by setting a filter, I can make multiple selections rather than listing them one by one. However, the help provides no examples of what a "filter_name: represents. I have tried using properties such as LEVEL=MONTH and also tried hierarchical relationships such as BAS(2020.TOTAL) but these have not selected any data. Can somebody point me at examples of how a dimension filter is to be used?

Thanks

Cliff

[former_member186338 · Accepted solution]

1. To use filter you have to save it:

And you can only filter by property!

2. Unfortunately filters are user dependent - another user will not see your filter!

[former_member186338]

Theoretically it's possible to copy filter defined for one user to all users (and to repeat copy for all new users later) with a simple abap program...

[former_member186338]

Alternative can be a simple custom logic badi that will export incoming scope to the text file. Then you can define scope in script logic before badi call.

[former_member461591]

Thank you for that. The inability to use a filter across multiple users is a show stopper for me. None the less, your explanation of how it should be used makes sense.

Cliff