Extract layout

andreaLin....
andreaLin.... Active Partner
Board Developer Name Dropper First Comment
edited November 6 in Platform

Hi all,

i want to know if it is possible to extract a date cube A (dimension: Entity) on premise:

into something like this in a txt or csv file.

sv0001 20241107 1

My final goal is to use this file for a data reader to populate a cube B with two dimensions (Entity and Month) with the same values as in the picture.

P.S. I used the “extract dataview” procedure, but the date format is “7/11/2024 00:00:00”, which I think is not useful for my situation. Also for "extract XML" i can't create a file XML for some reason.

A.L.

Accepted Answer

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 6 Answer ✓

    Hi @andreaLin.... ,

    I've got it.

    The first cube is dimensioned by a line item (let's call it "Line") and its type is "Date".

    You extract that into a file by using the extract cube feature. The file might look like this

    The second cube is dimensioned by "Line" and "Month", its type is "Integer".

    Then you set up a datareader reading the extracted file:

    In the ETL you will provide the correct settingts

    That will deliver this

    In your procedure you'd call the datareader after the export has been done.

    …And that's the result:

    Best,
    Helmut

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited November 6

    Hi @andreaLin.... ,

    you can try to use the "extract cube" feature

    That should deliver the date in your desired format.

    If you want to use the export dataset you'd need the date additionally as entity in your dataview's blocks and that set to "code".

    Best,
    Helmut

  • andreaLin....
    andreaLin.... Active Partner
    Board Developer Name Dropper First Comment

    Hi Heimann,

    this Procedure can deliver the date in my desired format but i can't add another column (value=1) to populate the cube with 2 dimension (Entity and Month) in the next step as i explained before.