Time dimesions in SSAS

Submit Blog |

Blogs Home |

Ads

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

Head, KaaShiv InfoTech.

http://www.kaashivinfotech.com/

Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
http://kaashivinfotech.com/Ebooks.aspx

Found interesting? Add this to:

| More | Bookmark It

More Blogs from Jvprabhusanthi

More ...

About Venkatesan Jayakantham

Experience:	9 year(s)
Home page:	http://www.dotnetfunda.com
Member since:	Tuesday, May 01, 2012
Level:	Starter
Status:	[Member]
Biography:

>> Write Response - Respond to this post and get points

More Blogs
	Dotnet 4.0 Chart issue Toggle key issue in Windows Vista Exception from HRESULT: 0x800AC472 Unable to invoke a class in C# To check file exists or not in c# Update Query with Inner join in SQL Server Fetch a pattern of data in SQL Server Microsoft.AnalysisServices.AdomdClient issue XSD in SQL Server Submit Blog \| More ...