Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
55 Cards in this Set
- Front
- Back
|
What does the SAP business warehouse allow?
|
The analyzation of data from operational SAP R/3 applications or any other business application as well as extract and analyze data from external sources such as databases, online services, and the internet.
|
|
|
What did the realization of SAP BW aim for?
|
1. Data warehousing system with data structures for reporting and analysis
2. Separate system 3. OLAP engine tools 4. Comprehensive data warehousing architectural base 5.Automated data ware house management 6. Pre-configuration using SAP business know how |
|
|
What is the SAP Business Information Warehouse?
|
A separate server with its own database and SAP system.
|
|
|
What is the clear advantage of SAP BW?
|
The customer is able to use the entire SAP know-how built up over the many years of experience in developing business software solutions.
|
|
|
What can SAP R/3 systems be configured as to provide data for all SAP business content?
|
Source systems.
|
|
|
What are business analysis-objects and what are they called in SAP?
|
The are companies, sales volumes and so on and are called InfoObjects.
|
|
|
How can InfoObjects be divided into?
|
Into characteristics and key figures.
|
|
|
How can characteristics be further divided?
|
Units, time characteristics, and technical characteristics.
|
|
|
What are infocubes?
|
The central data containers that form the basis for reports and analysis in SAP BW.
|
|
|
What do infocubes contain?
|
Key figures and a link to the characteristics
|
|
|
What are key figures and characteristics?
|
InfoObjects
|
|
|
What does master data in the BW system consist of?
|
Attributes of a characteristic as well as hierarchies and texts of a characteristic.
|
|
|
What is a characteristic of a characteristic?
|
An attribute.
|
|
|
What is a data record?
|
A posting record that is a combination of characteristics and key figures.
|
|
|
What does an infocube consist of?
|
Several database tables that are linked according to the star schema.
|
|
|
What does an infocube include?
|
A fact table that contains the infocube key figures as well as several surrounding dimension tables that store teh links to the characteristics.
|
|
|
How can we describe a characteristic?
|
Attributes, texts and hierarchies
|
|
|
Each InfoCube has how many fact and dimension tables?
|
1 fact table and 16 dimensions
|
|
|
Is an InfoCube an InfoProvider?
|
Yes.
|
|
|
What is metaobjects?
|
Data about objects
|
|
|
What is the maximum number of key figures each table can contain?
|
233.
|
|
|
How many freely available characteristics can a dimension contain?
|
248.
|
|
|
How do you store an InfoCube?
|
You create a new folder or use an existing one.
|
|
|
What are the folders called where you can store data in an InfoCube?
|
InfoAreas.
|
|
|
What is an InfoProvider?
|
An InfoCube that is an object you can use to create reports in the Business Explorer (BeX).
|
|
|
What are the two types of data stores?
|
Physical stores and logical views
|
|
|
What do physical stores include?
|
1. BasicCubes
2. ODS Objects 3. InfoObjects |
|
|
What are the logical views of physical data stores?
|
1. Infosets
2. Remotecubes 3. Virtualinfocubes 4. Multi-providers |
|
|
What is an operational data store and what is it used for?
|
Stores data at the basic level and is used to resolve and consolidate data sets.
|
|
|
What is an administrator workbench and what is it used for?
|
It is a workplace for SAP BW administrators and is used to configure, control, and administrate SAP BW.
|
|
|
What does the SAP business information warehouse enable?
|
The analysis of data from operative SAP applications as well as other business applications and external data sources such as databases, online services, and the internet.
|
|
|
What does SAP BW enable OLAP for?
|
Staging information from large amounts of operative and historical data.
|
|
|
What does the BW server allow?
|
Allows you to examine the relationships in every area within your company and is pre-configured by business content.
|
|
|
What is the business explorer?
|
The SAP BW component that provides flexible reporting and analysis tools that you can use for strategic analysis and supporting the decision making process in your company.
|
|
|
How can a wide spectrum of users access information in SAP BW using the business explorer?
|
In enterprise portal from an iView that you can call alongside the applications where you extract the data, in the internet or intranet, or using a mobile device.
|
|
|
How are highly individual scenarios with customer-defined user interface elements realized in business explorer?
|
Using standard mark-up languages (HTML).
|
|
|
What does portal integration include?
|
1. Single point of entry
2. Role-based staging of information 3. Personalization 4. Publication of iViews 5. Integration of unstructured data |
|
|
What does query, reporting and analysis include?
|
1. Query design using the business explorer analyzer
2. Multi-dimensional OLAP analysis 3. Geographical analysis 4. Ad hoc reporting 5. Alerts |
|
|
What does web application design include?
|
1. Interactive analytical content
2. Information cockpits and dashboards 3. Basis for creating analytical applications 4. Creation of iViews for a portal 5. Wizard-help |
|
|
In SAP BW reporting functions, you can evaluate a data set by doing what?
|
Defining a query for your chosen info provider in the BeX query designer.
|
|
|
What happens when you select and combine the InfoObjects in a query?
|
You determine the way in which data from the chosen infoprovider is evaluated.
|
|
|
What are the various options for calling up the query designer?
|
BeX analyzer
Web application designer Crystal reports |
|
|
What are your options for querying the InfoObjects?
|
Create a new query or find and select an existing query.
|
|
|
What are the six areas the query designer is divided into?
|
1. Directory tree of the selected infoprovider
2. Columns 3. Rows 4. Free characteristics 5. Filter 6. Preview |
|
|
What are free characteristics?
|
Those characteristics that do not display in the initial view of the results when you execute the query in the analyzer or on the web.
|
|
|
Does the characteristics in the filter appear in the drill-down or as free characteristics in the query analysis?
|
No.
|
|
|
How can you move the selected objects of the infoprovider tree into the appropriate subarea?
|
Through drag and drop or keyboard short keys.
|
|
|
In what areas can you restrict (filter) the characteristic values of a characteristic?
|
Rows
Columns Free characteristics Filter |
|
|
What are the ways of restricting characteristics?
|
1. By selecting a characteristic from the infoprovider of the characteristic and double clicking on the values icon, the selection menu for fixed values displays
2. restricted a characteristic that you have already included in the definition by calling the context menu for the characteristic and choosing restrict. 2. |
|
|
How can you find specific characteristic values by entering their description or technical name?
|
By using the input field in the lower left area of the selection dialog box.
|
|
|
What are text elements in the BeX analyzer used for and what are referred to as?
|
As additional information in a query and they are referred to as the header information of the query.
|
|
|
How can you move or delete individual text elements?
|
By moving or deleting the corresponding cells using Microsoft Excel menu functions.
|
|
|
For multi-providers, how are the current infopackages determined and what date is referred to for the status of the data?
|
They are determined from the individual basic cubes and from there the one with the oldest date is referred to.
|
|
|
What are all the possible text elements?
|
1. Author
2. Last changed by 3. Infoprovider 4. Query technical name 5. Key date 6. Changed at 7. Status of data 8. Current user 9. Last refreshed 10. Variables, filter values, conditions, exceptions |
|
|
What does the key date text element contain?
|
The date for which the time-dependent master data is selected.
|
