Non-events / coverage table

[system]

How would you go about building a report on non-events using a coverage table in webi?

e.g. as Kimball details here?

http://www.kimballgroup.com/html/articles_search/articles1999/9902IE.html?TrkID=IE199902

The problem is using webi with a datawarehouse for financial reporting. If budget holder has no expenditure for a given period, the fact table alone will not show the budget centre (unless zero expenditures are explicity set in the ETL), the alternative is to create a coverage table of all active budgets… But then how do you join the tables? In Designer or a Webi report?

---

Darth Services (BOB member since 2007-11-20)

[system]

Bump…

---

Darth Services (BOB member since 2007-11-20)

[system]

Hi,

This Reporter’s FAQ can help:

FAQ: Reporter

How can I include data for all months in a crosstab, even if a particular month has no data? One way to do this is to create a second data provider using only the months. Then link (or “merge”) the second data provider (query) with the first data provider. Use the month column from the second data provider in the cross tab. This should bring in all months even if there were no data for that month. However this technique does not work if you have sections in your report. Dave Rathb…

---

Marek Chladny (BOB member since 2003-11-27)