jump to navigation

Activate DTP September 21, 2012

Posted by Ajay in Uncategorized.
Tags:
1 comment so far

Run Program RSBKDTPREPAIR

RSDG_TRFN_ACTIVATE

RSDG_CUBE_ACTIVATE     Activation of InfoCubes

RSDG_ODSO_ACTIVATE     Activation of all ODS Objects

RSDG_IOBJ_ACTIVATE     Activation of all InfoObjects

RSDG_MPRO_ACTIVATE     Activating Multiproviders

RS_COMSTRU_ACTIVATE_ALL     Activate all inactive Communication Structures

RS_TRANSTRU_ACTIVATE_ALL     Activate Transfer Structure

RSAU_UPDR_REACTIVATE_ALL     Activate Update Rules

RRHI_HIERARCHY_ACTIVATE     Activate Hierarchies

SAP_AGGREGATES_ACTIVATE_FILL     Activating and Filling the Aggregates of an InfoCube

RS_PERS_ACTIVATE     Activating Personalization in Bex(Inactive are highlighted)

RSDDS_AGGREGATES_MAINTAIN — attribute change run

RSSM_SET_REPAIR_FULL_REQUEST — changes full update to repair fulll request

RSTRSNSTRU_ACTIVATE_ALL– activating transfer structure

RSPC_PROCESS_FINISH — process chain details

RSDG_IOBJ_REORG Repair InfoObjects

RSDG_IOBJ_REORG_TEXTS Reorganization of Texts for InfoObjects

RSDG_MPRO_ACTIVATE Activating Multiproviders

RSDG_MPRO_COPY Make Multiprovider Copies

RSDG_MPRO_DELETE Deleting Multiproviders

RS_COMSTRU_ACTIVATE_ALL Activate all inactive Communication Structures

RS_TRANSTRU_ACTIVATE_ALL Activate Transfer Structure

RSAU_UPDR_REACTIVATE_ALL Activate Update Rules

RRHI_HIERARCHY_ACTIVATE Activate Hierarchies

SAP_AGGREGATES_ACTIVATE_FILL Activating and Filling the Aggregates of an InfoCube

SAP_AGGREGATES_DEACTIVATE Deactivating the Aggregates of an InfoCube

RS_PERS_ACTIVATE Activating Personalization in Bex(Inactive are highlighted)

RSSM_SET_REPAIR_FULL_FLAG Convert Full Requests to Repair Full Requests

SAP_INFOCUBE_DESIGNS Print a List of Cubes in The System and Their Layouts

SAP_ANALYZE_ALL_INFOCUBES Create DB Statstics for all InfoCubes

SAP_CREATE_E_FACTTABLES Create Missing E-Fact Tables for InfoCubes and Aggregates

SAP_DROP_EMPTY_FPARTITIONS Locate/Remove Unused or Empty partitions of F-Fact Table

SAP_DROP_TMPTABLES Remove Temperory Database Objects

Function Modules within BW.

Function Module Description (Function Group RRMX)

RRMX_WORKBOOK_DELETE Delete BW Workbooks permanently from Roles & Favourites

RRMX_WORKBOOK_LIST_GET Get list of all Workbooks

RRMX_WORKBOOK_QUERIES_GET Get list of queries in a workbook

RRMX_QUERY_WHERE_USED_GET Lists where a query has been used

RRMX_JUMP_TARGET_GET Get list of all Jump Targets

RRMX_JUMP_TARGET_DELETE Delete Jump Targets

Function Module Description

MONI_TIME_CONVERT Used for Time Conversions.

CONVERT_TO_LOCAL_CURRENCY Convert Foreign Currency to Local Currecny.

CONVERT_TO_FOREIGN_CURRENCY Convert Local Currency to Foreign Currency.

TERM_TRANSLATE_TO_UPPER_CASE Used to convert all texts to UPPERCASE

UNIT_CONVERSION_SIMPLE Used to convert any unit to another unit. (Ref. table : T006)

TZ_GLOBAL_TO_LOCAL Used to convert timestamp to local time

FISCPER_FROM_CALMONTH_CALC Convert 0CALMONTH or 0CALDAY to Financial Year or Period

RSAX_BIW_GET_DATA_SIMPLE Generic Extraction via Function Module

RSAU_READ_MASTER_DATA Used in Data Transformations to read master data InfoObjects

( from scn : CSM Reddy)

Checklist for Developing BI Objects February 10, 2012

Posted by Ajay in SAP BW.
1 comment so far

 Checklist for Developing BI Objects

What you need to check…

