[IFRS16 APP BLA] Cube Corruption

Francesco Tufaro
Francesco Tufaro Active Partner
First Comment First Anniversary
edited April 2022 in Platform
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
------------------------------
Tagged:

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    250 Likes Fourth Anniversary 100 Up Votes 100 Comments
    edited June 2022 Answer ✓
    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
    ------------------------------
    -------------------------------------------

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    250 Likes Fourth Anniversary 100 Up Votes 100 Comments
    edited May 2022
    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
    Francesco Tufaro Active Partner
    First Comment First Anniversary
    edited May 2022
    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
    Francesco Tufaro Active Partner
    First Comment First Anniversary
    edited June 2022
    Hi Helmut,

    Thank you very much, that helps a lot.

    Thank you,
    Francesco.

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