Data Modelling Flashcards
What does a SAP BW Data Flow look like?
Source -> Via InfoPackage -> To PSA -> Via DTP -> To InfoProvider
What is the transaction code fro the Data Warehouseing Workbench Tool?
RSA1
What types of InfoObjects is there? (5)
Key Figures (Quantity, Amount) Characteristics (CostCenter) Time Characteristics (Calendar Day) Units (Currency, unit) Technical (Request ID, Change ID)
What is the difference between Navigational attributes and display attributes?
Navigational can be used to drill during reporting, where display can only be shown.
What is the PSA?
Persistent Staging Area, is for temporary storage of data from a data source, for further transformation.
What element is needed to transfer data from an SAP source system to the PSA?
An InfoPackage
What element is needed to transfer data from PSA to an InfoProvider?
A Data Transfer Process (DTP package)
What is the name of the transaction to create extractors in an SAP source system?
SBIW
What type of physical InfoProvider targets exists?
InfoCube, Master Data and DSO (And now aDSO)
What type of logical InfoProviders exists?
MultiProvider, InfoSet, VirtualProvider (And now Composite provider)
How many tables does a standard DSO have?
3, Active data, Change log & Activation queue
What are write optimized DSOs?
A DSO that is optimal for temporary storage of larger amounts of data, if one is using a complicated transformation.
What is a direct update DSO?
A DSO that has where data is available fast, as data is written directly to the active table, so no activation is needed. It also allows for several users updating at the same time.
What is an InfoSet?
A semantic view for InfoProviders, that can use Inner, Outer and AntiJoins.
What is a Semantic Partitioned Object (SPO)?
A type of InfoProvider similar to a MultiProvider, but able to partition transactional data into different InfoProviders. E.g. Based on time, orgatinzation etc.
