macro in data source property "contant manager data source"

[BenziD]

Hi all
my scenario is as follow :
DB-1 with proxy_User-1 (connection 1)
DB-1 with proxy_User-1 (connection 1) -> segment (shared dim's)
DB-2 with proxy_User-2 (connaection 2)

when i pull data from DB-2 i want to use connection 2

to avoid "limited local processing" i tried to place a macro based on the package name (idea from one of the guru's), that didnt work  :'(

what can i use as Identifier for the macro ?

thanks B

[BenziD]

10X Paul M

for the idea, and for fixing my macro.

[CognosPaul]

For everyone else, Benzi was trying to dynamically change the datasource based on the package. In this case I advised him to create a parameter map with the package names and datasources. Once that was created, the data source was changed to:

Code Select Expand

#$datasourceLookup{substitute(''']','',substitute('package\[\@name=''','',join('',grep ( 'package' , split('/',$modelPath)) ) ))}#