Ask the community

I’m looking for a report or resource view to identify overallocated resources working on a collection (portfolio) of projects.  The Staffing view for a single project (work) is perfect.  It shows remaining capacity and includes work both on the selected project as well as any other projects where those resources are allocated.  I’m looking for the same view, except I want to select a work portfolio to identify the resources to review.  WRK29 - Resource Utilization sort of does this, but it is a bit cumbersome.  Does anyone know of another report or screen that I’m missing?  I know I can get there with a custom Power BI report, but I’m hoping that there may be a simpler option.

Looking to add a CUSTOM long text data field to the ODATA feed that I can use on my Power BI portfolio dashboard.  I’d like to add it to the Project Dimension but I cannot get the SQL working correctly.  I have tried this, isNull((select s.description    from ip.structure s    where s.structure_code=pv.overall_stat_comm), 'Unassigned') as [Overall Status Assessment] and I have tried this,(select STRING_AGG(CONVERT(NVARCHAR(max),line_text), '') within group (order by isnull(line_number, 1) asc)from ip.long_textwhere key1 = 'overall_stat_comm' and key2 = pv.ppl_code) as [Overall Status Commentary]As you can see, i’m feeling around in the dark here so any assistance greatly appreciated.

I am the Admin for our organization and I have a need to see who created a work Portfolio.  How do I go about seeing that information.

We’ve recently implemented Logbook and configured it with our PowerBI dashboard. For the Risk type log we mimicked the values for Response Strategy and Escalation Level in both Planview Admin and also in Portfolios. Problem: On the Risk Matrix report page in PowerBI (on the bottom Table visualisation), Escalation Level values are populating however Response Strategy is not.   Strangely, on the ‘risk by Response Strategy’ Funnel visualisation, the values are appearing correctly (see below). I appreciate suggestions or help in troubleshooting. (I’m a PowerBI beginner)

I’d be keen to hear from any Planview customers who have particularly complex Role hierarchies and Rate cards to understand how you cope with all of the day to day maintenance.We have around 10,000 resources, split across 350+ roles with a constant demand for more to be added. Associated with this is a need for more accurate cost recovery, so an ever-increasing number of rate cards which would potentially run at an individual level or using multiple attributes which Portfolios doesn’t appear to support. Combined with a constant churn or individuals between roles and timing impacts of when individuals can move roles without impacting their timesheets, this is becoming a challenge which will ultimately be unsustainable.With the benefit of hindsight I think it’s fair to say we may have structured our resources differently to limit/standardise the number of roles and that’s currently under review, but what I can’t understand is how we can address the Role and Rate manageme

This is more directed specifically at Planview but good awareness for other customers as well. When utilizing SOAPUI calls there are some characters that cannot be passed. It is our understanding that per Planview's security rules that PVMaster password can no longer be something the customer identifies but instead an autogenerated password that Planview creates and then advises the customer on what that password is. When using this new password within SOAPUI calls it has to be wrapped in CDATA tag because of the characters needing to be passed.  Why would an autogenerated password be created that violates character rules?  Ideally this would exclude some characters so this additional step is not needed.I thought about adding this as an enhancement request but my assumption is that the number of participants within that campaign that understand this technical component would never allow it to reach the required number of votes to be reviewed further.  If

I am quite new to PV and I wonder what URL parameters are available in Planview. Explicitly I tried to create a link based on a Work ID. Unfortunately, it seems that only the Project Code (sc=12345) is used in the URLs. For the end-user, only the Work ID is know and available in our overviews. This makes it difficult to create direct links for example in automatically created reminder mails. Is there any documentation which parameters are available? As it might be a customized thing, I already asked my admin but he isn’t aware...maybe I asked the wrong question?Any hint is appreciated:) Thanks in advance.Example:xxxx.aspx?pt=PROJECT&sname=$Plan&sc=12345&mdl=1&ver=1#tab-STRATEGIES

I currently have my CRI details (Risk Details, Issue Details, Change Details) configures screens all with the ‘Legacy Screen’ tick next to them. I understood that when I open these in Design mode that I should be prompted to upgraded them.  This isn’t the case and I’m not able find any info on how to trigger the upgrade of these configured screens.Any help appreciated

Hi Planview,Please can you update the data relating to ip.planning_entity as code27 marked as ‘depricated’. I have been informed this is not the case. Can you also add this back into the table, I have included the link below, thanks in advnace.https://success.planview.com/Planview_Portfolios/Analytics_and_Reporting/Database_Schema_Guide/055_Table_Descriptions_5#:~:text=Percentage%20share-,PLANNING_ENTITY,-This%20table%20containsRegards,Haydn

Dear Community Group,Due to changes in CBS1, we had to add a new layer. That's where the trouble began - we needed to modify the association of financial elements with CBS1. After quite the adventure, we successfully made the changes. Neither we nor CustomerCare can see any elements that still have financial data and running queries returns no results.However, when trying to use the Insert/Paste Under function, we get the following error:"Insert/Paste Under not allowed because Structure is used by financial planning."Has anyone encountered a similar issue? Financial data has been cleared, and all checks come back empty. If anyone has faced this and found a solution, we'd really appreciate your insights!CustomerCare hasn’t been very helpful beyond referring us to consulting, which, according to them, uses the same verification tools they do.Thanks in advance!Michal 

We have a unique actual time billing process that requires us to pull actual time data from Planview Portfolios before the end of the month for some, but not all of our groups reporting time.  This is typically in the last week of the month.   We attempt to use the Cutoff Date to limit user’s ability to disapprove and edit timesheets that have already been billed.  Other groups however,  do not bill and would prefer to apply a different cutoff date,  typically further in the past.  We don’t see a way to adjust cutoff dates by Providing Org, Resource Node, or some other Resource Attribute.   Curious if anyone has a similar Use Case and/or ideas to solution this scenario.  

