Skip to Content
0
Jul 28, 2020 at 05:46 AM

filters for Data Manager packages

67 Views

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