Calendar table in ODV

Question

Hello , I have a question with ODV.

Is it possible to create a custom calendar table in ODV ( with spreadsheet or sql query) and then link it to a report dates columns in order to use the date table as a prompt in my dashboards. I was able to that easily in power bi joining date fields in the report and a calendar but i dont know how to that in ODV.

For your information, i dont have a calendar table on my subject areas/rpd so that's why i want to create this custom calendar table.

Thanks for helping

Federico Venturin - Oracle · Answer

Hi @User_RS68A ,

If I understood it correctly, you would like your calendar table to be able to play multiple roles (e.g. order date, payment date, invoice date, etc.).

This is not possible since there could be at most one join/link between 2 given objects (eventually the join/link can be based on multiple columns). You have to create a separate dataset for each role that your calendar table should play, or an alias if you are going to follow the dataset with multiple tables approach.

User_RS68A · Answer

@Federico Venturin thank your for your answer.

I dont have access to the RPD that's why i want to do it in Data Vizualisation directly.

I am trying to follow your explanations, however i'm having an issue.

I can not join more than one date column in the report to the calendar date column. ( see attached screenshot)

the problem is that i have multiple dates column in my report and want to join them all to the calendar table.

Thanks

Capture d'écran 2023-12-07 152725.png

User_RS68A · Answer

@Gianni Ceresa The DV interface in OAS (see screenshot attached).

Capture d'écran 2023-12-07 151328.png