CODEWITHSUNDEEP
sql-server-2008-r2ssasdata-warehousedimensionsbids
DtotheG
DtotheG

Reputation: 1307

SSAS - Time Dimension Increasing Time Structure

I'm looking to increase the time dimension within a cube. Its currently set to Calendar end date 31/12/2012. Im looking to update it to end 31/12/2016. Currently using BIDS I've Increased the CalendarEndDate property in the dimension to '31/12/2016'. Saved it, processed the dimension, went to the browser and viewed the data but only shows up to Calendar 2012, no sign of 2013, 2014 ... etc.

Am I missing a step or is there anything else etc I must do before this will update?

Using SQL Server 2008R2. Dimension was set up prior to me taking ownership so unsure of how it was originally created but seems a pretty standard dimension with the source as the DSV.

Thanks

Upvotes: 2

Views: 2064

Answers (1)

Daryl Wenman-Bateson
Daryl Wenman-Bateson

Reputation: 3939

It sounds like the developer used "Generate a Time Table on the Server" (first page of Dimension Wizard) option originally as you have CalendarEndDate available. If that is the case, changing the CalendarEndDate, Processing the Dimension from Visual Studio (not SQL Server!) and browsing the Dimension should work. By processing from dimension inside Visual Studio, you will force the new definition to be deployed.

If you are still having problems, try creating a new time dimension inside a test project and deploying to see if you get the same issue. Compare the properties of both time dimensions to see if you can spot anything unusual.

Upvotes: 2

Related Questions