Extract layout
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
-
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,
Helmut1
Answers
-
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,
Helmut0 -
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.
0