January 17, 2011 at 1:19 am
Need your help, i have built cube but never give proper result especially regarding to date dimension. It has been sorted by month.
this what i try :
select [Measures].[Sales Volume] on 0,
TOPCOUNT([dim Customer].[CustomerName].[CustomerName].Members,10,[Measures].[Sales Volume]) on 1
FROM [IndoporlenDW]
WHERE ([Dim Date].[Date].[Year].[2010])
it doesnt give correct result.
I wonder how to set date dimension on BIDS so it will give correct result.
this is the link of my date dimension
http://tinypic.com/view.php?pic=t86j6d&s=7.
I dont think that the hierarchies work.
Thanks.
January 17, 2011 at 1:56 am
I don't think your hierarchy is built correctly.
It should be year -> month -> date.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 17, 2011 at 2:04 am
Yes, I agree with you. But can you tell me how to fix that? I create the hiearachy, but why it doesnt work?
The attribute relationship is fulldatekey ->Month Name->Year
Thanks
January 17, 2011 at 2:11 am
If you look at the screenshot you'll see that month is at the top, then year, followed by date. This is incorrect, year should be at the top.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 17, 2011 at 3:04 am
Yes, it's fixed now. Thanks.
January 17, 2011 at 3:06 am
AjieLeksono (1/17/2011)
Yes, it's fixed now. Thanks.
No problem, glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply