Post reply

Help with dimensions when creating a cube

  • April 29, 2009 at 1:05 pm

    #220686

    I created a cube with 7 dimensions using SSAS 2005.

    Five of the dimensions appear to have been created correctly when viewing them in the "Dimension Structure" tab. That is, I see the primary key attribute and a dimension field attribute in the "Attributes" section. For example, I see 2 attributes per dimension such as RegionPK and Region.

    However, for 2 dimensions I see only the primary key attribute field in the "Attributes" section. For example, I see only the CustomerPK attribute when I expect to see both the CustomerPK and Customer attributes.

    I generated a model from the cube for Report Builder. In Report Builder I see all 7 dimensions in the entities section. For the 5 dimensions that are correct I see dimension attributes in the "Fields" section. For the 2 dimensions that are incorrect I see "There are no items in this list." in the fields section.

    I can still drag/drop the 2 bad dimensions from the "Entities" section onto the report.

    I also created a pivot table in Excel 2003 that is connected to the cube. The "PivotTable Field List" does not display the 2 bad dimensions.

    The database views for the 2 bad dimensions that are used to create cube appear to be populated correctly.

    Does anyone have an idea about what could be wrong with the cube?

    Thanks.

  • April 30, 2009 at 10:45 am

    #986779

    Never mind. I got it figured out. I needed to drag/drop the attribute from the Data Source View section into the attribute section on the Dimension Structure tab.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply