CODEWITHSUNDEEP
ssasolap-cubedimensionnamed-query
Richard Mannion
Richard Mannion

Reputation: 289

SSAS Named query can't be added asa dimension

I have a SSAS cube. My warehouse is correctly configured with foreign keys etc and my normal dimensions all work. I have now made a named query that is intended to be used as a hierarchy, combining 3 of these dimensions into one. I have made the named query and created the relationships and shown the table in the cube but I can't add it as a dimension for some reason. What could I be doing wrong?

Upvotes: 1

Views: 981

Answers (1)

Hila DG
Hila DG

Reputation: 718

Could it be that you're looking at it in the Data Source View and not in the Cube Design window? You need to add the table to the Cube Design so you can see make it a dimension/measure

Upvotes: 1

Related Questions