Data Warehousing: Step by Step
To
build an Optimal Data Warehouse solution in SAP BI, the following steps are the
sequential process.
1. Data modeling
·
Creating InfoObjects:
Characteristics
·
Creating InfoObjects: Key
Figures
·
Creating DataStore objects
·
And/or creating InfoCubes
·
And/or creating InfoSets
·
And/or creating MultiProviders
·
Or creating VirtualProviders
2. Metadata and Document Management
·
Installing BI Content
·
Creating documents
3. Setting up the source system:
·
Creating SAP source systems
·
And/or creating external
systems
·
And/or creating file systems
4. Defining extraction:
·
For SAP source systems: Maintaining
DataSources
·
Or for a SOAP-based transfer of
data: Creating XML DataSources
·
Or for transferring data with
UD Connect: Creating a DataSource for UD Connect
·
Or for transferring data with
DB Connect: Creating a DataSource for DB Connect
·
Or for files: Creating
DataSources for File Source Systems
·
Or for transferring data from
non-SAP systems
·
Creating InfoPackages
5. Defining transformations:
·
Creating transformations
6. Defining data distribution:
·
Using the data mart interface
·
Creating open hub destinations
7. Defining the data flow:
·
Creating data transfer processes
·
Creating process chains
8. Scheduling and monitoring:
·
Checking process chain runs
·
Monitor for extraction
processes and data transfer processes
9. Performance optimization:
·
Creating the first aggregate
for an InfoCube
·
Or using the BIA index
maintenance wizard
10. Information lifecycle management:
·
Creating data archiving
processes
11. User management:
·
Setting up standard
authorizations
·
Defining analysis
authorizations
No comments:
Post a Comment