Extract layout

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

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.

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