Hello experts,
Can you please help?
I'm creating a Data Item using following syntax to get name of all the folders exists under Public folder using Run Reports table of cognos 10 Audit package but currently it does not display any folder names that was working fine before migrating into new server.
Data Item Code:-
if([Audit].[Run Reports].[Report search path] like '/content/folder[@name=''Public
Folders'']/folder[@name=%')
then (substring ( [Audit].[Run Reports].[Report search path] , (character_length ('/content/folder[@name=''Public Folders'']/folder#@name=''')+1) , ( position (']',
substring ( [Audit].[Run Reports].[Report search path] , character_length ('/content/folder [@name=''Public Folders'']/folder#@name=') ) )- 4 ) ))
else ('Other')
If it was working fine before what is it doing now? Error? What's the error?
New server, are there folders to list?