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.
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.
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.
Mike,
Did anyone ever answer your question? I have the exact same problem.
please and thanks,
Sylvia
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
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.