problem with validating a query subject in FM

[vvasireddy9]

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?

[pramodb]

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

Solution for which is "Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack "

Check this.