All the examples in Cognos manuals show how to use date prompt for relational model data, but how to use it with dimensional data?
In Order Date dimension I have Order Date hierarchy, and then Year, Month and Day. I drag date prompt to the prompt page, create a new parameter, and then I'm stuck with choosing package item... I can't choose Day hierarchy (message: "The Date Prompt is not compatible with this type of query item."). Should I choose Day - Long Name query item or what?
I need to create a date prompt using day level data (yyyy/mm/dd), where you choose starting and ending point.
I can create it using value prompts, but don't know how to use the calendar type prompt (date prompt).
I thought this would have been pretty easy, but somehow I can't get it work.
Thanks in advance!
Hi,
I think the issue here is that the day level of your Order Date dimension is not defined as a data datatype in the underlying data source. The way I see it, you have a couple of options:
1. Define a filter of the form:
[Package],[Dimension].[Hierarchy] -> ?Param? then use a tree prompt to fulfil the parameter, or
2. Use the _make_timestamp function in a calculation in your report to create a date item, then filter on this and use in a date prompt (but this will be much less efficient).
Best regards,
MF.
ReportWriter;
I have the same issue. Have you found the correct way of doing this?
Thanks,
Julio