Extract layout

andreaLin.... · 2024-11-06T10:05:56+00:00

There was an error rendering this rich post.

andreaLin....

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.

Find more posts tagged with

Cube

Layout

Data Extract

Accepted answers

Helmut Heimann

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

All comments

Helmut Heimann

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....

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.

Helmut Heimann

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