Force Count(Dimension) to return 0

building semantic layer
1

Hi all,

I have a table (in Oracle) which gets deleted and repopulated at each load (daily).
I am trying to create a table in my report which will return a count of each instances. And I want to force the count to return zero when there is none, rather than dropping the line (it changes all the format of the report, etc…)

Is there any way to do this, either at universe level on in the warehouse?

Thanks for your help…

Olivier Masse :fr: (BOB member since 2002-08-29)

2

Does NVL(count(X),0) work for you?

3

It would but because we have so many instances we would have to create a count measure for each one of them in the Universe (?). This would be to difficult to maintain, we were looking at having just one count measure, and forcing the report to return it for all the values by having a table listing all the instance in the warehouse which would be linked to our main table using an outer join…

Olivier Masse :fr: (BOB member since 2002-08-29)