• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1660
  • Last Modified:

Analysis Services Error Building Cube

I am trying to build a cube in analysis services.  The view (PFS Data View)  with the measure has a composite key.  I have about 8 dimensions connected to the cube.  Each of those measures are linked to one of the fields that are part of the composite key in the fact table.  I cannot process the cube.  I get the following errror:

MeasureGroup [PFS Data View].[View Master Period15 Only] : No dimension relationships exist. The measure group 'View Master Period15 Only' is not related to any dimensions.

Any suggestions would be greatly appreciated.

1 Solution
Eugene ZCommented:
you need to do what it said:
<No dimension relationships exist.> create one
< The measure group 'View Master Period15 Only' is not related to any dimensions> see line above

Dimension and Measure Group Relationships

Dimension Relationships
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.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now