Hopefully I have the right forum. It's either this or Framework Manager.
In my relational model, I have a table that uses a prompt and a parameter map to determine whether fiscal or offset calendar is used.
Select *
from [CognosDatamart].#$CalendarMap{prompt('Please select a Calendar :','token','Fiscal Calendar','','[Physical Layer].[D_Calendar_Type].[Calendar]')}#
It works fine normally. I create a simple list report and add two columns to the list: Year and Net Sales. Year comes from a dimension that uses the table above. If I run the report, I'm taken to a basic prompt page where I choose between fiscal and offset calendar. So far, it's working well.
Now, I add a required detail filter and a parameter for brand. When I run it, I get as expected.
Now here's the strange part. I add a very basic prompt page and put a prompt for the brand parameter I just created. Now when I run, I don't see the calendar prompt at all. I would have to manually add this prompt. In the past, this prompt would appear after the user clicked "Finish" on the prompt page. This behavior is new to us--the prompt used to always appear on any report that displayed a date field, even though it had a default value.
What's also strange is that I have two reports that use packages from this model. On one report, this problem exists--I have no prompt. On the other report, after clicking "Finish" on the prompt page, you are prompted to select the calendar. I published these packages recently, and verified there were no relevant changes to the FM model. If I build a report and follow the above steps on the "working" report's package, I still lose the prompt. But no matter how many times I run the saved report, the prompt is present. Is there some step in the report I'm missing to force optional prompts to display?
We are running Cognos 10.2.1. I have cleared report parameters from the file menu.