Clarity

  • Private Community

  • 1.  Upload all fiscal periods associated to entity in Datawarehouse

    Posted Nov 21, 2017 04:20 PM

    Hello,

     

    I have an financial  entity setup , with active fiscal periods from Jan 2016 to Dec 2018 by Monthly. But in data ware house table i can see only fiscal periods of 2018. Any inputs how to update the remaining fiscal periods.

     

    Please note datawarehouse jobs has already ran in full and incremental mode



  • 2.  Re: Upload all fiscal periods associated to entity in Datawarehouse

    Posted Nov 21, 2017 04:53 PM

    Hi Shammytaj,

     

    Can you please check if All Monthly time slices have the same From Date and Number of Periods ?

    If not, please update them and run the Load dataware house Job.

     

    Note:

    The same is true for Weekly, Daily, Fiscal, and so on. 

     

     

    Regards,
    Srikanth G



  • 3.  Re: Upload all fiscal periods associated to entity in Datawarehouse
    Best Answer

    Posted Nov 21, 2017 06:04 PM

    Hi Shammytaj,

     

    As per the design of DWH Annual Periods use the Monthly Periods as a basis. Years are set up for the Monthly ranges.

    So, please ensure that you have monthly periods defined as well and not just Annual periods for all the years. 

     

    Thanks

    Shailey