Write date (from interactive selection) in a text cube.

Paolo Orlando

Hi to all,

In a procedure there is an interactive selection on entity Day.
This selected day has to be saved in a cube.
I try to do this but I'm not be enable to write date in a cube.

This is the step in the procedure



The cube WIP-ValueDay1 has value 1 for each day/project




The dataflow write value 1 instead of the date.



How can I solve the problem?

------------------------------
Paolo
------------------------------

Sebastian Gurt

Hi Paolo,

the problem of using the entity in the dataflow layout is that you only get the desired outcome (the day code or desc) when the dataflow "runs on the day entity". You can see the problem when you put the day entity in a dataview and put the project in the rows. You only get day code or desc when you put the day also by row.
You can try either to use an algorithm with "@day" (as long as you have a selection on the day) instead of block b or you first write the day code/desc to a helper cube (text) structured by day and use that instead of the day entity in you dataflow.

Hope this helps.

Sebastian


------------------------------
Sebastian Gurt
Consultant Team Leader
Board International
Germany
------------------------------
-------------------------------------------