BusinessObjects Board

Show Breakdown title without data

building reports desktopintelligence
#1

I have two tables side by side. One has 9 breakdown sections of data. The second table would have 9, but there is only data for the time specificed to fill one so the other 8 are not showing up. Is there a way to force the breakdown items to show up even if there is no data for them?

gbk2837 (BOB member since 2008-06-13)

#2

Welcome to B:bob:B!

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 another data provider (universe-based or personal data provider like Excel) 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

Thanks Dwayne, I’ll give one of your suggests a shot.

gbk2837 (BOB member since 2008-06-13)