copy "date" type cube into a "text" type cube

andreaLin.... · 2025-01-24T12:23:58+00:00

There was an error rendering this rich post.

Hi All,

I’m looking for the correct formula to use in this dataflow:

Cube D is a "date" type cube.
Cube E is a "text" type cube.

Don't worry for The selection
I’m unable to find the correct formula in the IF Statement to paste the value into the text cube (TEXT(D),"DD/MM/YYYY"). As a result, the output of the dataflow is simply "0".

CUBE D CUBE E (I WANT) CUBE E RESULT

15/01/2025 15/01/2025 0

Any suggestion?
thanks

Find more posts tagged with

Cube

Algorithm

Accepted answers

Helmut Heimann

Hi @andreaLin.... ,

I'm sorry, but there is no way to copy that by dataflow, I just checked.

The date cube's value is represented as number when written to a numeric block (as EXCEL would be doing)—but unfortunately, there's no date() function in a dataflow.

You will need an export/import of the data to manipulate it in a datareader's ETL.

Best,
Helmut

All comments

Helmut Heimann

Hi @andreaLin.... ,

you've said not to worry about the selections, so I'd assume since cube e is dimensioned by "day" and cube d is not, that the day has been selected and you extend on "day"—correct?

Next, I'd try to set up a dataview that does the same calculation as algorithm—what do you get there?

Best,
Helmut

andreaLin....

https://community.board.com/discussion/comment/19562#Comment_19562

yes correct, i already extended
can you simplified the the calculation as algorithm and then i will adapt to my specifif case?
i think is possible to obtain this kind of visualization that i want

thanks

Helmut Heimann

Hi @andreaLin.... ,

I'm sorry, but there is no way to copy that by dataflow, I just checked.

The date cube's value is represented as number when written to a numeric block (as EXCEL would be doing)—but unfortunately, there's no date() function in a dataflow.

You will need an export/import of the data to manipulate it in a datareader's ETL.

Best,
Helmut