on 06-06-2014 11:09 AM
Dear Experts,
we work on Bpc Nw powered by hana 10.0 SP13.
When i clear data in the cube , i have a strange behavior:
- in the Bw cube , we don't see data
- in the report we retrieve some data
In which table are this data and how can delete them?
Thanks in advance
Valentina
Hi Gersh,
to clear data we used the Delete Data function of Infocube in the Data Warehousing Workbench.
Then we have run Light Optimization and zero elimination, but we can still see data in the report.
I don't know if this is important, but at the beginning we used the new BPC on HANA function "Disaggregate" to save data.
Is it possible that these data are saved directly on HANA?
Thank you very much for any suggestion.
Regards.
Valentina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Valentina,
If you ran Delete Data in BW then you don't need LO or 0 elimination.
Can you check if any records will be shown in Manage -> Contents -> Fact table of the cube? It will show the table name. You can check if SE16 shows anything for that table. You can also check if that table is empty on HANA.
Disaggregate write data back to same table. Do you have have ENABLE_NATIVE_HANA_MODEL in SPRO for that Model?
Can you ask your Basis if SMART_MERGE is set to AUTO in HANA?
Regards,
Gersh
Hi Valentina,
How do you lookup data in the cube? In HANA data is stored in same tables as in other databases, just for Model it's only in F table, no E table.
How did you clear the data? If it's DM Package clear then you need to run Light Optimization and zero elimination to get rid of those records.
Regards,
Gersh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.