SAP BI – Remodeling/Repartioning/ReClustering

Before the release SAP BI 7.0 in the previous version 3.x; we were not able to Re-Partition, Re-Model, Re-Cluster if the data is already loaded.  We had to delete all the data and load it again. But with this 7.0 release; we do not have to delete the data to Remodel/RePartion/ReCluster

Remodeling is a new feature: if you want to add or delete field(attribute)
Implementation for Remodeling
1. Right Click the particular INfoCube | Additional Functions | Select Remodeling.
2. Give a Remodeling Rule Name | Transfer
3. To add and Attribute | Click Add an Operation to the List
4.  You will get all the options for ReModeling and Existing InfoCube

SAP BI – Physical Partitioning

Usage Example:  If you want to further partition the InfoCube on Database level; for example if you want to further partition YEAR InfoObject into Month like Jan, Feb, March, etc.  that time you use Physical Partitioning

Implementation Steps

GoTo RSA1
Extras | DB Performance | Click Partitioning

SAP Cube Contant – Logical Partitioning

Cube constant improves query performance while reporting.  For example a Cube has a large amount of data and we have requirement to create a report only on Fiscal Year 2008; then we can create a Cube constant for this particular year so that when query is executed; it will not search each and every data in the cube but just the Cube Constant

Steps to Implement Cube Constant

Open an InfoCube in Edit mode which has data in it.
Right Click on Dimension and select “Providers-Specific InfoObject Properties”
You can specific Fiscal Year = 2008 in the Constant Column
Save

If you want to create Cube Constant for 2008, 2009, 2010 then you will have to create 3 individual InfoCube with the Respective Cube Constant

PS: whatever restrictions made in the Cube Constant should also be made at InfoPackage Level at the time of loading the data

SAP BI Process Chains

A process Chain is a sequence of processes in BI system that executes in the Background.

Commonly Used Process Types

1.  Start
2.  Execute InfoPackage
3.  DTP
4.  Attribute Change Run
5.  Save Hierarchy
6.  Delete Index
7.  Generate Index
8.  Activate DSO data
9.  Update DSO data
10. Complete Deletion of Data Target Content
11. Delete Entire Content of Linked Transactional DSO/ODS
12. Initial Fill of New Aggregates
13. Roll up of Filled Aggregates/BIA indexes
14. Compression of InfoCubes
15. Read PSA and Update Data Target
16. AND
17. OR
18. XOR