--- title: Clarity PPM | Mastering Slice Details description: In today's Q&A, we cover everything from slice details to removing the gridlines from your exported reports in Clarity PPM (CA PPM). image: https://media.licdn.com/mpr/mpr/AAEAAQAAAAAAAAgZAAAAJDgwNmZlZWM2LWNmZjktNDQ1YS05Njg0LTIxNWUzNDdjNzBlNg.jpg --- [![Rego-Logo_Notag-Color-350](https://blog.regoconsulting.com/hs-fs/hubfs/Rego%20Guide%20Images/Rego-Logo_Notag-Color-350.png?width=224&name=Rego-Logo_Notag-Color-350.png)](http://regoconsulting.com) - [Home](http://regoconsulting.com) [![](https://media.licdn.com/mpr/mpr/AAEAAQAAAAAAAAgZAAAAJDgwNmZlZWM2LWNmZjktNDQ1YS05Njg0LTIxNWUzNDdjNzBlNg.jpg)](https://media.licdn.com/mpr/mpr/AAEAAQAAAAAAAAgZAAAAJDgwNmZlZWM2LWNmZjktNDQ1YS05Njg0LTIxNWUzNDdjNzBlNg.jpg) # Clarity PPM | Mastering Slice Details We've got great material for you in **today's Q&A,** everything from *slice details* to removing the *gridlines* from your exported reports! ![Screen Shot 2017-01-27 at 8.21.39 AM.png](https://blog.regoconsulting.com/hs-fs/hubfs/Screen%20Shot%202017-01-27%20at%208.21.39%20AM.png?width=277&name=Screen%20Shot%202017-01-27%20at%208.21.39%20AM.png) And don't forget to sign up for [Clarity PPM (CA PPM) Training at RegoU while you can still get $300 off Main Event pricing until July 1st.](http://regouniversity.com/?CamilleLinkedIn27Jan) Here's a couple of our favorite quotes from participants. ## [RegoU is all about learning Clarity PPM without sales pitches.](http://regouniversity.com/?CamilleLinkedIn27Jan) *"Every year, regoUniversity continues to deliver. It always feels like I'm trying to drink from a fire hose while I'm there. I'm sure I'll be processing the information for weeks and months to come."*  *"I've attended all Rego University events, and it's now become "The" event to attend if you do anything with Clarity PPM. The sessions are informative, relevant, and cover just about anything you'd need from technical through functional, to administration and governance. Plus it's all about Clarity PPM—nothing else, and the price is amazing. 10/10" * ## [**So what are you waiting for? Early Bird Pricing Ends July 1st! **](http://regouniversity.com/?LinkedIn27Jan) And if you want to get emails about Rego webinars, free training, and our Clarity solutions library—the regoXchange—[sign up for our newsletter here. ](http://regoconsulting.com/ca-ppm/?LinkedIn27Jan) ## Now for the weekly Q&A!  ![](https://media.licdn.com/mpr/mpr/AAEAAQAAAAAAAAgZAAAAJDgwNmZlZWM2LWNmZjktNDQ1YS05Njg0LTIxNWUzNDdjNzBlNg.jpg)   1. What are the presets for **OOTB slices**?  2. Why are there **negative values in the WIP** table? 3. Can we add the **Resource Contact Information** fields to portlets? 4. **Assignment Time Slices:** Time Period Requested does not exist? 5. Advanced Reporting: Can we **remove the Excel gridlines**?   Please *feel free to comment on any alternative answers* you've found. We love your input (always).  ## 1. > *What are the presets for daily, weekly, and monthly OOTB slices? How many periods in the future and past are available within the RM planning portlets? * [Check out this document from CA.](http://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec439086.html) 28 Daily - One week in the past, the current day, and 3 weeks in the future 16 Weekly - 2 weeks in the past, the current week and 13 weeks in the future 36 Monthly - 4 quarters in the past, the current quarter and 7 quarters in the future Year, Quarter, and Monthly periods all use monthly slices The Weekly period uses weekly slices. The Daily period uses daily slices    ## 2. > *I thought the WIP tables didn't show negative values in the quantity column. For example, if a person adjusts a timesheet the new value would get stored and not a negative one. Am I losing it??  * Timesheets do not follow the same rules as WIP transactions. If a timesheet is adjusted, it posts a negative value to show the offset. If you’re not using timesheets and just manually or automatically enter transactions directly for WIP adjustments, you can just replace the original value with the new value.      ## 3.  > *Can you configure the Contact Information page on resources, or use those fields in portlets? * Good question. You can't configure the page or access it in any OOTB or resource object portlet. The display is completely driven by an Extensible Stylesheet Language file (xsl) (i.e. the xml version of a css page), so no studio views are tied to it. It is a legacy page that was used heavily in incidents. The data is stored in a separate resource table, SRM\_CONTACTS, which joins with SRM\_RESOURCES using the principal\_id. We advise folks NOT to use it. Best practice is to add custom fields to the resource object, instead of using the Contact Information page.    ## 4. > *What slice item needs to be setup to allow task assignments on projects to function properly? I have tried: Estimates, Assignment ETC Cost, Assignment ETC Actual, Project ETC for Labor Resources. I keep getting **time period requested does not exist.** I’ve verified the dates displayed are within the slice setup. I’m sure I'm missing something obvious. Thanks for the help!* **Out-of-the-box, these are the ranges of your internal (insta) slices: ** 28 Daily - 7 weeks in the past, the current day, and 3 weeks in the future 16 Weekly - 2 weeks in the past, the current week, and 13 weeks in the future 36 Monthly - 4 quarters in the past, the current quarter, and 7 quarters in the future    **The extension will change it to the following:** 42 Daily - 7 days in the past, the current day, and 4 weeks in the future 45 Weekly - 4 weeks in the past, the current week, and 40 weeks in the future 51 Monthly - 4 quarters in the past, the current quarter, and 12 quarters in the future  **This is the ONLY approved extension for the internal slices.**   ## 5. > *Can someone please let me know if there is a setting available in Advance Reporting to alter the format of an exported report? Recently, I exported a report in Excel, and the “View Gridlines” setting is automatically checked on the extracted Excel. Is there an option available to prevent exported Excel from showing the gridlines by default?* Set the following parameter to false:  net.sf.jasperreports.export.xls.show.gridlines    ## Thank You------------------------------   A special thanks to [Dan Greer, ](https://www.linkedin.com/in/danielgreer4rego/)[Virginia DeCeglia,](https://www.linkedin.com/in/virginiadeceglia/) [Doug Greer,](https://www.linkedin.com/in/douggreer/)[ Jenn Rinella,](https://www.linkedin.com/in/rinellajenn/) [Davey Zywiec, ](https://www.linkedin.com/in/davidbzywiec/)and [the Rego Team](http://regoconsulting.com/our-company/) for this Q/A material.     ## Join a Rego Guide------------------------------   [Half-day classes in Jaspersoft or Portfolio Management are Free and Limited. Sign up here.](http://regoconsulting.com/free-pm-and-jaspersoft-training/?LinkedIn37Jan) By [Camille Pack](https://blog.regoconsulting.com/author/camille-pack)|January 27, 2017 #### Share on Social Media - [Tweet](https://twitter.com/share) ### About the Author: [Camille Pack](https://blog.regoconsulting.com/author/camille-pack) ![Camille Pack](https://blog.regoconsulting.com/hubfs/profile%20camille200-2.jpg) Camille Pack has been in marketing for over a decade and started her career as a college composition instructor during graduate school. Technical writing lends itself well to mastery, and in her time at Rego, Camille offered clients product support, configured environments, and served as both a project manager for an internal reporting group and a business analyst for a large external client. Camille holds an MA in Literature and Writing, and a BS in Biology. ### Related Posts ![upgrading_Blog](https://blog.regoconsulting.com/hubfs/upgrading_Blog.jpg) [Permalink](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features) #### [Clarity PPM | Should We Upgrade to 15.5? - Modern UX Features](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features) November 05, 2018 | [0 Comments](https://blog.regoconsulting.com/whats-new-in-ca-ppm-clarity-15.5-modern-ux-features#comments-listing) ![](https://blog.regoconsulting.com/hubfs/regU-5-star-01.jpg) [Permalink](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience) #### [Clarity PPM | 5 Reasons You Can't Miss This PPM Conference](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience) November 21, 2017 | [0 Comments](https://blog.regoconsulting.com/ca-ppm-clarity-event-is-a-5-star-experience#comments-listing) ![](https://blog.regoconsulting.com/hubfs/regoU-01.jpg) [Permalink](https://blog.regoconsulting.com/five-reasons-to-attend-regouniversity-2018) #### [Clarity PPM | Five Reasons to Attend RegoUniversity 2018](https://blog.regoconsulting.com/five-reasons-to-attend-regouniversity-2018) September 11, 2017 | [0 Comments](https://blog.regoconsulting.com/five-reasons-to-attend-regouniversity-2018#comments-listing) ![](https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/rego_u_takeaways_Blog_760x230.jpg) [Permalink](https://blog.regoconsulting.com/5-regouniversity-takeaways-spectacular-ca-ppm-training) #### [Clarity PPM | 5 RegoUniversity Takeaways](https://blog.regoconsulting.com/5-regouniversity-takeaways-spectacular-ca-ppm-training) May 02, 2017 | [0 Comments](https://blog.regoconsulting.com/5-regouniversity-takeaways-spectacular-ca-ppm-training#comments-listing) ![4-27_LWR_Blog_760x230 (1).jpg](https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/4-27_LWR_Blog_760x230%20(1).jpg) [Permalink](https://blog.regoconsulting.com/dwh-cost-budget-plans) #### [Clarity PPM | DWH Cost & Budget Plans](https://blog.regoconsulting.com/dwh-cost-budget-plans) May 01, 2017 | [0 Comments](https://blog.regoconsulting.com/dwh-cost-budget-plans#comments-listing) ![Screen Shot 2017-03-24 at 3.49.45 PM.png](https://blog.regoconsulting.com/hubfs/Blog%20Images/RegoU-2017/Screen%20Shot%202017-03-24%20at%203.49.45%20PM.png) [Permalink](https://blog.regoconsulting.com/regou-is-almost-here-clarity-ppm-conference) #### [Clarity PPM | RegoU is Almost HERE!](https://blog.regoconsulting.com/regou-is-almost-here-clarity-ppm-conference) March 27, 2017 | [0 Comments](https://blog.regoconsulting.com/regou-is-almost-here-clarity-ppm-conference#comments-listing) [![Rego Home](https://no-cache.hubspot.com/cta/default/2652075/655865ab-5c17-4a7d-8626-9917913749d3.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/655865ab-5c17-4a7d-8626-9917913749d3) [![Contact Us](https://no-cache.hubspot.com/cta/default/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4) ### Subscribe to Email Updates [![Share on Facebook](https://static.hubspot.com/final/img/common/icons/social/facebook-24x24.png)](http://www.facebook.com/share.php?u=https%3A%2F%2Fblog.regoconsulting.com%2Fonly-3-days-left-to-get-early-bird-pricing-on-ca-ppm-clarity-training%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on LinkedIn](https://static.hubspot.com/final/img/common/icons/social/linkedin-24x24.png)](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.regoconsulting.com%2Fonly-3-days-left-to-get-early-bird-pricing-on-ca-ppm-clarity-training%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on Twitter](https://static.hubspot.com/final/img/common/icons/social/twitter-24x24.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.regoconsulting.com%2Fonly-3-days-left-to-get-early-bird-pricing-on-ca-ppm-clarity-training%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.regoconsulting.com%2Fonly-3-days-left-to-get-early-bird-pricing-on-ca-ppm-clarity-training%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=Clarity%20PPM%20%7C%C2%A0Mastering%20Slice%20Details) ### Recent Rego Articles ### Sign up for our Weekly Newsletter ![rego-logo-white](https://blog.regoconsulting.com/hs-fs/hubfs/rego-logo-white.png?width=205&name=rego-logo-white.png) As the leading PPM, Work Management, and Agile services provider, we have helped hundreds of organizations achieve a higher return on their software investment. ### CONTACT US Questions? We can help. [info@regoconsulting.com](mailto:info@regoconsulting.com) 888.813.0444 ### Stay up-to-date Get the latest news in industry best practices, thought leadership, and software updates. ### Solution Capabilities [Clarity PPM](https://regoconsulting.com/clarity-ppm/) [Rally](https://regoconsulting.com/rally/) [Apptio](https://regoconsulting.com/apptio/) [Sciforma](https://regoconsulting.com/sciforma/) [Jira](https://regoconsulting.com/jira/) [Microsoft | SharePoint](https://regoconsulting.com/microsoft/) [Smartsheet](https://regoconsulting.com/smartsheet/) [Meisterplan](https://regoconsulting.com/meisterplan-itdesign/) ### Quick Links [Our Company](https://regoconsulting.com/our-company/) [RegoUniversity](https://www.regouniversity.com/) [RegoXchange](http://regoxchange.com/) [Careers](https://regoconsulting.com/careers/)   Copyright 2022 Rego Consulting Corporation [Linkedin](https://www.linkedin.com/company/rego-consulting?trk=biz-companies-cym)[Facebook](https://www.facebook.com/RegoConsulting/)[Youtube](https://www.youtube.com/channel/UCdA5xEiDrX--y2nVX2wC1UA?view_as=public)[Twitter](https://twitter.com/regoconsulting) [Privacy Policy](https://regoconsulting.com/privacy-policy/) ![](https://dc.ads.linkedin.com/collect/?pid=14053&fmt=gif)