Browsing SSAS Cube in excel - Pivot not giving expected layout

Komal Sahu 311 Reputation points
2021-03-19T10:24:08.273+00:00

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Darren Gosbell 1,466 Reputation points
    2021-03-21T22:02:53.26+00:00

    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.

  2. Lukas Yu -MSFT 5,816 Reputation points
    2021-03-29T02:14:32.353+00:00

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

    0 comments