Soal Wawancara SAP BW

The primary purpose of SAP BI/BW in an organization is to gather, store, and analyze data, enabling data-driven decision-making. It serves as a central hub for consolidating and processing data from various sources, facilitating comprehensive reporting and analytics to support business operations and strategy.

The Open Hub Service enables us to distribute a data from an SAP BW system into an external Data Marts, analytical applications, and other applications. And can ensure a controlled distribution using several systems. The central object for an exporting data is InfoSpoke. can define a source and the target object for the data. BW becomes hub of an enterprise data warehouse. The distribution of a data becomes clear through the central monitoring from distribution status in the BW system.

Yes, when you want to report on charactertics or master data, you can make them as InfoProvider.

There are two main types of attributes in SAP BW on HANA: key attributes and navigational attributes. Key attributes are essential for uniquely identifying master data, while navigational attributes provide additional details that help in navigating and analyzing data within the system.

Info Objects are known as smallest unit in SAP BI and are used in Info Providers, DSO’s, Multi providers, etc. Each Info Provider contains multiple Info Objects. InfoObjects are used in reports to analyze the data stored and to provide information to decision makers.

In SAP BW on HANA, DIM ID refers to the Dimension ID, a unique identifier assigned to each dimension table. DIM IDs are crucial for maintaining data consistency and integrity within the data warehouse, enabling  retrieval of dimension attributes.

Fact table is the collection if facts and relations that means a foreign keys with the dimension. Actually fact table holds the transactional data.

SAP BW on HANA is an integration of SAP’s Business Warehouse (BW) software with the HANA in-memory database. It varies from traditional SAP BW by leveraging HANA’s high-speed processing capabilities, enabling faster data retrieval and analysis. This integration enhances the overall performance, accelerates data processing, and supports real-time analytics.

An InfoPackage is used to specify how and when to load data to BI system from different data sources. An InfoPackage contains all the information how data is loaded from source system to a data source or PSA. InfoPackage consists of condition for requesting data from a source system. Note that using an InfoPackage in BW 3.5, you can load data in Persistence Staging Area and also in targets from source system but If you are using SAP BI 7.0 data load should be restricted to PSA only for latest versions.

InfoObjects are created in Info Object catalog. It is possible that an Info Object can be assigned to different Info Catalog.

InfoCube is a multidimensional dataset that is utilized in a BEx query for analysis. A group of relational tables that are logically connected to implement a star schema make up an InfoCube. The numerous dimension tables are coupled with a Fact table in a star schema.

InfoProviders: Core data storage and modeling. DataSources: Data extraction from source systems. DTP (Data Transfer Process): Data loading and transformation. BEx (Business Explorer): Reporting and analysis tool. Metadata Repository: Data definition storage.

Info Area in SAP BI are used to group similar types of object together. Info Area are used to manage Info Cubes and Info Objects. Each Info Objects resides in an Info Area and you can define it a folder which is used to hold similar files together.

SAP systems (SAP Applications/SAP ECC) A Relational Database (Oracle, SQL Server, etc.) Flat File (Excel, Notepad) A Multidimensional Source systems (Universe using UDI connector) Web Services that transfer a data to BI by means of push

Info Objects can be categorized into below categories - Characteristics like Customer, Product, etc. Units like Quantity sold, currency, etc. Key Figures like Total Revenue, Profit, etc. Time characteristics like Year, quarter, etc.

BW/4HANA is a data warehousing solution from SAP. It is designed to help organizations manage and analyze large amounts of data. BW/4HANA includes a number of features that make it well-suited for data-intensive businesses, such as support for real-time data analysis, data compression, and a columnar database.

A star schema is a type of data warehouse schema used for organizing data. It features a central fact table containing quantitative data and multiple dimension tables that provide context. This design simplifies queries, enhances performance, and is commonly used in business intelligence for efficient reporting and analysis.

In SAP BW on HANA, a source system is a system from which data is extracted and loaded into the data warehouse. Source systems can include various databases, ERP systems, or external systems that contribute data for analysis and reporting within the SAP BW on HANA environment.

The 3 SAP defined dimensions are: Data packet dimension (P): It contains the 3characteristics.a) request Id (b) Record type (c) Change run id. Time dimension (T): It contains a time characteristics such as 0calmonth, 0calday etc. Unit Dimension (U): It contains the basically amount and quantity related units.

ODS - They provide granular data, allows overwrite and data is in transparent tables, ideal for drilldown and RRI. InfoCube - This is used for star schema, we can only append data, ideal for primary reporting. MultiProvider - It contains a physical data and allow to access data from different InfoProviders.