Hi everybody,
I applied following modifications to an infocube:
In development system the infocube were empty and I had no problem in this activity.
When I transported this modification in quality environment, I noticed that Document Number field become empty. And if I:
- launch a query with no drill --> TOTAL = 100
- apply the drill on document number field (or other fields that were added to this dimension)
- No data is returned (also the total = 100 disappears)
Watching in detail, the problem is that the dimension table is now empty:
- before transport, there was a dimension table with 2 fields that mapped exactly 1:1 fact table with infoobject sid (and so, the sid value in FACT table was the same of the sid value of the infoobject and in dimension table, every record had exactly the same value in both columns)
- after transport, dimension table was extended with new fields but become empty (and so there are no more values that matches the dimension table with infoobject sid)
- watching fact table, sid values still exist
There is a way for having again this field populated in the infocube? or do I necessarily have to:
- Move all data in a second cube
- Delete data from original cube
- Transport modifications
- Move data again in the original cube
Thank you for the support.
L