Valeo SAP BW Hana Consultant Interview Questions and Answers

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

• Full extraction - extracts all data from source system

• Delta extraction - extracts only new or changed data since last extraction

• Initialization - initial extraction of data from source system

• Generic extraction - allows extraction of data from any table in source system

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 re...read more

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