Time dimesions in SSAS

Once I have started working on Time dimesions for SSAS cubes. I got a peculiar error while executing it. Below is the error,

A time dimension is required to enable this functionality. Ensure that you have a dimension of type Time, 
that contains at least one hierarchy with a level flagged as a time period. 

The reason for this issue is,

1. Atleast one dimensions for the cube should have the type as "Time"
2. So that, the cubes data can be evaluated based on the time dimensions.

To create Time dimensions, click "Add Business Intelligence"

     1 (1).png

     2.png

     3.png


Cheers,
Venkatesan Prabu .J
Ebook Download
View all
Learn
View all