Additional calendar in Time Range

BENOIT ROLLAND

Dear All,

I'm currently working on a customer context that needs 2 different calendars:

1. One starting in Jan (FR)
2. The other one starting in Mar (DE)

First, I was wondering if you already met this request and how Board has been set up to deal with:

1. These 2 calendars (same time range entity? another cube? date cube? make reference from one cube to the other to keep year/month consistent between each other?)
2. QTD and YTD vision in these 2 calendars (if using different cubes)?

Creating 2 different databases would be a solution but would duplicate all data (and would have an impact on data volume).
What are your thoughts?

If you never met these requests, what would be your suggestions?

Thanks in advance.

------------------------------
Benoit ROLLAND EYROLLES
Project Leader
------------------------------

Helmut Heimann

Hi @Benoit ROLLAND EYROLLES,

did you think about using the "Fiscal Year" entity to achieve your aim?

This can be found in the Time Range settings of your database. You can find more information here in our manual: https://www.boardmanual.com/Chapter_6_-_Database_Design_and_Management_files/Time_Range/Time_range.htm

Hope this helps,
Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------