SAP BW Hana Consultant

SAP BW Hana Consultant Interview Questions and Answers

Updated 21 May 2024

Popular Companies

Q1. Explain difference between LSA AND LSA++ architecture

Ans.

LSA focuses on layering data for efficient reporting, while LSA++ adds additional layers for better performance and flexibility.

LSA (Layered Scalable Architecture) focuses on layering data into Persistent Staging Area (PSA), Data Store (DS), and InfoCube for efficient reporting.
LSA++ adds additional layers like Data Mart Layer and Virtualization Layer for better performance and flexibility.
LSA++ allows for real-time reporting and faster data access compared to LSA.
LSA++ enabl...read more

Ans.

LO Extraction in SAP BW involves different methods to extract data from source systems into BW system.

Ans.

Variables in Bex query allow users to input values at runtime to filter data dynamically.

Variables can be used to restrict data based on user input
They can be defined as mandatory or optional
Different types of variables include characteristic, hierarchy node, formula, text, and user entry
Example: Creating a variable for fiscal year to allow users to select a specific year

Ans.

Snapshot option in ADSO allows creating a copy of data at a specific point in time.

Snapshot option is available in Advanced DataStore Objects (ADSO) in SAP BW Hana.
It allows creating a copy of data at a specific point in time.
Snapshots can be used for reporting purposes or for comparing data at different points in time.
Snapshots can be created manually or scheduled to run automatically.
Snapshots can be deleted or restored if needed.

Are these interview questions helpful?

Ans.

Customer exit variable is a user-defined variable in SAP BW that allows for custom logic and calculations.

Customer exit variables are used to enhance standard functionality by allowing users to define their own logic.
They can be used in queries to filter data based on custom requirements.
Examples of customer exit variables include variables that calculate year-to-date values or variables that apply specific business rules.
Customer exit variables are created and maintained in ...read more

Ans.

CKF is used in SAP BW to calculate key figures, while Formula is used to perform calculations on key figures.

CKF is used to define key figures in SAP BW, while Formula is used to perform calculations on existing key figures.
CKF is created using the CKF editor in SAP BW, while Formula is created using the Formula editor.
CKF can be used to perform simple calculations like addition or subtraction, while Formula can be used for more complex calculations involving multiple key fig...read more

Share interview questions and help millions of jobseekers 🌟

Ans.

Enhancements in SAP BW include improved data modeling, enhanced reporting capabilities, and integration with SAP HANA.

Improved data modeling capabilities with advanced features like CompositeProviders and Open ODS Views
Enhanced reporting capabilities with features like Analysis for Office and SAP Lumira
Integration with SAP HANA for faster data processing and real-time analytics
Introduction of SAP BW/4HANA for a simplified data warehouse solution

Ans.

Routines in SAP BW are used to enhance data transformations and calculations.

Routines can be used in transformations to perform complex calculations or data manipulations.
There are three types of routines in SAP BW: Start Routine, End Routine, and Expert Routine.
Routines can be written in ABAP or SQLScript depending on the requirement.
Examples of routines include currency conversion, data validation, and data enrichment.