COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: kennedto on 18 Jul 2014 01:16:22 PM

Title: Multi key parameter map
Post by: 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.

Title: Re: Multi key parameter map
Post by: MFGF on 19 Jul 2014 08:47:39 AM
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.
Title: Re: Multi key parameter map
Post by: kennedto on 22 Jul 2014 12:57:04 PM
Can you give me a hint on how to do that?
Title: Re: Multi key parameter map
Post by: MFGF on 23 Jul 2014 03:39:10 AM
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.
Title: Re: Multi key parameter map
Post by: linbai on 23 Jul 2014 04:57:06 AM
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