dbTalk Databases Forums  

Problem with Date Heirarchy on year level - SSAS 2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Problem with Date Heirarchy on year level - SSAS 2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hwinzelberg@gmail.com
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.