I have learned BI for half a year. As a beginner, I read a book "SAP BW: A Step-by-Step Guide" by Biao Fu, Henry Fu.But in this book, I found the version is very old because I am using ECC 6.0, it's difficult for beginners to do a practice according that. Many things are not easy to find. I want to share it so as to make it more clear for beginners to follow in ECC6.0.
Chapter 1. Business Scenario
- Monitoring and forecasting sales demands and pricing trends
- Managing sales objectives and coordinating the sales force and distributors
- Reviewing the sales activities of each representative, office, and region
1.2 Data preparation(using excel sheet)
1.3 Star Schema
Chapter 2. Creating an InfoCube
| 2.1 Creating an InfoArea
InfoAreas are the branches and nodes of a tree structure.
run transaction RSA1
click Info object under Modelling in the left panel. In the right panel, right-click InfoObjects and select Create InfoArea.
2.2 Creating InfoObject Catalogs
Because characteristics and key figures are different types of objects, we organize them within their own separate folders, which are called InfoObject Catalogs.
Click InfoObjects under Modelling in the left panel. In the right panel, right-click InfoArea you created, and select Create InfoObject catalog....
choose char radiio button that the catalog contains characteristic, then create it.
In the new window, activate the InfoObject Catalog.
The same for creating another catalog contained key figure, only difference is to choose the key figure radio button.
2.3 Creating InfoObjects---Characteristics
Right-click InfoObject Catalog creating for characteristics, and then select Create InfoObject....
tips: all the characteristics are in the following figure and fill the value according to it.
2.4 Creating InfoObjects---Key Figures
Right-click InfoObject Catalog created for key figures, and then select Create InfoObject...
tips: all the key figures are in the below and fill them according to it.
2.5 Creating an InfoCube
Select info provider under Modelling in the left panel. In the right panel, right-click InfoArea you created and then select Create InfoCube....
After that, go through it and to direct input the dimension,
Then at Time dimension, put the following info object,
At last, in key figures.right click to info object direct input and then fill the following info object,
after finishing, you can see
activate it and then the infocube is created.
Later, I will write an article about loading data to this infocube.