Hello,
I really hope someone can help me with the following issue:
After changes in the DTP and a transformation I emptied and reloaded data into my cube from the DSO.
The DTP was green and the data is available for reporting. With listcube I can see the data but with
the query designer the basic key figures result in an empty field (zeros are not shown, so might be zero), although the transaction data itself is visible! The query was ok before the changes and still works on the test system, but not on the production system. (There is a simple Multiprovider on with the queries are based.)
I have stripped down the query, so that there are no filters or calculated or restricted key figures.
The problem still remains. I can see the data e.g. project, date-field, but not the numeric key figure.
Formulas based on the basic key figures result naturally in "X" (division by zero I suppose).
I transported the query again, but it did not help.
Has anyone an idea why I cannot see the key figure or experienced the same?
Best regards
Thomas