User manual BUSINESS OBJECTS FINANCIAL INFORMATION MANAGEMENT 7.0 FOR WINDOWS

[. . . ] BusinessObjects Financial Information Management IT User Guide Financial Information Management 7. 0 windows Copyright © 2008 Business Objects, an SAP company. patents, which may cover products that are offered and licensed by Business Objects: 5, 295, 243; 5, 339, 390; 5, 555, 403; 5, 590, 250; 5, 619, 632; 5, 632, 009; 5, 857, 205; 5, 880, 742; 5, 883, 635; 6, 085, 202; 6, 108, 698; 6, 247, 008; 6, 289, 352; 6, 300, 957; 6, 377, 259; 6, 490, 593; 6, 578, 027; 6, 581, 068; 6, 628, 312; 6, 654, 761; 6, 768, 986; 6, 772, 409; 6, 831, 668; 6, 882, 998; 6, 892, 189; 6, 901, 555; 7, 089, 238; 7, 107, 266; 7, 139, 766; 7, 178, 099; 7, 181, 435; 7, 181, 440; 7, 194, 465; 7, 222, 130; 7, 299, 419; 7, 320, 122 and 7, 356, 779. Business Objects and its logos, BusinessObjects, Business Objects Crystal Vision, Business Process On Demand, BusinessQuery, Cartesis, Crystal Analysis, Crystal Applications, Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Crystal Vision, Desktop Intelligence, Inxight and its logos , LinguistX, Star Tree, Table Lens, ThingFinder, Timewall, Let There Be Light, Metify, NSite, Rapid Marts, RapidMarts, the Spectrum Design, Web Intelligence, Workmail and Xcelsius are trademarks or registered trademarks in the United States and/or other countries of Business Objects and/or affiliated companies. SAP is the trademark or registered trademark of SAP AG in Germany and in several other countries. [. . . ] You do this via the Table Comparison transform that deals with duplicates, for example, in the case where a customer may want to read the same source data again. Under "Table Comparison" browse to locate the table that you are going to use, in this case, FIM_demo. FIM_REF_70. TRANSACTIONTABLE 2. Delete the data under "Input Primary Key Columns" and "Compare Columns" Under "Schema In" drag the primary keys from the source to "Input Primary Key Columns". Highlight all the source data and drag below "Compare Columns". The next mandatory step is to filter data by adding a WHERE clause. 24 BusinessObjects Financial Information Management IT User Guide Setting up a BusinessObjects Data Services Job Using the Financial Information Management template in BusinessObjects Data Services 2 Filtering data Next you need to modify the global variables to allow the customer to set constraints on the data, for example, a data entry period. You can view the global variables of the job by clicking the Variables icon on the main toolbar. This consists of setting a WHERE clause. Enter constraints on the data, for example: ( DEMO_GL. PRODUCT like $Custom1 OR rtrim(ltrim($Custom1, ' '), ' ') IS null OR rtrim(ltrim($Custom1, ' '), ' ') like '' ) AND ( DEMO_GL. ENTITY like $ReportingUnit OR rtrim(ltrim($ReportingUnit, ' '), ' ') IS null OR rtrim(ltrim($ReportingUnit, ' '), ' ') like '' ) AND ( DEMO_GL. PERIOD like $DataEntryPeriod OR rtrim(ltrim($DataEntryPeriod, ' '), ' ') IS null OR rtrim(ltrim($DataEntryPeriod, ' '), ' ') like '' ) You can enter various conditions under the WHERE tab. Now that you have loaded a new transaction table you can continue loading it with new periods. Reading the transaction table The next step is to read the transaction table and to finally populate the data into Financial Consolidation. In the "Project Area" click DEMO_Load_DF The workspace opens to display the load data flow. Delete the transaction table. BusinessObjects Financial Information Management IT User Guide 25 2 Setting up a BusinessObjects Data Services Job Using the Financial Information Management template in BusinessObjects Data Services 3. In the "Local Object Library" browse to locate the new transaction table that you created. Drag the new transaction table to the workspace, make it the source, and connect it to the Aggregate icon. Double-click the Aggregate icon to open the "Schema In" - "Schema Out" page. Under "Schema Out", the transaction table, select the Financial Consolidation variables and drag them below Aggregate 8. Highlight the same columns and drag them below the "Group by" tab. Pivot columns In order for the web service to function correctly you need change the pivot columns. Highlight the Financial Consolidation data and drag it below. "Pivot Columns" Configuring the web services address the last step in creating your job is to configure the Financial Consolidation web services address. Enter the web service URL as follows:http://MyFinanceServer/MyData Source/DataImportServices. asmx?wsdl 6. Click OK. 26 BusinessObjects Financial Information Management IT User Guide Setting up a BusinessObjects Data Services Job Using the Financial Information Management template in BusinessObjects Data Services 2 Adding WS message for SOAPHeader and ImportPackageData The WSPrep is always the same schema for Financial Consolidation calls. In this procedure you use existing data to create the WS message for the web service call. Under "Schema Out"WScall highlight the function DEMO_WS. . ImportPack qgeDataEx and right-click. In the "Select Function" dialog box, select "DEMO_WS" the click Next. In the box in the lower part of the dialog box type WSPrep. SOAPheader 6. [. . . ] The name of each transaction table column must match a Finance dimension short code. The transaction table is queried when you use the drill-to-origin feature to the display the origin of data. You do not see the entire transaction, but rather see the results of the query. Note: the Data Services job is responsible for populating transaction tables. Financial Information Management never writes to these tables directly. Related Topics · Finance dimension codes on page 37 Finance dimension codes For reference, below is a list of default Finance dimension short codes Code CA DP RU CU AC FL PE AU Sdesc Category Dat. [. . . ]