This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 85%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
I had a question regarding Time Dimension in SSAS. I added the Time Dim into server which I set the first calendar day at 1/1/2012 until 31/12/2022 for the last calendar day. So what happen to the cube in the future, after 31/12/2022 ? the row of future date in Time Dim will automatically added or the cube will be error? If cube error, what should I do? Is there a way to automatically added the future date?
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
Hi @MushiMushi ,
Has your issue been resolved?
If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Regards,
Joy
Answer accepted by question author
Hi @MushiMushi ,
Microsoft Analysis Services offers a flexibility to create time dimension while creating a multidimensional model. In Analysis Services time dimension can be generated in two ways:
If you used "Generate a Time Table on the Server" (first page of Dimension Wizard) option originally, you can change CalendarEndDate, work with dimensions from Visual Studio and browse dimensions should work. By working from the dimension in Visual Studio, you are forcing the deployment of the new definition.
If it is generated from your data, you must change the underlying data provided through the data source view to change the dimension range.
For more information, please refer to: Extension\Expansion of Time Dimension in Analysis Services.
Best Regards,
Joy
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.