Create Cubes Error

    Create Cubes Error

    Hi folks,

    an error keeps buggin me and I don't know what it is. I have the following 4 dimensions created and elements added to them using the PHP functions:

    Host
    Website
    Datum
    Kennzahl


    So far everything works fine. But when I try to create a cube using these dimensions I get an error (-50 by the PALO server, whatever that means???),
    I get the error either way: using the Excel Modeller or using the palo_database_add_cube() function. In the modeler it doesn't say an error encountered, it just won't create the cube. The weird thing is, it works when I only use the dimensions "Host" and "Datum", any combination with other dimensions leads to the error. So I figured there is something wrong with the dimensions "Kennzahl" respectively "Website", but I can't find out what! Following are the .xml files of the elements

    <?xml version="1.0" encoding="utf-8"?>

    <Dimension TimeStamp="1140444447.0">Kennzahl
    <Element Type="S">Klicks</Element>
    <Element Type="C">Alle Kennzahlen
    <Consolidate Factor="1.000000">Klicks</Consolidate>
    </Element>
    </Dimension>

    ------------------------------------------------------------------------------------------

    and for website it is:


    <?xml version="1.0" encoding="utf-8"?>

    <Dimension TimeStamp="1140444449.0">Webseite
    <Element Type="C">Alle Webseiten
    <Consolidate Factor="1.000000">telido.de</Consolidate>
    <Consolidate Factor="1.000000">telefon.de</Consolidate>
    <Consolidate Factor="1.000000">flotterfuchs.de</Consolidate>
    <Consolidate Factor="1.000000">qscshop</Consolidate>
    </Element>
    <Element Type="S">telido.de</Element>
    <Element Type="S">telefon.de</Element>
    <Element Type="S">flotterfuchs.de</Element>
    <Element Type="S">qscshop</Element>
    </Dimension>

    -------------------------------------------------------------------------
    This is my php code for adding the cube

    $cube_data = array('Host', 'Datum', 'Webseite');
    $add = palo_database_add_cube($connection, $database, 'Test', $cube_data);


    The $connection is valid, and the $database variable has a valid value.


    can anybody help me with that? It would be great if there was a lookup
    for the server error codes. I get a lot of them and never know what exactly they mean.

    Thanks in advance!

    Nicolas
    Hello nmeseth!

    We are currently investigating this problem and we will get in touch with you as soon as we know the reason for this issue.

    The error codes can be found in this thread.
    With Regards / Mit freundlichen Grüßen

    Jedox GmbH
    Jonathan Rass
    Developer

    Worksheet-Server 2.0
    Run your Excel-Sheets as Multi-User PHP-Applications on the Web

    Post was edited 1 time, last by “j_rass” ().

    RE: Create Cubes Error

    Gentlemen,

    it seems that there is a gap in the structure definition:
    String Elements can not be consolidated (how should this be possible)
    Therefore in Palo side it is necessary to define how String Elements are to be handled:
    they must either be exculded from consolidation in the way that:
    - Palo ignores them when they are added to a consolidation path or
    - Palo does not allow adding them to a consolidation path

    Other MOLAP Tools only allow them to be
    - not in a consolidation path
    - only in one dimension per cube
    - and this one dimension has to be the last one in the order of the dimensions within the cube.

    I don't know whether Palo needs these restrictions or not but a definition is to be made.

    Good day, Glasnost
    Good Day
    Glasnost
    I don't think the string dimension currently needs to be the last dimension, at least not from my test earlier creating some sample dimensions and placing them in a cube with the Eclipse RCP. I was allowed to create and write data to a cube containing 3 dimensions, in which I deliberately set the second dimension to contain string data.
    I don't think that it's really an issue, but the string shouldn't a be able to be consolidated, and in anycase it wouldn't make sense.