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

Options
Paolo Orlando
Paolo Orlando Customer
First Comment First Anniversary Photogenic
edited September 2021 in Platform
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

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

image


The dataflow write value 1 instead of the date.

image

How can I solve the problem?

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

Answers

  • Sebastian Gurt
    Sebastian Gurt Employee
    First Anniversary DACH Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights
    edited September 2021
    Options
    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
    ------------------------------
    -------------------------------------------

Categories