Hi Guys,
I have a requirement to enable Writeback functionality on SSAS cube (Star Schema), so that measure values can be updated/inserted using Excel Pivot by end users. I have enabled it and am able to update the values which already exist in Fact table by using What-if analysis method.
However, the issue is that I am not able to INSERT new values. The reason being, there is no dimension value appearing at the 'Row' or 'Column' for which I want to enter the measure value. I think because any value doesn't exist in the Fact table already.
Do you have any suggestion on how to achieve this?
Cheers!
Maninder