empty cell issue with SSAS, how to force another value?
I have a measure group associated to my time dimension which contains data
for the month.
My time dimension is a classic year -> month -> day
But I must associate my measure group at the day level because my users do
some drillthrough and the drillthrough doesn't works if I'm not at the leaf
so my measure group use the first day of the month.
Now my issue:
using the pivottable, if the user select 1 particular day in the month which
is NOT the 1 day of the month, the month level is empty.
but I want to force the result at the month level for any day selected.
any idea of how to do this?
I have tried to apply some calculations using scope statements but no