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...
[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...
[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?
There's no UI for prompts in data modules.
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.