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
10X Paul M
for the idea, and for fixing my macro.
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:
#$datasourceLookup{substitute(''']','',substitute('package\[\@name=''','',join('',grep ( 'package' , split('/',$modelPath)) ) ))}#