Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

macro function CSVIdentityNameList to array

  • 1.  macro function CSVIdentityNameList to array

    Posted 10/22/18 09:05 AM
    Hello, I would like to build a semicolon-separated string (to use as a filter condition) based on entries in the macro function CSVIdentityNameList, so what I tried is the following:

    #csv(grep('COG-Group';array(CSVIdentityNameList(';'))))#

    Apparently the array function does not work. E.G. my CSVIdentityNameList()-function gives back:
    'Admin','PowerUser','COG-Group12345'    the result from the #csv(grep('COG-Group';array(CSVIdentityNameList(';'))))# still is 'Admin','PowerUser','COG-Group12345' 

    My result should be 'COG-Group12345'  so I can build an expression [ColumnName] in ('COG-Group12345')

    Do you have any idea how I can get this?
    Thanks a lot,

    Ole

    ------------------------------
    Ole Schmidt
    ------------------------------

    #CognosAnalyticswithWatson