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

Weird--Disappearing Prompt

Started by gpollock, 31 Jul 2015 04:44:38 PM

Previous topic - Next topic

gpollock

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.