Our cost plans contain lines for two departments. How can I filter costs for Portfolio of one department in Clarity 13.3?
hello all Clarity experts,
let me re-phrase the question: Financial plans support 11 grouping criteria (Cost type being the latest). Can I filter costs of portfolio using any of them?
thanks a lot for the responses!
I don't believe so. Then again, not sure I fully understand where you want to filter these costs?
The portfolio drives off of the new capitalization feature primarily: (cost type) - operating vs. capitalization. But, the collective grouping attributes is not available in the Portfolio. This makes sense to me, as the grouping attributes are the means to view a more detailed breakdown of a cost plan.
But, when you look at portfolios, you are looking at a higher level: in this case, it would be to see how much out of the targeted budget is going to capital vs. operating costs. And, the targets are set for the overall budget, not budgeting per grouping attribute.
But I am not an expert on the portfolios (yet )..
Where exactly were you trying to filter out costs? Or maybe a better question is what exactly are you trying to achieve within a portfolio regarding this breakdown?
Per what user vtleogal2 already responded - the grouping criteria are not part of the attributes available in portfolio for filter in general.
From a technical tool perspective:
The Cost Type attribute is very special and while it happens to be one of the grouping criteria available on cost plan and it is also an attribute that is designed specifically to work in Clarity portfolio from v13.2 onwards. It is actually added to support top-down strategic planning, which expects budget and resource planning to start high level (eg. plan OpEx and CapEx budget, and rough role demand by Business Units or Department). Its treatment is very specific.
From setup/usage perspecitve:
If I read your original post correctly I think this is what you have setup and you are trying to do: In your project, you have created cost plans to indicate estimated cost by department for the project (for example, you will be engaging work with Department A for development, and it will cost 500K, based on the Department A resources you will be utilizing; and you are engaging Department B for 400K similar reason). You are wanting to get a portfolio department A level view across all projects that indicate there are costs associated with Department A, hence you want to add projects and then filter to show project costs related to specific department, grouped in the cost plan detail.
Unfortunately the current portfolio feature only goes down to the investment level granularity. The reason why Cost Type is available as a filter is because a rollup of financial values based on cost type is available at the investment level (see the Investment - Financial Summary page). That is actually what the portfolio uses when cost type is selected as a filter in portfolio. None of the other grouping criteria you see on cost plan has a natural project-level aggregation value available with the base product.
The department you can filter on is the financial department of the investment (ie. what I will call "responsible department" or "department managing the work", and not the ones you select or derive as part of cost plan). As business process, there is an assumption that internal chargeback will happen, and that the budget would be given to the "responsible department" and then chargeback rules can be setup to distribute the dollar back to departments that incurred the cost (such as those you identified in the cost plan, and in my example, incurred through labor supplied from those departments).
So what you are after, most probably needs to be a reporting or dashboard view with a filtering parameter on cost plan criteria "department" values.
RE: tsaca03: yes, you described the process almost 100% correct. Our set up considers so colled joint projects where costs of Business department and costs of IT department are cumulatively planned to calculate the overall business case of the project. The actuals are for both departments tracked in SAP and interface posts the actual costs as transactions in WIP. Other grouping criteria are Charge code = phase of project, Location and Transaction class (where short description of the transaction class was used to derive Capital and Operating cost category prior Cost type introduced in 13.2. We have upgraded from 13.1 to 13.3 in August this year to basically benefit from two features: Financial plans on Ideas and Portfolio Management module. Because of this limitation of Portfolio Management module (filtering costs of IT department when creating the IT portfolio) we have dropped our plans to activate the Portfolio Module because joint projects make 70% of overall project portfolio. We are going to build up portfolio reporting in WEBI
Could anyone from product management team answer if and when are the plans for summary fields for other grouping criteria of the financial plans on investment level?
Many thanks to all!
Retrieving data ...