Did anyone tried using dummy fact table to display non existent data in BMM layer where there is dimension hierarchy tables? If I remove the dimension hierarchy tables, then I can display all the records using the column from the dummy fact table which has Cartesian joins with the dimensions. Is there a work around for this issue?
Edited by: 872073 on May 13, 2013 10:25 AM
Dummy fact works wells when there is no dimension hierarchies tables in BMM model. Once there are dimension hierarchy tables in BMM model , the data densificaiton through dummy fact does not work.
The solution that you have provided me should work if I can use direct sql as shown in the link. I can use BI Publisher for these report.
Edited by: 872073 on May 13, 2013 1:18 PM