The exchange rate in the BW system may not be updated one. Also the business wants to see the amounts according to the exchange rates in the source. In such cases, you have to update the exchange rate in the BW system via process chain. Include the step ‘Execute ABAP Program’ in the process chain. Give the program name as ‘RSIMPCURR’. Create a variant for the program.
Both Ranges and Select-Options are used for maintaining Ranges. Select-Options are used for taking input from user on selection screen In case of Select-Options system itself creates an internal table In case of Ranges, the internal table should be defines explicitly The internal table contains four fields- Sign, Option, Low and High . Special operator IN is used in comparisons. SIGN The data type of SIGN is C with Lengh 1. Possible values are I and E. I stands for "inclusive" (operators are not inverted) E stands for "exclusive" (operators are inverted) OPTION The data type of OPTION is C with length 2. OPTION contains the selection operator. The following operators are available: if HIGH is empty, you can use EQ, NE, GT, LE, LT, CP and NP. if HIGH is filled, you can use BT (Between) and NB (Not Between) LOW To maintain lower limit of range. HIGH To maintain higher limit of range. Ex: SELECT-OPTIONS range_ex FOR sy-index. SELECT-OPTIONS matno FOR mara-matnr. RANG...
This post provides guidelines for managing space in the SAP BW Production environment in general. It describes these guidelines in the context of generic business intelligence goals, principles, and architecture. Principles of Data Warehousing Data Retention: Data warehouses exist to serve as the “information memory” of an enterprise. Data warehouses record all the critical business transactions conducted by an enterprise, so decision makers and business strategists can leverage the information to meet their goals and objectives. The Value of Historical Information: The business intelligence team must ensure that information captured in the data warehouse supports both the current, known requirements for analyses, but also supports the future, unknown requirements. Low level, historical transaction data captures information about past behavior of the enterprise that no other source of information provides. When we delete this data, we eliminate forever the ability o...
Comments
Post a Comment