Hi,
We are building live office objects charts on top of WEBI documents and facing an issue while refreshing the data in live office object for empty measure and empty dimension values. Charts are pointed to the data cells in the live office table and if there is no data for the given selections for any measure or dimension the data cell range will change and charts are not working properly. So, we want show the measures as zero and show rows with empty dimension values even if the data doesnu2019t exists.
I believe we should have some setting in WEBI or live office. Would be appreciated your help.
Best Regards,
Satya