question

CreateIT avatar image
0 Votes"
CreateIT asked LukasYu-msft answered

Browsing SSAS Cube in excel - Pivot not giving expected layout

Hi ALL,

I have a dimension 'XYZ' with hierarchy up to level 7. When I drag level 04 of this dim (along with other dim) into pivot against measure value. I am getting below display. And this is expected result. Here I am connecting excel to cube from environment test1.

79598-cube-broswing-issue.jpg

Problem is when I am browsing SAME thing with exactly same measures and dims from other environment test2.
When I drag level 04 of 'XYZ' dim (along with other dim) into pivot against measure value, it always shows level 02(highest level). whichever level I drag into pivot, it only shows level 02 as below.

79579-cube-broswing.jpg

Cube structure in both environment is exactly same. And one excel is being used to connect to both different cubes form 2 different test servers.
may this be an issue with excel pivot setting?
Please help . any tips, tricks, suggestion will be very much helpful.
Many Thanks

sql-server-analysis-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FYI..
version is SSAS 2014

0 Votes 0 ·

Any help or suggestion please @LukasYu-msft , @DarrenGosbell-0123

0 Votes 0 ·
DarrenGosbell-0123 avatar image
0 Votes"
DarrenGosbell-0123 answered CreateIT commented

It's pretty hard to say just from screenshots of pivot tables, but it looks like the data in your dimension tables is probably different. If the measure is additive the data in your fact table is definitely different.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your response Darren,
will revert back after checking.

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

Have you checked your dimension data ? Any updates on this case ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.