Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SSAS Time Dimension

 
   Database Forums (Home) -> Data Warehouse RSS
Next:  Can't Connect to Remote Server Via Visual Basic 2..  
Author Message
Melchiorsen

External


Since: Jan 29, 2008
Posts: 1



(Msg. 1) Posted: Tue Jan 29, 2008 12:00 pm
Post subject: SSAS Time Dimension
Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)

I have made a server time dimension. I am using only the ReportingYear,
ReportingMonth, ReportingWeek, Date. I am using the Weeks544 and the week is
starting on sunday. The problem is that week 1 in 2008 starts on sunday 6th
january which is wrong, it should start on sunday 30th december 2007.
So the Hieracy should look like this:
-2008
--January
---Week1
----Sunday 30th December 2007
----Monday 31th December 2007
----Thuesday 1st January 2008
---- etc

It is on a SSAS 2005

I was under the assumption that the first week of the year was the one with
thursday in it.

Anyone know how I can change this? without making my own source dimension
table.

 >> Stay informed about: SSAS Time Dimension 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SSAS problem for grouping inside dimension - I have a dimension which contains student details and the no of rows is about 1600000, now in a normal dimension it allows 64000 rows, if more rows were there in 2000 analysis services then grouping was done under level properties so as to specify..

Error during processing a dimension attribute in SSAS 2005 - I'm using SSAS 2005. I have a dwh in SQL Server 2000 and I have built the cube and the dimesions in SSAS 2005. During the distribution I have an error message about during the processing of a dimension attribute of the db in SSAS. Where I can see..

Modifying a dimension attribute to create a key attribute .. - I have a cube in SSAS 2005. I have some dimensions table with some attributes like code and related descriptions. I want change each code attribute in order to link to the related description attribute. I know that I must modify each code attribute in ...

[SSAS] Display no measure for time aggregation? - Hi, I have daily mesures that I do not want to aggregate (sum or whatever) along the Time dimension because it does not makes sense. These values are for example the daily exchange rate of currencies. How a yerly exchange rate can makes sense??? So Whe...

add two time hierarchies to a dimension? - I got problem when trying to add two exactly same time hierachies to a dimension. There are two fields StartTimeID, and EndTimeID, which point to Time dimension table by TimeID. I would like to use these two time hierachies to restrict my query. ..
   Database Forums (Home) -> Data Warehouse All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]