Additional calendar in Time Range

BENOIT ROLLAND
BENOIT ROLLAND Active Partner
Second Anniversary First Comment 5 Up Votes
edited July 2020 in Platform
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
------------------------------

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited July 2020
    Hi @Benoit ROLLAND EYROLLES,

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

    image



    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
    ------------------------------
    -------------------------------------------
  • BENOIT ROLLAND
    BENOIT ROLLAND Active Partner
    Second Anniversary First Comment 5 Up Votes
    edited July 2020

    Hello @Helmut Heimann,
    Thanks for your reply.
    It's a solution that would answer the full year vision.
    However, the need is also to report data by quarter and have a QTD vision.

    It's almost like a school calendar to implement / setup, except that the shift is +2 months rather than +6.

    Didn't thought about such option, but does a flag could solve the issue?
    Thanks.

    ------------------------------
    Benoit ROLLAND EYROLLES
    Project Leader
    NEONN
    France
    ------------------------------
    -------------------------------------------
  • Dietmar Jeschkeit
    Dietmar Jeschkeit Active Partner
    Fourth Anniversary 100 Comments 25 Up Votes 25 Likes
    edited July 2020
    Hi @Benoit ROLLAND EYROLLES,

    the setup could be using the Fiscal Year from March. Then you have the opportunity to select either Year or Fiscal Year. The quarter is set to "normal" Year. With a custom time Dimension you can define also the quarter for the fiscal year (so quarter 1 ist from March to May and so on).
    What do you mean with a School calendar and shift +2 ?

    ------------------------------
    Dietmar Jeschkeit
    Senior BI Consultant
    Braincourt GmbH Gesellschaft für Managementberatung & Informationssysteme
    Germany
    ------------------------------
    -------------------------------------------
  • BENOIT ROLLAND
    BENOIT ROLLAND Active Partner
    Second Anniversary First Comment 5 Up Votes
    edited July 2020
    Hello @Dietmar Jeschkeit,

    Thanks for your reply; I'll make a try with this set up and will come back to you.

    School calendar: starts in July.
    Shift +2: calendar starts in March.

    ------------------------------
    Benoit ROLLAND EYROLLES
    Project Leader
    NEONN
    France
    ------------------------------
    -------------------------------------------

Categories