How to model “age” base on the specific requirement;

The difference between time-dependent and time-independent/navigation and display attributes, how to model in some specific scenarios;

Dimention modeling base on some specific scenarios and under what situation you have to use “line item”;

Track history scenario and key date;

MultiProvider’s source;

In reporting, extraction and warehouse management, many test questions related to data modeling concept if the question very concern about performance;

Variable and processing type;

Restricted key figure;

Calculated key figure;

Exception and condition; how to use them in run time;

Navigation of query result include filt, delete result and so on.

RRI and view as jump target;

Web Item. Data Privider(what component can put in DataProvider);

Stylesheet

Transfer structure;Infosource and communication structure

Transfer rule and update rule;

The relationship between data target and structures or rules

ODS and InfoCube management(Aggregate and Compression),many test here

Structure of ODS etc.

Data mart architecture

The characters of XML loading

Flat file;

Record mode;

Delta method;

LO and LIS;

The relationship between Basis authorization and BW authorization;

Autherization object;

Autherization value(“:”,”$” etc.);

Workbook authorization;

Blueprint;

Project team;

The responsibility of various team member and the relationship between them;