I am curious what other customer do to provide read/view only access in Portfolios.   We have two types of roles but neither is quite right.   We go between the Team member role but that roles doesn’t allow access to Strategy and Programs or a Requestor role but this role doesn’t allow the user to create/maintain portfolios.    We would love to use the Requestor license more but are worried about the administration of the portfolios that is needed to support this type of role.     Any thoughts appreciated.

Hello.  My use case is that a) I need a means to pull financials (rates) being forecast for individual resources by activity / project.  I know I can leverage RES24 which you can total up costs and list the rate associated with resource (by activity / project) but the monthly view appears to only allow views for hours, days, and FTE.  I’d like to quickly see costs.   To that end, my second (and most important) use case is that on top of that I would also like to include actuals for months prior in the year.  Again, RES24 can do this but the actuals appear on another line on the report versus the same line which lists the work, prior hours, and future allocated hours.  Any way around all of this or perhaps a different report?  Thank you!!

Hi all,Has anyone successfully restricted users to only Add and Modify the Task’s Planned Expenditure without allowing them to Delete? We aim to enhance our security in this area, as deletions are impacting other integrated systems.Any insights would be greatly appreciated.Thank you!

We have a few users testing importing projects from MS Project to Portfolios using the MS Project add-in.  When trying to upload a MS Project plan (.mpp) to Portfolios, users are experiencing an error that I’m not sure how to troubleshoot. “-General Failure: Unable to update projects with tasks:  Index was out of range. Must be non-negative and less than the size of the collection .Parameter name: index” Anyone have any tips on what could be causing this error?  Thank you,Sonia Varney

Hi All,Recently we experienced missing data in table ip.vw_exch_rate_change_point, which is a key financial table as its used via function: pfn_exch_rate_on_date to convert from one currency to another, and interested to know if this is isolated to us, or not?

Users are experiencing discrepancy in the allocations when viewing in days/FTE values in Plan vs Staffing Screens.Context: For Permanents they have 35hr/week calendar and for contractors they have 40hr/week calendar. When a permanent resource is allocated 100% on a project they are showing up as 17.5d in Apr 2024, whereas same resource in Staffing screen is showing up as 20.0d.Is there any way to make sure both screens follow same calendars and avoid confusion?

Is there a way to capture hours on a salary employee that is more than 40 but only capture cost for 40 in the financial plan. We want to understand the true hours people are working on projects, which can be more that 40 hours but we also need to have the financial plans recognize the true cost for salary employees (which will always be 40) This can not be a global setting because we have Salary, Fixed Fee and Time and Material employees.  Thank you 

We had been struggling with what we thought was a bug in the OOTB Work Dashboard.  Sometimes the number of projects on the dashboard against the datamart didn’t match the number of project shown in the active portfolio run against the transactional dashboard.  We knew the mismatch was not related to any refresh timing.  Further we could see that the data was actually up to date in the datamart.We were told by a PV reporting consultant that this is actually a “feature” and the reason for this is due to a portfolio itself needing to be refreshed/rerun.   So if you try to run the dashboard against a portfolio that hasn’t been run recently, it’s like the data will be stale in the dashboard view.    Have others seen this issue and do you have a workaround?  This is totally unacceptable and it is really tough to explain to end users who want to understand why the data isn’t lining up. 

Does anyone have any suggestions for entering time in bulk for a group?  We have a need to capture the hours associated with some groups outside our normal Portfolios Users and Resources.  We can easily create a Resource and call it “Contractors” or “Marketing Team”, but if we have another User enter time for the entire team on a weekly timesheet, we are limited to a maximum of 168 Hrs (7D * 24Hr).  We don’t need or even want the detail down to the names.  We would like to be able to enter using timesheet functionality and view the effort within our existing timesheet reports. FWIW - This portfolio is not part of an automated financial load and is not intended to be loaded into the financials for the work.

Does time entry require resource to have read write access to their resource record?In our resource management process (because resource has RW access to their own resource record), that resrouce is able to modify their utilization for each project they are allocated.  Our desire is that only the supevisor (resource manager) should be able to modify these allocations.  Any inputs or suggestions in Customer Solution Center are appreciated.Joe

 Good day, We desire to update the Changes, Risks, and Issues Tabs that are available for Work Entities. I have found this article on the Planview Customer Success Center which goes over these 3 tabs, including information on how users can customize the attributes and order displayed here. It is a nice feature that the users can update these views to their own preferences - however we are seeking a way to set up a default selection & order of the attributes displayed on these screens.  I have been digging through the success center and different admin screens to no avail. Can anyone help me locate where I can access these options, if they exist? Ideally we would have a set of default selecte

Have just installed the Power BI portfolio dashboard in Planview Portfolios and in the project details drill down I have missing data under some fields. In the screenshot below you will see that the Work Manager and the Work Sponsor  are unassigned and I’m not able to identify where these are being drawn from in Planview and how to ensure the fields are populated.  Any ideas welcome. thanks 

Howdy,We are currently trying to simplify our Change Control process. It seems we keep having problems keeping our plans and financials correct when we are going though the Change Requests. Curious to hear how everyone else handles Change Requests.

I currently have 4 finance model versions.  I am trying to set up a model which displays the combination of Actuals for past months and Forecast for future months.  This data I am loading manually directly into 2 separate versions. Is there a way I can get this data to display in a single combined version?