I have designed dimensions and a cube in SSAS. I cannot see my dimension hierarchy in cube browser UI. All data are shown as tabular format.
But when I try to browse the cube I get the followin result: sales cube
Please Help
1
votes
It looks to me like you've opened up your customer dimension and the first thing you are seeing is your country level of the customers hierarchy. So far it seems correct to me. Click on the [+] notes to drill down farther.
– Ryan B.
I can see drilldown (+) when I browse the dimension structure. But I cannot see it when I browse the cube's itself.
– innocentolaris73
It's right there on your screenshot... you are looking at it. Remove Customer Key from the grid and without its uniqueness you'll see the rows collapse to the city grain, and Sales Amount will convert to the sum appropriate at that level. (make sure u are using the columns from the hierarchy tho, and not the similarly named fields that are just dimension attributes).
– Ryan B.
I have removed the CustomerKey.And still browse cube data as tabular format.
– innocentolaris73
SSMS (since 2012 I think) only supports tabular formatting of data. Older versions of SSMS (2008) supported hierarchical views.
– Alan Schofield
