Hi,

This might be quite simple, but I do not know how to solve my issue.

I am creating an OLAP cube from an external data source as the number of
records are over 200k.

Assume 3 fields.
department, employee, date, amount.

Amount is summed at the department, employee, date dimensions.

In choosing the dimensions, I think I only have the choice of grouping the
date field.
The Olap cubing process then stores the date dimension at the year, month,
day level. However, in the pivot table I have to click on each year, month,
and then day to see the details.

Instead, I would like to see the date in the pivot table with no grouping
(i.e. 07/13/2007).

Is this possible?

Many thanks.