BusinessObjects Board

All values of filter "In List"

Hi guys,

I have report like this:

[DIM1]
[Metric1]

I’m putting in DIM1 a report filter: DIM1 in list (1,2,3,4,5)
The data retreived from database only bring [metric1] for 1,2.
I’d like to put value 0 in metric1 for the ones which doesn’t come from database. So in this case the result will look like:

1 | 2 | 3 | 4 | 5
2 | 7 | 0 | 0 | 0

Any suggestion would be very appreciated.
Thanks in advance.
A.S.


as2010 (BOB member since 2012-01-30)

Hi,

Check this Reporter’s FAQ. That should help you:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

SO you mean, I need to bring [DIM1] with no filters ( in another query)
And then put Metrics below.
BO will by itself join the values [DIM1] for two Queries.
Then i use a formula like If(IsNull([Metric1]; 0; [Metric1])

Thanks for your help.
A.S.


as2010 (BOB member since 2012-01-30)