I want to create two objects so I can create weekly reports so whatever day I run the report it brings me back 7 dates with null values or Zero for the future dates
Mon Tue Wed Thu Fri Sat Sun
2 56 22 76
So the query would be as below
Order Date between Start of Week (Monday) AND End of Week (Sunday)
Sorry if I haven’t explained this too well bt I just joined the forum today!!
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:
At the universe level, a creative outer join to a table (maybe an alias or derived table) that has all possibilities.
At the query panel level, a union that concatenates all possibilities (with zero amounts for measures) to the “real” answer set.
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.
(BOB member since 2002-09-19)