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?
I moved this to the PPM Community . To ensure a timely response and not to waste resources, please post to the correct community
On Nov 18, 2016 6:20 PM, "Hallett_German" <
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
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.
Thanks for the replies. But the problem is not yet resolved. Should I write query in niku database to get the Daily slice values?
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
Thanks Nika. This is really helpful.