on 06-15-2017 1:03 AM
Hi guys,
I adjusted an InfoCube by adding three characteristics into three new dimensions. Shouldn't be any problem. However, after transporting the change to production system the Cube does not show any data in LISTCUBE any more. The data is still present in fact and dim tables.
Executing RSRV checks on the Cubes data provided me with the following error message for the three new dimensions I added:
Dimension table xxx does not contain a zero record (xxx = technical name of the dimension table).
Searching the support portal did not provide me with any solution on this issue. Correct Error in RSRV does not seem to work.
Any ideas how to fix this? When I transported the Cube to quality system everything worked just fine.
Many thanks in advance,
Tobias
Problem was solved by opening the system and reactivating the InfoCube.
Many thanks for your advice.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tobias,
Please check 2106099 - Missing records in LISTCUBE or "Display Data" for an InfoProvider looks like similar to your issue
Kind regards,
Andrey
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Addition of new field might disturb the index. Please drop and regenerate the index and then give a try. If you have used remodeling option then data will be definitely available after the change.
Regards,
Md.Ekram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
it seems cube structure got changed, try use program 'CUBE_SAMPLE_CREATE' to generate few records. If the cube structure is not disturbed you will be able to generate few records, else it says 'invalid entry'.
thereafter, try re-active cube, ensure no data while you activate it.
btw, have you done remodelling to the cube or just changed using edit option?
-
Regards,
Mgande
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.