Problem with Date Heirarchy on year level - SSAS 2005 -
08-24-2006
, 02:19 PM
Hi,
I have SSAS 2005 with SP1. I am having an issue with the Date
heirarchy when a Year level is on the Rows or Columns and I try to
filter by another dimension - sometimes I just get blanks.
For eample: My sales cube has a simple Dimension called OrderTypes
(joined directly to fact table). When I have the Year of my Date
heirarchy on the Rows and ShipQty as a meaure and I pull in the
OrderTypes dimension into the Page filter or even if I pull it in as a
nested row. The years disappear and I just get blanks.
This is not a problem i I just pull in Quarters , weeks etc.. Also it
does not happen with every dimension filter.
Any ideas? I would really appreciate any help.
Thanks,
HaroldW |