I have a query subject with query item containing a macro. The purpose of this macro is to prompt the user to select a table name that they want to retreive the information from.
Expression insude the query item:
[LogicalLayer].#SB(PROMPT('Year', 'token', 'NoYear')+' Customer')#.[Id]
We have seperate table for each transaction year.
This query item is used in the report to prompt user to input a value for 'Year'. Based on their selection, the right table gets hit. Example: when user enters'2002', this macro pulls information from 2002 table because the above macro is points to '[LogicalLayer].[2002 Customer].[Id]'
The report works perfectly, problem is when I try to validate the query subject in FM. When I click validate, it keeps throuwing the prompt page to enter 'Year' again and again. I provided a dummy value called 'NoYear' which is another query subject with no data but still it doesnt take the default value while validation. any ideas?
hi
Which version of Cognos are you using?
Are you facing the same issue documented here for Cognos 10.2.1. "When prompt macro like below is included in a query subject,modelers are unable to validate/test it in Framework Manager.?Even though prompt value is set, prompt screen appears again
and again....."
http://www-01.ibm.com/support/docview.wss?uid=swg1PM92304 (http://www-01.ibm.com/support/docview.wss?uid=swg1PM92304)
Solution for which is "Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack "
Check this.