We are working on XI 3.1 with Bex query as datasource.
We have built a webi report on top of a bex query. The webi report is showing correct data until free characterisitcs are drageed in the edit query mode for using those in the report later.
When the query is being saved by dragging this into edit query, upon execution it is only showing 0 andn no values though the bex query has data.
specifically we are adding the 0currency object into the webi edit query, which we want to use during analysis.
I try to understand what the issue is. Can you please clarify:
- You are in the query panel and you try to drag dimensions and measures in the result object pane?
- The free characteristics you talk about are in the bex query?
- About 0currency: You drag it onto the result object pane and then the you execute the defined query and it doesn't show any data?