Share via

SSAS cube query result needs to display 0

Potter123 260 Reputation points
2023-06-07T08:21:24.99+00:00

Hello.

I have a cube with many null values in the query results, but that's not what I want. I need to show null values as 0.

How can I achieve this?

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,345 questions
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.