Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Dimension detail values browsing issue

Author  Topic 

learntsql

524 Posts

Posted - 2014-03-19 : 10:04:05
Hi all,

I have an hierarchy called date for Time dimension.
which contains Year-->Quarter-->Month-->Week.
When i see the measure without time dimension used iam geeting proper results.
but when i see at detail level means by filtering by year then i am not getting proper results.
Do i need to do any seetting at dimension level?
Can someone pelease guide me.

Thanks in advance.

sqlsaga
Yak Posting Veteran

93 Posts

Posted - 2014-03-27 : 12:00:24
what do you mean when you say not getting proper results. can you show an example or at least a screen shot of before or after?? Just adding a hierarchy or a new dimension wouldn't hurt much when you have all the relationships specified correctly.

Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.
Go to Top of Page

learntsql

524 Posts

Posted - 2014-04-01 : 03:21:30
Thank you for the reply.
As you said i tried with changing the relationships and now its working fine.

Thanks a lot fot the valueble suggestion.
Go to Top of Page
   

- Advertisement -