BusinessObjects Board

Data display

building reports desktopintelligence
#1

Hi,

I have to display the data in a table with 3 groups like below:

Group1 Group2 Group3 measure1 measure2

g11 g21 g31 100 202
g11 g21 g32 150 207
g11 g21 g33 107 500

g11 g22 g31 100 200
g11 g22 g32 0 0
g11 g22 g33 0 0

Here the issue is The Group3 should be display for evert Group2 whether the data exists or not in the database. If not exists simply it should display 0’s.

Thanks in advance…

bvrswamy :india: (BOB member since 2006-06-18)

#2

It’s not possible to display data that doesn’t exist … period. The trick of course is how to “create” the missing data. A few possibilities:

  1. At the universe level, a creative outer join to a table (maybe an alias or derived table) that has all possibilities.
  2. At the query panel level, a union that concatenates all possibilities (with zero amounts for measures) to the “real” answer set.
  3. At the report level, link to a personal data provider (Excel or similar) that has all possibilities … similar to this technique.

Hopefully that will nudge you in the right direction.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#3

Hi Dwayne,

Thanks for your replay and as per your comments, the personal data provider should have all the possiblities of Group1, Group2 and Group3 data I believe.

Is it possible to have only Group3 data in the personal Data provider?

Thank You,

bvrswamy :india: (BOB member since 2006-06-18)