date cube : data entry

Marion CONTENTI
Marion CONTENTI Active Partner
Fourth Anniversary Board Developer Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board
edited December 5 in Platform

Hello everyone,

I am facing an issue related to the use of a date cube.
In a layout, I have a date cube (structured with only 2 dimensions, including the year) open for input, which allows identifying the start of an allocation on a specific day.

image.png


The default year displayed is the current year, but I would like to display on a specific year instead.
I do not want to add a trigger to verify what has been entered and display a message if it differs from the year.
I have tested the use of suggested values based on a cube or an entity, but the result is not as expected.


Has anyone encountered this case? Do you have any solutions I could test?

Thank you! 😊

Marion.

Tagged:

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi @Marion CONTENTI ,

    the "problem" with date cubes is that the date (you would like to store) is not connected to Board's time range. So any selection on the time range won't have an impact on the date you are "selecting" in the data entry process.

    The "time selector" provided in the data entry process is not connected to the time range within Board's database, either. And it will always pop up with the current month/day (provided by the current time on your machine).

    That said, I'm afraid that the solution to achieving your aim here would be a lot more complex involving some cubes based on Board's time range and then converting that into dates for the date cubes or even leave the date cubes completely out of the process and trying to achieve everything with cubes based on day or month in the database.

    Best,
    Helmut

Categories