CODEWITHSUNDEEP
ssaspivot-tableolap-cube
Ben Kim
Ben Kim

Reputation: 1

Why Excel pivot table does not retrieve data for all dates?

Time table in SSAS Cube has all correct dates. And Data source view also has the correct data for those dates. However why Excel pivot table does not retrieve data from the specific week? (3rd week in the year) Only 3rd week data is being missed in Excel pivot table.

enter image description here

Upvotes: 0

Views: 86

Answers (2)

SebTHU
SebTHU

Reputation: 1405

It's probably unlikely, but it could be that there's no data in that week for the measure you've selected. Do you see the week if you browse the time dimension itself in SSDT?

Upvotes: 0

GM_NHS_UK
GM_NHS_UK

Reputation: 1

Could a filter in the pivot table be on by accident? Not in the data, but the table itself. Maybe a date got unticked? this could cause it. example of pivot filter

Upvotes: 0

Related Questions