Prompt Info: Prompt Type = Edit box not honored

[dougp]

Cognos Analytics 11.1.7FP5

I have package from a Framework Manager model where I have defined a query item's [Prompt Info].[Prompt Type] = Edit Box.  I did this because there are over 100,000 distinct values in the column.

When I use this package to create a report with a parameterized filter...

Code Select Expand

[Namespace].[QuerySubject].[QueryItem] = ?parameter?

...and View Tabular Data, Cognos generates the prompt correctly:  I am presented with a textbox.

But I need to combine data from this package with data from another package and from an uploaded spreadsheet, so I create a data module.

When I do the same thing from the data module...

Code Select Expand

[M1].[Namespace].[QuerySubject].[QueryItem] = ?parameter?

...and View Tabular Data, Cognos presents me with a dropdown list.  But only the first 5000 rows are shown.

I don't see a way to control prompting behavior in a data module.  Am I missing it?

Other than changing my filter (hard coding values I want to use for testing) is there a good way to troubleshoot queries when using a data module?

[bus_pass_man]

There's no UI for prompts in data modules. 

[cognostechie]

If you check the properties of a value prompt in a report, you will see that 'rows per page' defaults to 5000. Maybe that's why it shows you maximum 5000 values. You can increase that in the report. I am not a fan of data modules so never explored it other than for excel files.