Blog Archives

Replicate Specific Data Source in BI/BW

Login to the BI/BW System Use TCode: RSDS Enter Datasource and Source System   Press <Ctrl+Shift+F2> or follow as below   Replication successful message as below

Posted in SAP, SAP BI

Create COPA Data source

Use TCode: KEB0 Enter CO-PA Data Source name Set value as below and Press “Execute” button   To reset all selected fields by default type “=init” and press <Enter>   Below screen shot after reset   Based on requirement select

Posted in ECC 6, SAP, SAP BI

Process Chain: Load data to cube ZFIGL_C10

Use TCode “RSPC”   Or you can go by using TCode “RSA1”. Process Chains available under “Administration”   Create New Process Chain   Create New Process Variants   To schedule process chain click “Change Selection”   To run process chain

Posted in SAP, SAP BI

Create Webi Report based on 0FIGL_C10 Cube and Universe

Follow my post “Load Data to Cube 0FIGL_C10” using link http://wp.me/p2oyUE-pE Follow my post “Create Universe using Universe Design Tool for Cube 0FIGL_C10” using link http://wp.me/p2oyUE-pS Start Web Intelligence Rich Client Select Universe Select fields from universe Execute Query. Output

Posted in SAP, SAP BI

Create Universe using Universe Design Tool for Cube 0FIGL_C10

Follow my post “Load Data to Cube 0FIGL_C10” using link http://wp.me/p2oyUE-pE Enter Universe name & Click “New” Define new connection Select Data Access driver. In my case I selected “SAP Client” Define login parameters to access database Search your cube

Posted in SAP, SAP BI

Load Data to Cube 0FIGL_C10

Follow common steps from my old post “Load Data to cube 0SD_C05” by using link http://wp.me/p2oyUE-nZ Now login to BI System. Use TCODE: RSA1 to reach Data Warehousing Workbench: Modeling Tab Unser Data Sources search “0FI_GL_10” Found “0FI_GL_10” as below

Posted in SAP, SAP BI

Performance Tuning of SAP BI CUBE:

OLAP CACHE Use TCODE: RSRT Search for Query. New Window will open, Click on “Favorites” Select Query and Click “OK” Click on “Properties” Make sure Cache Mode enable. Also, based on requirement choose setting from 1 to 4. BI ACCELERATOR

Posted in SAP, SAP BI