Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2014-06-12 : 00:59:35
|
| Hi All,I am preparing a cube in SSAS for sample Sales analysis.I have taken customer and Date dimensions and one Sales Fact table.Sales figure related to Customer and date will be entered into Sales Fact table.and for some dates there may not be any sales for some customers.In that case i want to display those missing records in cube as zeros (Instead of missing them).Can some one please guide me how can we achive this.TIA |
|
|
learntsql
524 Posts |
Posted - 2014-06-13 : 01:24:25
|
| Hi All,Is there any solution for it or any work around please?TIA. |
 |
|
|
|
|
|
Display missing records as Zeros in cube