1 Reply Latest reply: Jun 18, 2013 6:48 AM by Karthikeyan S RSS

    Handling Multiple Calendars

    Danielle van Eeden

      Hi All,

       

      My dataset uses multiple calendars based on different milestones (for example Order Date, Despatch Date, Delivery Date etc). Usually this is not a problem, as my reports generally only look at one date parameter (for example everything delivered within a week / month / year).

       

      However, I now have a requirement to look at everything Despatched within a week alongside everything Delivered within a week. So for example, I would have a table showing the values of everything Despatched in week 20, next to a table showing everything that was Delivered in week 20.

       

      So I'm basically interested to know if others have had to deal with this sort of thing, and what your solutions have been? I'm concerned that there is no way of dealing with this requirement, without it getting messy?

       

      Ideally |I'd like to have one calendar which somehow links to all other calendars, but I'm not sure if this is possible?

       

      Any help greatly appreciated!

        • Re: Handling Multiple Calendars
          Karthikeyan S

          Usually we are creating separate master calender table with out any link with other transaction table.

           

          It is island table. Table will look below,

           

           

          LinkDateWeekFromDateWeekToDate
          18-Jun-1316-Jun-1322-Jun-13
          19-Jun-1316-Jun-1322-Jun-13
          24-Jun-1323-Jun-1329-Jun-13

           

           

          Sales Target Tablewill Look like below

           

           

          STDateSTValue
          18-Jun-1330.00
          18-Jun-1350.00
          24-Jun-1380.00

           

           

          Sales Table will look like below,

           

           

          SalesDateSalesValue
          13-Jun-1330.00
          19-Jun-1350.00
          24-Jun-1380.00

           

           

           

           

          Then we are writing expression like below

           

          =Sum({$<STDate ={'>=$(=WeekFromDate)<=$(=WeekToDate)'} >} STValue )

           

          Sum({$<SalesDate={'>=$(=WeekFromDate)<=$(=LinkDate)'} >} SalesValue)

           

          Users will select "LinkDate" for viewing report.

           

           

          Karthik