Developing the data model:

  Is the data model clear, integrated and consistent?
  Have you structured your system in a data warehouse layer architecture? Have you adhered to the recommendations for data modeling?

Developing InfoObjects:

  Are you planning to develop new characteristics?

Characteristics should be reusable, where possible. If you just need a new description for an existing characteristic, create the new characteristic as a reference to the existing characteristic.

  Do you need a special key figure to count the occurrences of a characteristic?

Using time characteristics:

  If you are using 0CALDAY in an InfoProvider, you should also include the higher-level time characteristics in the InfoProvider (for example, 0CALWEEK, 0CALMONTH, 0CALQUARTER, 0CALYEAR).
  If you are using 0FISCVARNT and 0CALDAY in an InfoProvider, you should also include 0FISCPER and 0FISCYEAR.

Developing InfoSources:

  Do the InfoSources only contain InfoObjects that are technically relevant or relevant for analysis and reporting?

Developing InfoProviders:

  Are you using DataStore objects? You should use DataStore objects if you need the history or analysis of an individual record. InfoCubes, on the other hand, can be aggregated and therefore have better performance.
  Are you using InfoSets with time-dependent master data? In this case, you should not define queries with time intervals.
  Are you using MultiProviders? Make sure that all the characteristics you want to use in the query are contained in all the individual InfoProviders.

Defining the load process:

  Have you defined transformation rules so that master data can be read? With reverse postings for delta-enabled DataSources, note that master data should not be read in the transformation rule for an InfoCube. The system can only process reverse postings upon reading master data correctly in the transformation rules for a DataStore object.
  Are you using process chains? You should use process chains to perform each load and further processing process.

 

http://help.sap.com/saphelp_nw70/helpdata/en/72/2c14427765da2ce10000000a1550b0/frameset.htm

Attribute Change run February 7, 2012

Posted by Ajay in SAP BW.
add a comment

1. Goto SE37 –> Run RSDDS_AGGR_MOD_STATE_GET > If I_DIFF* value / has any entries, your Attribute Change run was not successful.

2. Check if there’s any entries. If so, goto SE37 > RSDDS_AGGR_MOD_CLOSE & clear collision

3 Goto SE38 > Run RSDDS_AGGREGATES_MAINTAIN > Give IOB name (CIO infoobject not Nav) > Run the change run.

Protected: SAP BW STEP BY STEP February 7, 2012

Posted by Ajay in SAP BW.
Enter your password to view comments.

This content is password protected. To view it please enter your password below:

Data type and length of field in DB system ORA have been changed January 27, 2012

Posted by Ajay in SAP BW.
add a comment

SAP BW error : Data type and length of field ‘XXXX’ in DB system ‘XXXXXXX ORA have been changed.

The ods is getting data from Oracle.

I found out that data type for the column has been changed in oracle from varchar2(120 byte) to varchar2(120 char).

change the column in Oracle : CAST(USER_filed AS VARCHAR2(120)) .

Now data load is successful.

Bex transport request is not available or not suitable. November 14, 2011

Posted by Ajay in SAP BW.
Tags:
add a comment

Refer to : http://forums.sdn.sap.com/thread.jspa?messageID=10021347#10021347

Refer to SAP Help: http://help.sap.com/saphelp_nw04s/helpdata/en/38/5ee7377a98c17fe10000009b38f842/frameset.htm

SAP BW – Transfer Rules missing in transport September 26, 2011

Posted by Ajay in Uncategorized.
add a comment

I’ve transported transfer rules and communication structure successfully but I cant see transfer rules in QA. Later I found that that Source System assignment for the DB connect was uncheked.

I’ve checked the assignment and was able to collect the :

Communication structure
DataSource Replica
Transfer Rules
InfoSource transaction data
Transfer structure
Routine
BW Formula

Steps:

Go To  Transport Connection –>Edit –>Source System Assignment –> check the source system you are connecting in Transfer Rules

Hurray you can transport the transfer rules now .

SAP BW Variables for Date Month September 26, 2011

Posted by Ajay in Uncategorized.
1 comment so far

To install go to BI Content–> Query Elements-> Variable

