Creating Versions for Info-Cube

Harry Sun
Harry Sun Customer, Community Captain
10 Comments Name Dropper 5 Likes Community Captain

Hi Board Team,

I have watched BOARD Academy video about optimizing cube performance by creating different version.

Is there any disadvantage / issue for creating versions?

Can I create version directly in the production environment? Thanks

Tagged:

Accepted Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    Answer ✓

    Hi @Harry Sun ,

    you can—of course—create versions of cubes in the production environment. But, please don't.
    It is never recommended to change the productive database.
    The recommended way would be to apply the changes to the devedlopment environment, test them and transport them to production via ALM.

    Kind regards,
    Helmut

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    Answer ✓

    Hello @Harry Sun ,

    not for creating versions—but in usage.
    You should always be aware that those versions have to be aligned in order to show correct values. This can be done manually in the cube's section in the database

    The second option for aligning is the appropriate procedure step:

    Furthermore, be aware that a cube with versions used in a dataview set to data entry will be aligned after data entry (automatically). This takes time and the users might have to wait quite some time before they can enter new values. My recommendattion would be not to use versionized cubes in data entry situations.

    Best,
    Helmut

  • Leone Scaburri
    Leone Scaburri Employee
    Fourth Anniversary 100 Comments 5 Answers 25 Likes
    Answer ✓

    Hi @Harry Sun,

    this article explains the purpose of cube versioning and its main application that is improving reports performance.

Answers

  • Harry Sun
    Harry Sun Customer, Community Captain
    10 Comments Name Dropper 5 Likes Community Captain

    Thanks Helmut. @Helmut Heimann

    Is there any side effect I need to be aware for creating versions?

    Thanks

  • Harry Sun
    Harry Sun Customer, Community Captain
    10 Comments Name Dropper 5 Likes Community Captain

    Hi Helmut, @Helmut Heimann

    Thanks a lot for your quick reply. Let me use an example to make sure I understand this correctly. 😀

    We have a cube called DVOL - Demand Plan Unit. Many data entry will happen in this cube. So, it is better NOT to use version on this cube.

    We had another cube called DVOL - Demand Plan Value. This cube is calculated by Demand Plan Unit * selling price. We will not allow direct data entry for this cube. The cube will only be calculated from Unit and selling price. In this case, it is ok to use version. This will make any report with Value run much faster on the screen.

    Did I understand this correctly?

    Thanks a lot

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi @Harry Sun ,

    yes, perfectly.
    Keep in mind that the DVOL cube needs to be aligned after the dataflow calculating the plan value.

    Best,
    Helmut