Empty rows in a pivot table
803442Oct 18 2010 — edited May 13 2011Hi,
Pivot table only shows those facts for which there is data in the database. But often I want to create a report that contains a fixed set of parameters, regardless of there is no data for them. It means that i want pivot report with empty rows(or columns). There are 2 ways to do this
1) Create outer join connections in the repository
2) Create outer join connections in a database view and import the view to the repository
First way reduces performance. Second way reduces performance too. Is there any other ways to do this?
I'll appreciate any ideas on how to solve it.
Thanks,
Dmitry