![PDB_2021_Logo_puzzle_no_box_2lineswhite.](https://static.wixstatic.com/media/6d7660_9782be9faa9b4c2a8a6eb7828b97f572~mv2.png/v1/fill/w_276,h_44,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/PDB_2021_Logo_puzzle_no_box_2lineswhite_.png)
Desktop Analyzer: Excel Front-End to SAP's PPM Module:
The Desktop Analyzer (version 4.93) suite of tools provides an Excel front-end to SAP’s Portfolio and Project Management (PPM 5.0 and 6.0) module, allowing users to update and analyze large quantities of data quickly and easily.
-
Set up your own Excel formulas to populate data.
-
Navigate the data cells as you would with any spreadsheet – arrow keys, page up and down, etc.
-
Cut/Copy and paste large blocks of cell values.
-
Use auto-fill to quickly populate many values.
-
Save your work to your desktop, work offline, then upload when you wish.
Editions of Desktop Analyzer
Ready To Use
-
Staffing Edition
-
Item Planning Edition (Financial & Capacity)
-
Resource Planning Edition
-
Master Data Edition
Work In Progress – New Editions
-
DP Based Planning Edition
-
Timesheet Edition
![](https://static.wixstatic.com/media/6d7660_4aec5212473e4e4ca189374277a7a67d.png/v1/fill/w_326,h_373,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/6d7660_4aec5212473e4e4ca189374277a7a67d.png)
Desktop Analyzer: Demo Overview
![](https://static.wixstatic.com/media/6d7660_cc611d00b8f44074a613d8b3599a808c.jpg/v1/fill/w_112,h_84,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_cc611d00b8f44074a613d8b3599a808c.jpg)
![](https://static.wixstatic.com/media/6d7660_7bbc2f195cf24777a82187fcd2f26972.png/v1/fill/w_77,h_60,al_c,q_85,usm_0.66_1.00_0.01,blur_3,enc_avif,quality_auto/6d7660_7bbc2f195cf24777a82187fcd2f26972.png)
![](https://static.wixstatic.com/media/6d7660_a7c96732fcab4b68be0835edee9be404.png/v1/fill/w_71,h_69,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_a7c96732fcab4b68be0835edee9be404.png)
Desktop Analyzer: Staffing Edition
The Desktop Analyzer – Staffing Edition allows you to download and update staffing information on your cProjects. Distributed role demand and staffing quantities are downloaded and easily updated in your Excel spreadsheet.
-
Download and upload distributed Role Demand and Staffing quantities for one or many projects, directly from the Excel toolbar.
-
Supported Distribution Units – Hour, Hours & FTE.
-
Supported Period Type – Monthly & Weekly
-
Hard-Booking & Soft-Booking Supported.
-
Add/Switch/Delete Staffing feature supported from Excel UI.
-
‘Resource Search’ functions available to aid Add and Switch staffing features.
-
Resource Net Availability and demand values with indicators displayed to support decision making.
-
Add and Switch staffing using Global ID (Business Partner ID) directly supported.
-
‘Project Search’ functions available
-
Role search with open demand via Role function and/or Role Type available (** New Feature)
-
Staff from a functional perspective by downloading only data from the Roles you are responsible for, across projects.
-
The upload is optimized for maximum performance.
-
Uses SAP security and encrypted Web Services.
-
Respects SAP locking – will not update the Item if another user has it open already.
![](https://static.wixstatic.com/media/6d7660_ccb88e0a03e54a58b39ae95400ffbc0c.png/v1/fill/w_110,h_110,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_ccb88e0a03e54a58b39ae95400ffbc0c.png)
Plan project roles and resources directly via Excel.
![](https://static.wixstatic.com/media/6d7660_263986456b8747e98a7bf6bebb8511a3.png/v1/fill/w_50,h_21,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_263986456b8747e98a7bf6bebb8511a3.png)
Desktop Analyzer: Item Planning Edition
The Desktop Analyzer – Item Planning Edition allows you to download and update financial and capacity planning information on your portfolio items.
-
Download and upload financial and/or capacity category/group/views for a single item, directly from the Excel toolbar.
-
Shift function allows you to move financial and capacity data by months and update item planned start and/or end date.
-
Support data filtering based on Category/Group/View.
-
Utility feature allows to perform simple arithmetic operations across views.
-
Forecasting Engine support (** New Feature)
-
Support Item Search
-
Enforces update of data only for planning period set for the item
-
Ability to update Decision Point dates. (Optional)
-
Uses SAP security and encrypted Web Services.
-
Respects SAP locking (it will not update the Item if another user has it open already).
![](https://static.wixstatic.com/media/6d7660_27b704180dba4dff8ad3ae59cf2e9745.png/v1/fill/w_108,h_100,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_27b704180dba4dff8ad3ae59cf2e9745.png)
![](https://static.wixstatic.com/media/6d7660_7c2331f2369444508936399a47fb6dd7.png/v1/fill/w_46,h_31,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_7c2331f2369444508936399a47fb6dd7.png)
![](https://static.wixstatic.com/media/6d7660_161013d7b7f74a3b9250efd1f2ea473e.png/v1/fill/w_45,h_29,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_161013d7b7f74a3b9250efd1f2ea473e.png)
![](https://static.wixstatic.com/media/6d7660_cc9c4f0376cb45379683fa962db183cd.png/v1/fill/w_45,h_23,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_cc9c4f0376cb45379683fa962db183cd.png)
Desktop Analyzer: Resource Planning Edition
The Desktop Analyzer – Resource Planning Edition allows you to download and update staffing information on your cProjects based on Resource Pool(s)/Resource(s). Staffing data for all the resources under selected resource pool(s) or individual selected resource(s) are downloaded and easily updated in your Excel spreadsheet.
-
Download and upload distributed Staffing quantities of all the projects for all the resources under selected resource pool(s) or for individual selected resource(s), directly from the Excel toolbar.
-
Supported Distribution Units – Hour, Hours & FTE.
-
Supported Period Type – Monthly & Weekly (**Newly Added)
-
Hard-Booking & Soft-Booking Supported. [Display Only] (**Newly Added)
-
‘Resource Search’ & ‘Resource Pool Search’ functions available
-
Staff from a resource manager’s perspective by downloading only data for the Resources you are responsible for, across projects.
-
Provides visual indicators for resource utilization based on customer defined rules.
-
The upload is optimized for maximum performance.
-
Uses SAP security and encrypted Web Services.
-
Respects SAP locking – will not update the object if another user has it open already.
![](https://static.wixstatic.com/media/6d7660_c9bc027eada546c9bdfc3ab3d9a65729.png/v1/fill/w_106,h_85,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_c9bc027eada546c9bdfc3ab3d9a65729.png)
![](https://static.wixstatic.com/media/6d7660_43fa7b0a77b64ec4b71d9b38c0f7eaec.png/v1/fill/w_47,h_22,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_43fa7b0a77b64ec4b71d9b38c0f7eaec.png)
Desktop Analyzer: Master Data Edition
The Desktop Analyzer – Master data Edition allows you to download and update Item and Project fields in Excel. Each Item or Project is a row in your Excel spreadsheet.
-
Download and Upload up to 1000 Items at once, directly from the Excel toolbar.
-
Supports What-If versions.
-
Supports filtering of items to be downloaded.
-
Spreadsheet formats are configurable from the SAP server – determine which fields are included and which may be updated.
-
The upload is optimized for maximum performance.
-
Uses SAP security and encrypted Web Services.
-
Respects SAP locking – will not update the Item if another user has it open already.
![](https://static.wixstatic.com/media/6d7660_f3ba8fbe6c9e40ab854a5f4d9835f3c8.png/v1/fill/w_75,h_83,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_f3ba8fbe6c9e40ab854a5f4d9835f3c8.png)
Select the fields you desire to update for 1 or 1,000 projects.
![](https://static.wixstatic.com/media/6d7660_4acb00bc0d134d698a36867acde564b9.png/v1/fill/w_45,h_24,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_4acb00bc0d134d698a36867acde564b9.png)
Desktop Analyzer: DP (Decision Point) Based Planning Edition
The Desktop Analyzer – DP Planning Edition allows you to update Decision Point dates and financial/capacity data for each Decision Point.
![](https://static.wixstatic.com/media/6d7660_e9efb948bd4947ac9980b823e114ece9.png/v1/fill/w_46,h_30,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_e9efb948bd4947ac9980b823e114ece9.png)
Desktop Analyzer: Timesheet Edition
![](https://static.wixstatic.com/media/6d7660_f7324555826f4009a32ad973533ed9d6.png/v1/fill/w_56,h_17,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_f7324555826f4009a32ad973533ed9d6.png)
Desktop Analyzer: Future Releases
Support for PPM 6.0
-
Staffing Edition
-
Restrict role downloading based on selected role function id(s) for project(s).
-
Restricting resource search based on selected role function id(s). [Assumption – 1:1 mapping between role function id & resource pool]
-
Create/Change/Delete Role feature support from Excel UI
-
-
Item Planning Edition (Financial & Capacity)
-
Support for switching planning data displayed – VCG, CGV, CVG.
-
Initiative Planning from Excel UI.
-
-
Master Data Edition
-
Support for Initiative Master Data Maintenance
-
![](https://static.wixstatic.com/media/6d7660_65c2471e93cd4f9595c76f708065f762.png/v1/fill/w_60,h_105,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_65c2471e93cd4f9595c76f708065f762.png)
Desktop Analyzer: Landscape Overview
![](https://static.wixstatic.com/media/6d7660_10fba8f212dd413da49fd809a4995415.png/v1/fill/w_89,h_55,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_10fba8f212dd413da49fd809a4995415.png)
Desktop Analyzer: Technical Overview
Technology Platforms
-
SAP: ABAP, web service configuration
-
Excel: .NET (C#)
Software & Versions Required
-
NetWeaver 7.02 with SP06 as the minimum patch level
-
SAP PPM 5.0 is SP4
-
MS Excel 2007 and above
-
Visual Studio 2008 and above
Target OS and Office version combinations
-
Windows 7: Office/Excel 2013, Office/Excel 2010, Office/Excel 2007
-
Windows XP: Office/Excel 2007
Prerequisites on Client System
-
Microsoft Office 2007, 2010, or 2013
-
Microsoft .NET Framework 3.5 or 4.0
-
Microsoft Visual Studio 2010 Tools for Office runtime
-
Microsoft Redistributable Primary Interop Assemblies
![](https://static.wixstatic.com/media/6d7660_3e30ba92536b41b1aac76ee33bf04b94.png/v1/fill/w_91,h_124,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_3e30ba92536b41b1aac76ee33bf04b94.png)
Desktop Analyzer: Implementation Scenario
![](https://static.wixstatic.com/media/6d7660_226cae76b63e47d3ab1a35849ec66a38.png/v1/fill/w_81,h_87,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_226cae76b63e47d3ab1a35849ec66a38.png)
Scenario: Customer Implements Item Planning Edition
-
SAP: move a transport request to customer development environment
-
Config. Web-Service directly in environment
-
SAP Table Config: Map Item or cProject level fields
-
Item Master Data only
-
cProject Header Level Master Data only
-
-
Client side installation: Excel Add-In
Desktop Analyzer: Questions Customers Ask
![](https://static.wixstatic.com/media/6d7660_f87e68022fa64888a0e6341bf9f5683d.png/v1/fill/w_193,h_286,al_c,q_85,usm_0.66_1.00_0.01,blur_3,enc_avif,quality_auto/6d7660_f87e68022fa64888a0e6341bf9f5683d.png)
Can we own the source code?
-
SAP code is owned by customer
-
Excel side of code owned by PDB. It’s delivered as an executable (.EXE)
Can we perform the enhancements?
-
SAP code: YES
-
Excel side of code performed by PDB
Desktop Analyzer: 3 Key Points
![](https://static.wixstatic.com/media/6d7660_dd57cb89926b46cfa672d5940f30e9ce.png/v1/fill/w_98,h_71,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_avif,quality_auto/6d7660_dd57cb89926b46cfa672d5940f30e9ce.png)
-
Desktop Analyzer can be used for master data maintenance, planning or staffing.
-
Many of SAP’s screen can be replaced with user friendly Excel interface using Desktop Analyzer.
-
Already user friendly screens of DA editions can be further customized based on client requirement.