Getting Dims to Display Correctly in Tab Cube Hierarchy

  • Hello,

    I've created two dim tables, both have a PK using IDENTITY and a column holding distinct data, 5 rows in one and 20 rows in the other. I've add the two new columns to the main table for hold the PK from these new dim tables, altered in both new dim tables to the main table with statements like:

    ALTER TABLE [dbo].[MainTable]
    ADD CONSTRAINT FK_cluster FOREIGN KEY (clust_keys)
        REFERENCES [dbo].[clustdimtable](clust_keys)

    In the model, brought in the new view made off the main table that has all the latest columns and FK's, and the two new dim tables. I've gone to the Diagram, and joined the two FK columns added to the MainTable to the PK's of the two new dims tables.

    Then I create a new hierarchy of the CLUSTER and REGION keys. Save, build, deploy, and when I connect with Excel, everything looks good, I see the new folder of the Hierarchy, and the two columns names, BUT, when I select either Cluster or Region, what appears in the column or row is the name of the Hierarchy, and only the values of the first column name in the Hierachy folder.

    I'm certain I've been able to split out the dim's from the fact tables, and joined them properly, and created a hierarchy right, but I'm, still getting the same result. What am I doing wrong?

    Thanks for your help

Viewing 0 posts

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