[IFRS16 APP BLA] Cube Corruption

Francesco Tufaro

Hi,

We recently had a problem with a procedure because some cubes were corrupted, are there any best practices to follow for to prevent this problem in the futute?
The version of the BLA database is 12.1.

Thank you in advance for any response,
Francesco.

------------------------------
Francesco Tufaro
Consultant
TECHEDGE SPA
Italy
------------------------------

Helmut Heimann

Hi @Francesco Tufaro,

Do you mean, you deleted entity members from within the entity maintenance page?
If so, it's not the procedure causing your trouble but rather the action of deleting the members. Imagine an order book where you ripped out pages. Some of your revenues will no longer be linked to orders and thus disappear. The same happens to a cube's data if you delete members of its dimensions.
In other words: your action of deleting those unwanted members corrupted your database, and the only way to get that working properly again will be to restore the database from an un-corrupted backup.
Never ever delete entity members manually!

If you want to get rid of unwanted members, here are the steps to follow:
1. Make a backup copy of your database
2. Find out which cubes will be affected (Entity->Analysis->Cubes)
3. Extract those cubes
4. Make sure that the loading process for your entity will not load the unwanted members (if the source is a csv file, you could delete the appropriate records; if it's an SQL source, de-select those unwanted members)
5. Make sure that the entity's sorting order is set to "none"
6. Clear the entity (the appropriate cubes you extracted beforehand will be cleared as well)
7. Reload the entity
8. Reload the cubes
9. Check if everything is working properly

Kind regards
Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------

Helmut Heimann

Hi @Francesco Tufaro,

in order to help out, it would be better to have some more information.
- was the procedure built on Board version 12.1 or is this a migrated database, we're talking about?
- if it is a migrated database, did the procedure work properly before the migration?
- in what way were the cubes corrupted? what happened?
- what is the procedure supposed to do and what did it do?

Keep in mind these rules when creating a dataflow:
1 dataflows run in replace mode
2 dataflows are influenced by active selections
3 no function or reference is applicable in the target cube
4 all cubes in a dataflow are aligned with the target cube
5 by default, dataflows don't create new tuples

Kind regards
Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------

Francesco Tufaro

Hi Helmut,

We simply deleted some elements from an entity (contracts) and then the cubes got corrupted.
The app was always in 12.1, it's based on the BLA database and capsules.

Thank you for answering.

Kind regards,
Francesco.

------------------------------
Francesco Tufaro
Consultant
TECHEDGE SPA
Italy
------------------------------
-------------------------------------------

Francesco Tufaro

Hi Helmut,

Thank you very much, that helps a lot.

Thank you,
Francesco.

------------------------------
Francesco Tufaro
Consultant
TECHEDGE SPA
Italy
------------------------------
-------------------------------------------