SSAS - Return dates where no data exists

问题:

How, in SQL Server Analysis Services, how can I return rows of data for dates where no data exists? In this instance, ideally, I'd want to return the value of 0. In plain SQL, I would do this with a CTE. However, I'm still figuring out SSAS.

回答1:

Right-click on your PivotTable and choose PivotTable Options. Select the tab labeled "Display". There is an option called "Show items with no data in rows". Put a check mark by that one.

If you prefer zero then on the Layout & Format tab of that same dialog set "For empty cells show" to 0.