Showing all Characteristic values from Master Data in WebI report
I have a requirement in WebI report to show all characteristic values from master data, whether this characteristic value exists in transaction data (InfoProvider) or not.
From the following post: WebI report returns incorrect data..., I found that it's possible to show characteristic value from master data if we don't include key figure in query panel, but in my case I need to include and use the key figure.
This is possible in BEx, by setting the characteristic property (Advanced tab) for "Access Type for Result Values" = "Master Data" in Query Designer. Unfortunately, eventhough I have set this in Query Designer, the WebI report that's based on this query via Universe doesn't apply this setting.
Does anyone know solution for this?
Thank you in advance.