SAP BW Important Interview Questions Paper

[vedha.v]

SAP BW Important Interview Questions Paper

Q) Does data packets exits even if you don't enter the master data, (when  created)?


Q) When are Dimension ID's created?

A) When Transaction data is loaded into InfoCube.


Q) When are SID's generated?

A) When Master data loaded into Master Tables (Attr, Text, Hierarchies).


Q) How would we delete the data in ODS?

A) By request IDs, Selective deletion & change log entry deletion.


Q) How would we delete the data in change log table of ODS?

A) Context menu of ODS â ' Manage â ' Environment â ' change log entries.


Q) What are the extra fields does PSA contain?

A) (4) Record id, Data packet


Q) Partitioning possible for ODS?

A) No, It's possible only for Cube.


Q) Why partitioning?

A) For performance tuning.


Q) Have you ever tried to load data from 2 InfoPackages into one cube?

A) Yes.


Q) Different types of Attributes?

A) Navigational attribute, Display attributes, Time dependent attributes,  Compounding attributes, Transitive attributes, Currency attributes.


Q) Transitive Attributes?

A) Navigational attributes having nav attrthese nav attrs are called transitive  attrs


Q) Navigational attribute?

A) Are used for drill down reporting (RRI).


Q) Display attributes?

A) You can show DISPLAY attributes in a report, which are used only for  displaying.


Q) How does u recognize an attribute whether it is a display attribute or  not?

A) In Edit characteristics of char, on general tab checked as attribute only.


Q) Compounding attribute?

A)?


Q) Time dependent attributes?

A)?


Q) Currency attributes?

A)?


Q) Authorization relevant object. Why authorization needed?

A)?


Q) How do we convert Master data InfoObject to a Data target?
A) InfoArea â ' Infoprovider (context menu) â ' Insert characteristic Data  as DataTarget.


Q) How do we load the data if a FlatFile consists of both Master and  Transaction data?

A) Using Flexible update method while creating InfoSource.


Q) Steps in LIS are Extraction?

A)?


Q) Steps in LO are Extraction?

A) * Maintain extract structures. (R/3)

* Maintain DataSources. (R/3)

* Replicate DataSource in BW.

* Assign InfoSources.

* Maintain communication structures/transfer rules.

* Maintain InfoCubes & Update rules.

* Activate extract structures. (R/3)

* Delete setup tables/setup extraction. (R/3)

* InfoPackage for the Delta initialization.

* Set-up periodic V3 update. (R/3)

* InfoPackage for Delta uploads.


Q) Steps in FlatFile Extraction?

A)?


Q) Different types in LO's?

A) Direct Delta, Queued Delta, Serialized V3 update, Unserialized V3 Update.

Direct Delta: - With every document posted in R/3, the extraction data is  transferred directly into the BW delta queue. Each document posting with delta  extraction becomes exactly one LUW in the corresponding Delta queue.


Queued Delta: - The extraction data from the application is collected in  extraction queue instead of as update data and can be transferred to the BW  delta queue by an update collection run, as in the V3 update.



Q) What does LO Cockpit contain?

A) * Maintaining Extract structure.

* Maintaining DataSources.

* Activating Updates.

* Controlling Updates.


Q) RSA6 --- Maintain DataSources.


Q) RSA7 ---- Delta Queue (allows you to monitor the current status of the  delta attribute)


Q) RSA3 ---- Extract checker.


Q) LBW0 --- TCode for LIS.


Q) LBWG --- Delete set-up tables in LO's.


Q) OLI*BW --- Fill Set-up tables.


Q) LBWE ---- TCode for Logistics extractors.


Q) RSO2 --- Maintaining Generic DataSources.


Q) MC21 ----- Creating user-defined Information Structure for LIS (It is  InfoSource in SAP BW).


Q) MC24 ---- Creating Updating rules for LO's.


Q) PFCG ---- Role maintenance, assign users to these roles.


Q) SE03 -- Changeability of the BW namespace.


Q) RSDCUBEM --- For Delete, Change or Delete the InfoCube.


Q) RSD5 -- Data packet characteristics maint.

Q) RSDBC - DB  Connect


Q) RSMO --- Monitoring of Dataloads.


Q) RSCUSTV6 -- Partitioning of PSA.


Q) RSRT -- Query monitor.


Q) RSRV - Analysis and Repair of BW Objects


Q) RRMX - BEx Analyzer


Q) RSBBS - Report to Report interface (RRI).


Q) SPRO -- IMG (To make configurations in BW).


Q) RSDDV - Maintaining Aggregates.


Q) RSKC -- Character permit checker.


Q) ST22 - Checking ShortDump.


Q) SM37 - Scheduling Background jobs.


Q) RSBOH1 -- Open Hub Service: Create InfoSpoke.


Q) RSMONMESS -- "Messages for the monitor" table.


Q) ROOSOURCE - Table to find out delta update methods.


Q) RODELTAM - Finding for modes of records (i.e. before image & after  image)

Q) SMOD - Definition

Q) CMOD - Project Management enhancing

Q) SPAU - Program Compare

Q) SE11 - ABAP Dictionary

Q) SE09 - Transport Organizer (workbench organizer)

Q) SE10 - Transport Organizer (Extended View)

Q) SBIW - Implementation guide


Q) Statistical Update?

A) ?


Q) What are Process Chains?

A) TCode is RSPC, is a sequence of processes scheduled in the background &  waiting to be triggered by a specific event. Process chains nothing but grouping  processes. Process variant (start variant) is the place the process chain knows  where to start.

There should be min and max one start variant in each process chain, here we  specify when should the process chain start by giving date and time or if you  want to start immediately

Some of theses processes trigger an event of their own that in-turn triggers  other processes.


Ex: - Start chain â ' Delete BCube indexes â ' Load data from the source  system to PSA â '     

Load data from PSA to DataTarget ODS â ' Load data from ODS to BCube â ' Create  Indexes for BCube after loading data â ' Create database statistics â ' Roll-Up  data into the aggregate â ' Restart chain from beginning.


Q) What are Process Types & Process variant?

A) Process types are General services, Load Process & subsequent processing,  Data Target Administration, Reporting agent & Other BW services.


Process variant (start variant) is the place the process type knows when & where  to start.



Q) Difference between MasterData & Transaction InfoPackage?

A) 5 tabs in Masterdata & 6 tabs in Transaction data, the extra tab in  Transaction data is DATA TARGETS.


Q) Types of Updates?

A) Full Update, Init Delta Update & Delta Update.


Q) For Full update possible while loading data from R/3?

A) InfoPackage â ' Scheduler â ' Repair Request flag (check).

This is only possible when we use MM & SD modules.


Q) Why it takes more time while loading the transaction data even to load the  transaction without master data (we check the checkbox, Always Update data, even  if no master data exits for the data)?

A) Because while loading the data it has to create SID keys for transaction data
   Previous Page |  First Page