after much googleing and setting of parameters , member values etc, i am at a dead end
I am trying to get the date filtering for a pivot table working
my time dimension is set to Time
The attribute Date os set to a Type of Date
It's key column is set to a pk value (integer
It's name column is set to a field called dim_date (Wchar but date time in the table structure)
It's value column is set to the same field above dim date (date) Data type is date, and format is short date.
I have processed and deployed my cubes, however when trying to filter using between or any of the other builtin features of excel 2010 to filter by date, it results in no results .
I'm unsure what other setting i need to set to make the filtering work properly. any help is much appreciated.