--- title: Clarity PPM | DWH Cost & Budget Plans description: Collect Clarity PPM (CA PPM) tricks, like finding the System Value for Total Cost of Capital and information on DWH Cost & Budget Plans. image: https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/4-27_LWR_Blog_760x230%20(1).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) [![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)](https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/4-27_LWR_Blog_760x230%20(1).jpg) # Clarity PPM | DWH Cost & Budget Plans Did you know Clarity PPM (CA PPM) has **Cost and Budget Plan updates** to the Data Warehouse? We'll cover a few of those details today and also share two useful tricks: how to **get rid of commas** in portlets and how to find the "**System Value for Total Cost of Capital**" schema. Please feel free to comment. At Rego, we always love your input.  ## Learn with Rego | Q&A 1. **"System Value for Total Cost of Capital"** Schema 2. DWH Includes **Cost & Budget Plans** 3.** Hide Comma** in Portlet Number Columns ## 1. Is the "System Value for Total Cost of Capital" stored in a table in PPM? I’ve looked around, but it looks like a virtual field. Only the “Override Value for Total Cost of Capital” is stored in FIN\_FINANCIALS.   SELECT TOTAL\_COST\_OF\_CAPITAL, REINVESTMENT\_RATE FROM PRSITE ## 2. What version of Clarity PPM includes the update to the DWH with cost and budget plans?   The 15.1 release has the Data Warehouse Options Update. Here are notes on the Administration Change: **Include Only Financial Plan of Record** *Specifies whether to include all financial plans (cost plans, budget plans, and benefit plans) or only the current budget plan and the cost plan of record in the Data Warehouse. Out-of-the-box, only the current budget plan, the cost plan of record, and associated benefit plans are included in the Data Warehouse. To report on only the current budget plan or the cost plan of record, keep the option selected. To compare previous plans with current plans on investments, unselect this option. Unchecking this option can impact the Data Warehouse performance. You may notice a significant difference in the load time for large data sets.*   ## 3. How do you hide the comma in a portlet's number column? I've unchecked "show separator," published the portlets, and cleared the caches. What am I missing? ![pastedImage_11.png](https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/pastedImage_11.png)   ![pastedImage_12.png](https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/pastedImage_12.png)   The workaround is to convert the column to string, and use it in the portlet.   ### Thank You------------------------------  A special thank you to [David Matzdorf](https://www.linkedin.com/in/dave-matzdorf-2295953/), [Virginia DeCeglia,](https://www.linkedin.com/in/virginiadeceglia/) [Ross Hensel,](https://www.linkedin.com/in/rosshensel/) [David Zywiec,](https://www.linkedin.com/in/davidbzywiec/)[Sankhadeep Dhar,](https://www.linkedin.com/in/sankhadeep/) and [the Rego Guides](http://regoconsulting.com/) for this Q/A material. By [Rego Consulting](https://blog.regoconsulting.com/author/rego-consulting)|May 01, 2017 #### Share on Social Media - [Tweet](https://twitter.com/share) ### About the Author: [Rego Consulting](https://blog.regoconsulting.com/author/rego-consulting) ![Rego Consulting](https://blog.regoconsulting.com/hubfs/Blog%20Images/Rego%20Consulting.jpg) As the leading PPM, ITBM, and Work Management services provider, Rego Consulting has helped hundreds of organizations achieve a higher return on their software investment, including 50% of Fortune 100 and 70% of Fortune 20 companies. ### Related Posts ![](https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20April/Project_access_LWR_Blog_760x230.jpg) [Permalink](https://blog.regoconsulting.com/how-much-project-access-is-too-much) #### [Clarity PPM | How Much Project Access is Too Much?](https://blog.regoconsulting.com/how-much-project-access-is-too-much) April 17, 2017 | [0 Comments](https://blog.regoconsulting.com/how-much-project-access-is-too-much#comments-listing) ![](https://communities.ca.com/servlet/JiveServlet/downloadImage/102-231174178-1-118217/LWR_SM_Community_header.jpg) [Permalink](https://blog.regoconsulting.com/inescapable-jexl-and-dependent-lookups) #### [Clarity PPM | Inescapable JEXL and Dependent Lookups](https://blog.regoconsulting.com/inescapable-jexl-and-dependent-lookups) April 10, 2017 | [0 Comments](https://blog.regoconsulting.com/inescapable-jexl-and-dependent-lookups#comments-listing) ![learn with rego orange.jpg](https://blog.regoconsulting.com/hubfs/Blog%20Images/learn%20with%20rego%20orange.jpg) [Permalink](https://blog.regoconsulting.com/how-to-unlock-the-clarity-role-lookup) #### [Clarity PPM | How to Unlock the Clarity Role Lookup](https://blog.regoconsulting.com/how-to-unlock-the-clarity-role-lookup) March 17, 2017 | [0 Comments](https://blog.regoconsulting.com/how-to-unlock-the-clarity-role-lookup#comments-listing) ![LWR_SM_Blog_863x430.jpg](https://blog.regoconsulting.com/hubfs/Blog%20Images/LWR_SM_Blog_863x430.jpg) [Permalink](https://blog.regoconsulting.com/a-simple-query) #### [Clarity PPM | A Simple Query](https://blog.regoconsulting.com/a-simple-query) March 03, 2017 | [0 Comments](https://blog.regoconsulting.com/a-simple-query#comments-listing) ![Estimate_Allocations_Blog_863x430.jpg](https://blog.regoconsulting.com/hubfs/Blog%20Images/Estimate%20Allocations/Estimate_Allocations_Blog_863x430.jpg) [Permalink](https://blog.regoconsulting.com/where-did-estimate-from-allocations-go) #### [Clarity PPM | Where Did ESTIMATE from ALLOCATIONS Go?](https://blog.regoconsulting.com/where-did-estimate-from-allocations-go) February 24, 2017 | [0 Comments](https://blog.regoconsulting.com/where-did-estimate-from-allocations-go#comments-listing) ![](https://media.licdn.com/mpr/mpr/AAEAAQAAAAAAAAgZAAAAJDgwNmZlZWM2LWNmZjktNDQ1YS05Njg0LTIxNWUzNDdjNzBlNg.jpg) [Permalink](https://blog.regoconsulting.com/only-3-days-left-to-get-early-bird-pricing-on-ca-ppm-clarity-training) #### [Clarity PPM | Mastering Slice Details](https://blog.regoconsulting.com/only-3-days-left-to-get-early-bird-pricing-on-ca-ppm-clarity-training) January 27, 2017 | [0 Comments](https://blog.regoconsulting.com/only-3-days-left-to-get-early-bird-pricing-on-ca-ppm-clarity-training#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%2Fdwh-cost-budget-plans%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%2Fdwh-cost-budget-plans%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%2Fdwh-cost-budget-plans%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.regoconsulting.com%2Fdwh-cost-budget-plans%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=Clarity%20PPM%20%7C%C2%A0DWH%20Cost%20%26%20Budget%20Plans) ### 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)