Clarity

  • 1.  Daily Time Slice values not available in Data warehouse tables

    Posted Nov 18, 2016 07:42 AM

    I need to develop a Jasper soft report to fetch allocation and availability details between a begin date and end date. I checked in dwh tables, but there is only monthly and weekly slices. In Clarity, the data ware house check boxes for daily slices are not checked, that is why it is not populating in dwh tables. And I am not ale to check the Data Warehouse check boxes for Daily time slices in Clarity. Is there any possible way to get the daily slice values from dwh?



  • 2.  Re: Daily Time Slice values not available in Data warehouse tables

    Broadcom Employee
    Posted Nov 18, 2016 07:49 AM

    Hi Justine:

    I moved this to the PPM Community . To ensure a timely response and not to waste resources, please post to the correct community

     

    Thanks

    Hal German



  • 3.  Re: Daily Time Slice values not available in Data warehouse tables

    Posted Nov 18, 2016 08:00 AM

    Thanks

     

    On Nov 18, 2016 6:20 PM, "Hallett_German" <



  • 4.  Re: Daily Time Slice values not available in Data warehouse tables

    Posted Nov 18, 2016 09:11 AM

    Have you checked this ?

     

    CA PPM Tuesday Tip: How to Set Up the weekly DWH (Data Warehouse) time slices

    CA PPM Tuesday Tip: How to Set Up the DWH (Data Warehouse) time slices to avoid errors with the 'Update Report Tables' and 'Load DWH' jobs

     

    NJ 



  • 5.  Re: Daily Time Slice values not available in Data warehouse tables

    Posted Nov 18, 2016 09:18 AM

    Yes, I checked that. But I need to develop a report having parameters as begin and end dates, in which the user can choose the dates randomly. For that we cannot use weekly time slice right? That is why we need daily time slicing values from data ware house.



  • 6.  Re: Daily Time Slice values not available in Data warehouse tables

    Posted Nov 21, 2016 06:20 AM

    Thanks for the replies. But the problem is not yet resolved. Should I write query in niku database to get the Daily slice values?



  • 7.  Re: Daily Time Slice values not available in Data warehouse tables
    Best Answer

    Broadcom Employee
    Posted Nov 21, 2016 01:22 PM

    Hi Justine,

     


    Only Timeentries Daily slices (#55555) are now included in Data Warehouse. The rest of the slices are Weekly, Monthly and Fiscal. So at this point this is how things are designed.

     

    You may want to use the PPM datasource for your reports for now and raise an idea on the Ideas page to include the slices you need to be included OOTB.

     

    May I ask why exactly you need Daily slices in your reports? Why would your report not work with Weekly Allocation and Availability data instead?
    Usually the reporting goes by Months or Weeks and Daily precision is not needed as it is lower level. Please do include this explanation in your Idea as well so the Product Management team can consider this scenario of usage.

     

    Hope this helps -Nika



  • 8.  Re: Daily Time Slice values not available in Data warehouse tables

    Posted Nov 22, 2016 04:51 AM

    Thanks Nika. This is really helpful.