All Quarter Display

building semantic layer
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)