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

FM parameter Maps

Started by nayitian, 08 Jan 2008 08:37:27 PM

Previous topic - Next topic

nayitian

Hello all,

I am practicing Lookup function by using Parameter Maps in FM other than within DataManager.
I defined keys and values within a parameter map, and tried to add a new query item by adding caculation. I simply drag parameter to Expression definition, it appears as #$New_parameter_map{}# with error message : QE-DEF-0260 parsing error...

Can anyone educate me how to use this feature to substitue keys ? Thank you.

MFGF

Hi,

You need to provide a key value to perform the lookup on your parameter map - this should be inserted between the braces {}.  For example, if you want to use your current user's language as the key, your macro would be #$New_parameter_map{$runLocale}#

Regards,

MF.
Meep!

mikewalker

Is is possible to substitute a Query Item's value as the key for a parameter map lookup?

For example:

#$New_parameter_map{ [Model].[Folder].[Query Subject].[Query Item] }#

The syntax is not liking it at the moment.

SKAPP

Mike,
Did anyone ever answer your question?  I have the exact same problem.
please and thanks,
Sylvia

mikewalker

I haven't found a solution for this yet, and time hasn't permitted me to investigate it further.

Still if you find any solution I would be interested in hearing how it works...

Good luck



platipuss

Quote from: mikewalker on 10 Mar 2008 01:50:52 AM
Is is possible to substitute a Query Item's value as the key for a parameter map lookup?

For example:

#$New_parameter_map{ [Model].[Folder].[Query Subject].[Query Item] }#

The syntax is not liking it at the moment.


try

#$New_parameter_map{sq([Model].[Folder].[Query Subject].[Query Item])}#

if the key is a string.