Does anybody know how to use this macro function CSVIdentityNameList() ?!
I've done this filter on two namespace: on the first it work good. On the second one, i've copied these rows ..and the filter doesn't work!!
-- StartCode:
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL0] in_range {#CSVIdentityNameList()#}
or
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL1] in_range {#CSVIdentityNameList()#}
or
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL2] in_range {#CSVIdentityNameList()#}
or
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL5] in_range {#CSVIdentityNameList()#}
or
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL9] in_range {#CSVIdentityNameList()#}
-- EndCode
Thanks all in advance,
ADM
I solved the problem!!
By defalut in this Macro Function, CogNos need a separator, and this is ",".
In my first namespace this was unchanged!
But in tha second this was ";" !
Then, changing the code in
-- Start code:
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL0] in_range {#CSVIdentityNameList(";")#}
or
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL1] in_range {#CSVIdentityNameList(";")#}
or
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL2] in_range {#CSVIdentityNameList(";")#}
or
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL5] in_range {#CSVIdentityNameList(";")#}
or
[EDW_CIO_TDD_GESTOR].[DESCR_LEVEL9] in_range {#CSVIdentityNameList(";")#}
-- End code
FM can execute this filter!!
It works! ;)
hi, can we use a formula to control the data security like this.
IF ( 'STG Solution Stack Trusted Viewers' IN ( #CSVIdentityNameList()# ))>0 THEN ( [Metadata Layer].
[Applications].[PIPELINE_GA] IN ('Pipeline','GA','Parking Lot' )) ELSE ( [Metadata Layer].[Applications].
[PIPELINE_GA] = 'GA' )