User manual BUSINESS OBJECTS PROFITABILITY AND COST MANAGEMENT 7.0 FOR WINDOWS DATABASE GUIDE FOR MS SQL SERVER

[. . . ] Profitability and Cost Management Database Guide for Microsoft SQL Server BusinessObjects Profitability and Cost Management 7. 0 windows Copyright © 2009 SAP® BusinessObjectsTM. SAP BusinessObjects and its logos, BusinessObjects, Crystal Reports®, SAP BusinessObjects Rapid MartTM, SAP BusinessObjects Data InsightTM, SAP BusinessObjects Desktop IntelligenceTM, SAP BusinessObjects Rapid Marts®, SAP BusinessObjects Watchlist SecurityTM, SAP BusinessObjects Web Intelligence®, and Xcelsius® are trademarks or registered trademarks of Business Objects, an SAP company and/or affiliated companies in the United States and/or other countries. SAP® is a registered trademark of SAP AG in Germany and/or other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Flag any property items in the load dataset that are duplicates, and leave just the one copy. Identify records with matching keys then remove matching records from the schema where Loadstatus is 70. Flag any property names which do not exist where Loadstatus is 1 for later use. Add all new property that have passed validation at the root level. Update any existing property items for supplied default value. Update the load status for processed items (apart from status 70). Property Item Value Load Pre-validation Steps: 1. Validate Model identifier supplied is valid. Validate Load identifier supplied is valid. Validate User identifier supplied is valid. Gather statistics if inStats parameter set to true. Flag any property items in the load dataset that are duplicates, and leave just the one copy. Identify records with matching keys then remove matching records from the schema where Loadstatus is 70. Flag any property names which do not exist where Loadstatus is 1. Flag any dimensions types which do not exist where Loadstatus is 1. Flag any dimension item names which do not exist where Loadstatus is 1. Update any existing property item values for supplied value. Add all new property item values that have passed validation at the root level. Update the Loadstatus for processed items, apart from status 70. 86 Profitability and Cost Management Database Guide for Microsoft SQL Server Data Loader for Microsoft SQL Server Procedure Logic 4 Value Load These are data only related procedures and in the main, validation will center on ensuring that the names supplied exist in the model being loaded. Cases exist where one loading table can supply more than one database table. An example of this is the Line Item Value procedure, where one record can potentially create two rows in the Profitability and Cost Management schema, one in PP_LINEITEMVALUE and the other in PP_LINEITEMDELTA, assuming of course the VALUE and the DELTAVALUE fields in the staging table are non-zero. The following sections detail the validation steps taken for the value procedures. All value procedures generally follow a similar format. [. . . ] TEXIST The Metric name does not exist (Values). udfMETRICNAMENOTEX IST 29 30 31 33 35 36 38 The Employee name does not exist udfEMPLOYEENAMENO (Values). TEXIST The Detail Cost Object 1 name does not exist (Values). The Detail Cost Object 2 name does not exist (Values). [. . . ]