If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Multi key parameter map

Started by kennedto, 18 Jul 2014 01:16:22 PM

Previous topic - Next topic

kennedto

I have a table that requires two keys to get the value.   I see a parameter map only allows one key. 
Is there some way (preferably a function) that I can use to get the value from a table with multiple keys.


MFGF

Quote from: kennedto on 18 Jul 2014 01:16:22 PM
I have a table that requires two keys to get the value.   I see a parameter map only allows one key. 
Is there some way (preferably a function) that I can use to get the value from a table with multiple keys.

I think your best approach to solving this is to concatenate the multiple keys into a single value and use this to reference the parameter map.

Cheers!

MF.
Meep!

kennedto

Can you give me a hint on how to do that?

MFGF

Quote from: kennedto on 22 Jul 2014 12:57:04 PM
Can you give me a hint on how to do that?

If you can give us an idea of what you need and how you plan to reference the parameter map, then maybe :)

MF.
Meep!

linbai

Quote from: kennedto on 22 Jul 2014 12:57:04 PM
Can you give me a hint on how to do that?
1. Open the model in Framework Manager.
2. Click the table name, and then edit  SQL  to concatenate the multiple keys into a single