How to create a date prompt for dimensional model data?

[ReportWriter]

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!

[MFGF]

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.

[JulioSarmiento]

ReportWriter;

I have the same issue.  Have you found the correct way of doing this?

Thanks,
Julio