date cube : data entry

Marion CONTENTI

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.

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.

Helmut Heimann

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