File Structure

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • File Structure

    Hi *,

    we're using PALO 1.5 final for our Controlling solution. Great job btw ;)

    Everything works fine except for a data loss this morning. I don't now why but in a cube with 4 dimensions, 4 out of 5 consolidated elements lost their data values... don't know why this happend but the data is gone. (Any known problem?) All cells in the Excel sheets just turned to #WERT! and after a restart the data was gone...

    Now to my question: We wanna backup the different cubes but don't know exactly what files serve a particular purpose... there are 20 Cube files in the data directory but we only have 3 cubes in the database... see picture. Can someone explain, why there are so many cube files?

    Thanks,
    Steve
    Images
    • pic.jpg

      182.02 kB, 721×416, viewed 1,579 times

    The post was edited 1 time, last by ssauerw ().

  • RE: File Structure

    OK, I think we found the reason for the loss of data:

    We have a dimension called "Projekte". There are 5 consolidated elements

    1C
    2C
    3C
    4C
    5C

    to every one of these we have several project. This particular dimension is used by 2 cubes. Now 4 of these dimensions were changed in cube 1, so that they changed from consolidated to base element. This apparently effects the data values in cube 2.

    Well, this problem seems to be solved... but I'm still interested in the second question about the file structure ;)
  • RE: File Structure

    Hello ssauerw,

    Thank you for the compliment! - Concerning the loss of your data, good to
    hear that this has been solved. Unfortunately it is quite laborious to backup
    data to a specific step by now. In the next Palo version, Palo 2.0, there will be
    an Undo-function.

    For information about the structure please see:
    forum.palo.net/thread.php?threadid=438

    Any more questions?

    Regards,
    Stephanie
  • RE: File Structure

    Hello ssauerw,

    In the database.csv of your demo-database your structure of your
    data is defined. Under 'CUBES' in database.csv you see 15 entries:

    [CUBES]
    0;"#_GROUP_CUBE_DATA";0,1;1;0;0;
    1;"#_Months";3,2;3;0;0;
    2;"#_GROUP_DIMENSION_DATA_Months";0,2;1;0;0;
    3;"#_Years";5,4;3;0;0;
    4;"#_GROUP_DIMENSION_DATA_Years";0,4;1;0;0;
    5;"#_Regions";7,6;3;0;0;
    6;"#_GROUP_DIMENSION_DATA_Regions";0,6;1;0;0;
    7;"#_Datatypes";9,8;3;0;0;
    8;"#_GROUP_DIMENSION_DATA_Datatypes";0,8;1;0;0;
    9;"#_Measures";11,10;3;0;0;
    10;"#_GROUP_DIMENSION_DATA_Measures";0,10;1;0;0;
    11;"#_Products";13,12;3;0;0;
    12;"#_GROUP_DIMENSION_DATA_Products";0,12;1;0;0;
    13;"Sales";12,6,2,4,8,10;2;1;1;
    14;"#_#_CUBE_";14,1;3;0;0;

    For each record below [CUBES] you will find a csv file.

    In short detail:

    0;"#_GROUP_CUBE_DATA";0,1;1;0;0;

    Contains the dimensions cubes and groups and
    provides the rights of groups on cubes.

    1;"#_Months";3,2;3;0;0;
    3;"#_Years";5,4;3;0;0;
    5;"#_Regions";7,6;3;0;0;
    7;"#_Datatypes";9,8;3;0;0;
    9;"#_Measures";11,10;3;0;0;
    11;"#_Products";13,12;3;0;0;

    Contains the attribute cubes for each dimension.

    2;"#_GROUP_DIMENSION_DATA_Months";0,2;1;0;0;
    4;"#_GROUP_DIMENSION_DATA_Years";0,4;1;0;0;
    6;"#_GROUP_DIMENSION_DATA_Regions";0,6;1;0;0;
    8;"#_GROUP_DIMENSION_DATA_Datatypes";0,8;1;0;0;
    10;"#_GROUP_DIMENSION_DATA_Measures";0,10;1;0;0;
    12;"#_GROUP_DIMENSION_DATA_Products";0,12;1;0;0;

    Contains the cube of group and dimensions and therefore the
    right on each element for each group.

    13;"Sales";12,6,2,4,8,10;2;1;1;

    Contains the data of the cube 'Sales'.

    14;"#_#_CUBE_";14,1;3;0;0;

    Contains the data of the attribute cube on the cube dimension.

    I hope this short description will be helpful enough to understand why
    so many files are created. For more details please see the database.csv
    structure.

    Regards,
    Stephanie