Characteristic Variable Description
0CALDAY 0CWD Current Workday (SAP Exit)
0CALDAY 0CYTCD Cumulated to Current Day (SAP Exit)
0CALDAY 0DAT Current Calendar Day (SAP Exit)
0CALDAY 0DAY_CUM Cumulation of all Values to Key Date (SAP-Exit)
0CALDAY 0LYTCLD Cumulated to Current Day of Previous Year
0CALDAY 0LYTCLD Previous Year Cumulated to Current Day (SAP Exit)
0CALDAY 0L_DATE Last Calendar Date
0CALDAY 0P_LY_R Comparative Period for Last Year
0CALDAY 0P_TY_R Period for Current Year up to Yesterday
0CALDAY 0S_KDATE Key Date Interval for Previous Year (SAP Exit)
0CALDAY 0S_KDAY Key Date Interval Current Year (SAP Exit)
0CALMONTH 0CMCMLY Current Month of Previous Year
0CALMONTH 0CMCQUAR Current Quarter
0CALMONTH 0CMCQULY Current Quarter in Previous Year
0CALMONTH 0CML12CM Last 12 Months Including Current Month
0CALMONTH 0CML12LM Last 12 Months Excluding the Current Month
0CALMONTH 0CML3CM Last 3 Months Including Current Month
0CALMONTH 0CML3LM Last 3 Months Excluding the Current Month
0CALMONTH 0CMLMLY Last Month of Previous Year
0CALMONTH 0CMLMON Last Month
0CALMONTH 0CMLYTCM Previous Year Cumulated to Current Month
0CALMONTH 0CMLYTLM Previous Year Cumulated to Last Month
0CALMONTH 0CMONTH Current Calendar Month
0CALMONTH 0CYTCM Cumulated to current month
0CALMONTH 0CYTLM Cumulated to last month
0CALMONTH 0I_CMY01 Current Year Cumulated to Current Month (SAP Exit
0CALMONTH 0LYM_CUM Cumulation of all Values to End of Previous Year
0CALQUARTER 0CQUART Current Quarter
0CALQUARTER 0P_PRQUA Previous Calendar Quarter (SAP Exit)
0CALWEEK 0CWEEK Current calendar week
0CALWEEK 0PREVWK Previous Week
0CALYEAR 0CYEAR Current calendar year
0CRM_EXPEND 0I_CMDEX Current Month
0CRM_EXPEND 0I_MP1EX Current Month + 1
0CRM_EXPEND 0I_MP2EX Current Month + 2
0CRM_EXPEND 0I_MP3EX Current Month + 3
0CRM_EXPEND 0I_MP4EX Current Month + 4
0CRM_EXPEND 0I_MP5EX Current Month + 5
0ORGUNIT 0ORGUNIT Organizational Unit for a Report User (Hierarchy node)
0TCTUSERNM 0TCTUSEE User in the Business Information Warehouse
1FORMULA 0F_ADAY Formula Variable for Current Calendar Day

 

 

 

Copy the DataSource again and then activate the transfer rules that belong to it. You have to activate the transfer rules in every case, even if they are still active after the DataSource has been copied. December 3, 2010

Posted by Ajay in Uncategorized.
1 comment so far

I got this error in SAP BW :

DataSource 8XYZ_ABC has to be replicated (time stamp, see long text)
Diagnosis – DataSource 8XYZ_ABC does not have the same status as the source system in the Business Information Warehouse.
The time stamp in the source system is 20.06.2010 12:05:03.
The time stamp in the BW system is 22.01.2009 13:29:35.
System Response – The load process has been terminated.
Procedure – Copy the DataSource again and then activate the transfer rules that belong to it. You have to activate the transfer rules in every case,even if they are still active after the DataSource has been copied.

Solution :

1 . Goto DataSource  8XYZ_ABC -> rigth clcick-> Replicate Metadata
2. SE38 –> RS_TRANSTRU_ACTIVATE_ALL –> Leave Source System : BLANK , InfoSource (* gen) :8XYZ_ABC –> EXECUTE
3.Set the QM status to RED, delete the request and repeat the DATA LOAD.

DataSource 8SR_ORANK has to be replicated (time stamp, see long text)                                                                                                                                                                                          Diagnosis                                                                                                                                                                                                                                                      DataSource 8SR_ORANK does not have the same status as the source system                                                                                                                                                                                        in the Business Information Warehouse.                                                                                                                                                                                                                         The time stamp in the source system is 20.06.2010 12:05:03.                                                                                                                                                                                                    The time stamp in the BW system is 22.01.2009 13:29:35.                                                                                                                                                                                                        System Response                                                                                                                                                                                                                                                The load process has been terminated.                                                                                                                                                                                                                          Procedure                                                                                                                                                                                                                                                      Copy the DataSource again and then activate the transfer rules that                                                                                                                                                                                            belong to it. You have to activate the transfer rules in every case,                                                                                                                                                                                           even if they are still active after the DataSource has been copied.

Good Tutorials March 4, 2010

Posted by Ajay in Uncategorized.
add a comment

Sorting a table column in a WebDynpro application