ThamaluM
commented
4 years ago Outer join works. Problem is when we slice and dice using cuts the additional rows inserted into the join from dimensional members (that have no facts in the fact table) are filtered away. (If some product not sold in 2019 then when we cut those products are ruled out )
Hi there, I am using cubes 1.1 for my project. I want to get zero for aggregates relevant to dimension points where have no facts. For example if no pizzas are sold in 2019 amount_sum should be 0.
As I understand the documentation, detail join method for product dimension table should work. But it didn't work for me.
{ "master": "productid", "detail": "product.productid", "method":"detail" }