BusinessObjects Board

table with no info

building reports webintelligence
#1

Good evening,

I am creating a report with BEx. I have the dimension [month], [worker] and object [sales].

I want to create a table knowing the monthly sales for each worker. However, there are workers that for example in January or March sales are 0 and there is no info. in the query, so when I create a bar graph, I can have only February and from April-December. So, how can I make it to include in the bar graph info. about Jan. and March despite being 0 and not having info. in the query?

Thanks a lot

jaylagas2 (BOB member since 2013-09-25)

#2

Hi,

Create one more data provider and bring just Month object in this.
In report merge on month dimension from both data providers and use this merged dimension in your graph.

https://bobj-board.org/t/15226/27

Prashu :india: (BOB member since 2005-08-17)

#3

Can you create a variable to assign a value of 0 if they have no sales?

for example =if(IsNull(([Sales]) In ([Month];[Worker]));0;[Sales])

pjprenger (BOB member since 2013-08-06)