Posts

Showing posts from June, 2011

Exchange Rates / Unit of Measures in SAP BW

Image
If you got this type of error: If i go through No SID found for value 'LOT' of characteristic 0BASE_UOM Message no. BRAIN070 Diagnosis: Characteristic value LOT does not exist in the master data table of characteristic 0BASE_UOM. Therefore, this value could not be transformed into the internal SID. Procedure: Check whether the value is correct or not. If it is correct, you need to generate the associated master data. Note: For characteristics 0FISCPER and 0FISCYEAR, there must be a corresponding fiscal year variant (see table T009). In addition, there must be units in table T006 and currencies in the table TCURC. This occurs during data extraction from ECC via this Datasource:0FI_GL_4 Line Items. Check whether the Unit of Measure exist in the Source System (R/3 or ECC). If it exists, entries in T006 - Units of Measurement table in both ECC and BW Side. If the UOM exists in Source system, doesn't exist in BW, have to bring them using Source system Transfer

Variables in SAP BW/BI Reporting

Image
SAP BW Variables Types and Processing types Matrix: ---------------------------------------------------------------------------------------------- We can check the data provider in the object i_infoprov in debug in RSRT t.code. Check the Code snippet. IF i_infoprov IS INITIAL AND cl_rsroa_vq_services=>is_iobj_virtual( i_iobjnm ) = rs_c_true. i_infoprov = cl_rsroa_vq_services=>get_infoprov_from_iobjnm( i_iobjnm ). ENDIF. ---------------------------------------------------------------------------------------------- YTD from Input Date DATA : l_s_range  TYPE  rsr_s_rangesid,       loc_var_range  type  rrrangeexit. DATA : LV_YEAR( 4 )  TYPE  N. CASE  i_vnam. WHEN   'ZYTD_DATE' .      IF  I_STEP =  2 .        LOOP   AT  I_T_VAR_RANGE  INTO                 LOC_VAR_RANGE  WHERE  VNAM =  'ZPP_INP' .         L_S_RANGE-HIGH = LOC_VAR_RANGE-LOW.          CLEAR  ZDAY.          CLEAR  ZMON.          CLEAR  ZYEAR

Queries - Workbook(s) deletion at SAP NW BW

I am on BW3.5. Indeed RSZDELETE removes:   1) a query for me, even if the query does exists in Workbook (btw I do not get any warning from the transaction!).   2) The reference from Workbook to the Query. But Workbook itself is not deleted, which is not a big problem, because I can delete Workbook with function module RRMX_WORKBOOKS_DELETE. When you run transaction RSZDELETE to delete the queries, and it will also prompt if you want to delete any associated workbooks, etc. Answer "Yes" and they will be deleted also (including favorites). Also, if you have deleted queries in the past without deleting the workbooks, you can run program RRMX_WORKBOOKS_GARBAGE_COLLECT to find and/or delete these "orphaned" workbooks.

SAP BW Reporting Variables:Customer Exit

Examples: Customer Variable Exit Documentation With this enhancement to global variables in reporting you have the option of determining your default values for variables. You can use this enhancement for variables, for which 'Processing by Customer-Exit' has been selected in the variable maintenance. This is valid for all variable types (characteristic value, node, hierarchy, formula and text variables). You use the Exit EXIT_SAPLRRS0_001 for this. You could, for example, establish the default value of a characteristic value variable depending on the user. Depending on the variable type, the fields LOW, HIGH, SIGN and OPT of the internal table E_T_RANGE must be filled as follows: LOW Single value or lower interval limit (characteristic variable) Text (Text variable) Formula value (Formula variable) Hierarchy name (Hierarchy variable) Hierarchy node (Hierarchy node variable) HIGH Upper interval limit (char. variable with interval) I