database connection - how to pass parameter name as a databasename in pentaho BA Server? -


i have scenario have 1 table in 1 database consist database names,so in drop-down container displaying database name, in query want pass database name parameter , want retrieve data respected table.

note : database structure same every client, security reasons have created different databases

query 1 : using database names.

select tenant kscommon.organization; 

query 2 : tenant parameter next query

select location ${tenant}.organization; 

but getting error(error processing component)

so can guide me on this?

i have tried scenario unable achieve according experience can use parameter in query conditions only. not able use parameter name while creating database connection because if doing means trying create multiple database connections during query level believe pentaho doesn't support @ present. in cde can explicitly create multiple connections , try use when ever required.

still can wait other answer question.


Comments