Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Time dimesions in SSAS
WhatsApp
Venkatesan Jayakantham
12y
2.9
k
0
0
25
Blog
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"
Cheers,
Venkatesan Prabu .J
Time dimesions in SSAS
Up Next
How to Sum the time in Varchar column in SQL Server
Ebook Download
View all
SQL Queries For Beginners
Read by 18.3k people
Download Now!
Learn
View all
Membership not found