SSAS Date Hierarchy

Hello Experts,
I have created a hierarchy on my DimDate dimension. SSAS automatically created
an attribute relationship diagram. But when I try to modify this
attribute relationship diagram and process the dimension I get an error:

"DimensionAttribute [DimDate].[Date] : The attribute is not related (directly or indirectly) to the 'Date ID' key attribute."

When I try to apply the opposite direction of the arrows
( I mean DateID-->Date-->WeekOfYear-->Month-->Year) then I get the
following error:

"Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimDate', Column: 'Month', Value: '09'. The attribute is 'Month'. "


What's wrong? Please Help
attribute1.png
attribute2.png
dimensionstructure.png
innocent1973Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
innocent1973Author Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.