asked on

SQL Data Cube

All,

Below is screenshot of my dimension hierarchy and the browser window of the hierarchy. As you can see in the browser of the dimension in the cube, you can see all of the dates.

However, when I access this info in Excel, I can only see the latest date, which is 8-20-2018.

lcohan

Is this a new or maybe modified SSAS cube dimension that is not showing all data in Excel?

isames

ASKER

Yes, this is a modified cube, where I added the TransferNumber dimension.

Everything looks good inside the browser window of the cube for the Date attribute, just not Excel.

lcohan

I think you will need to refresh the Excel connection to push SSAS metadata changes or worst case recreate the Excel - see here what others are saying: https://www.sqlservercentral.com/Forums/Topic1050118-1292-1.aspx

BTW - What SQL SSAS and Excel versions are you using?

isames

ASKER

I tried recreating the spreadsheet, to no avail. I am using SQL 2008R2 and Excel 2016.

In the first screenshot, you can see all of the dates in Excel to filter on. There are the same as what is in the SSAS browser for this attribute. However only the most recent date shows data.

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.