Clarity

 View Only
  • 1.  Extending DWH end period for cost plans/budgets

    Posted Apr 03, 2018 12:43 PM

    Piloting a project with a cost plan out to 2023-Q2.  (we have very long projects...)

     

    When building adhoc report in Jaspersoft, it only returns data out to 2021-Q1.

     

    Q:  How to extend DWH time periods to include, at least, through the end of our planned projects?



  • 2.  Re: Extending DWH end period for cost plans/budgets

    Broadcom Employee
    Posted Apr 20, 2018 12:11 PM

    Hi Dale,

     

    It appears the periods in the DWH are only going out to 2021-Q1.

     

    Would you please check the 13 FISCAL type slices in the Time Slices page and check the From Date and then count the Number of Periods to see if that goes through 2021-Q1? 

     

    I use the calculator at   Calculator: Add to or subtract from a date.

     

    If this returns a similar date you will need to add more periods to your FISCAL slices to increase the range.

    Once done, let the time slices complete then run

    Update Reports Tables with Calendar Option

    Load DW - Full Load

     

    Thank you,



  • 3.  Re: Extending DWH end period for cost plans/budgets

    Posted Apr 20, 2018 01:24 PM

    Thank you.  This will probably do the trick.  With the slice names prefixed with ‘baseline,’ ‘allocation,’ ‘assignment,’ ‘team’….wasn’t sure which, if any, were pulling from cost plans.

     

    Will reviewing with team whether to extend Number of Periods or pull From date ahead, or both.

     

    Will get back and indicate ‘correct answer’ when successful, probably in next week or two.

     

    Kind regards,

     

    Dale



  • 4.  Re: Extending DWH end period for cost plans/budgets

    Posted Apr 20, 2018 12:59 PM

    Check out the following documentation. They might be helpful:

    Configure the Data Warehouse and Advanced Reporting Domains

    Configure Time Slices