Bookshelf Home | Contents | Index | PDF |
Siebel Reports Administration Guide > Actuate Library Reference > Actuate sscustom Library > How to Display Revenue Information in Siebel ReportsWhen you are creating datastreams with Siebel Tools, each field is mapped to a data row variable, of string data type. If the field is defined in the Siebel application as being a currency, then Siebel Tools will map two string variables into the data row: The standard revenue contains the value of the field, contained in a string (for example, The following explains how Siebel reports handle calculated currency. There are three steps involved in the calculation and display of currencies:
One more issue to handle for currencies is multicurrency calculations. Multicurrency processing is a long-existing issue for reports because of their inability to do conversion between currencies. A solution is to have two values (item and system currency) for any currency type field (revenue, cost, and so on). This way, there is a unified approach to the aggregation of different currency values. System currencies display line items in their item currency formats, and aggregate values are displayed in the system currency format. To support this idea, the business component that supplies a report with data must have each currency field in two flavors: Function-Currency-Value (system-based) and Currency-Value (item currency). If the text control represents the sum of multiple rows of data in the AFTER section, use the numeric revenue amount. The ValueExp property can be formulated as follows: FormatSpecificCurrency(Sum(CurrencyValue),"USD"). Actuate cannot sum formatted data, so the expression shown previously will be formatted by the FormatSpecificCurrency( ) function described in the sscustom.bas. For multicurrency calculations, include the Functional Revenue (the revenue value in the functional currency) and the Functional Currency Code (for example, USD) in your report and subreport fields when you define the ROL file in Siebel Tools. For an example of multicurrency calculations, see the Pipeline Report By Rep (PIPEREP) standard report. |
Siebel Reports Administration Guide | Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |