Placement Papers: SAP BW Important Interview Questions Paper Part 4Tab.Amp

Examrace Placement Series prepares you for the toughest placement exams to top companies.

Question: I would like to display the date the data was uploaded on the report. Usually, we load the transactional data nightly. Is there any easy way to include this information on the report for users? So that they know the validity of the report.

Answer: If I understand your requirement correctly, you want to display the date on which data was loaded into the data target from which the report is being executed. If it is so, configure your workbook to display the text elements in the report. This displays the relevance of data field, which is the date on which the data load has taken place.

Question: Can we filter the fields at Transfer Structure?

Question: Can we load data directly into infoobject with out extraction is it possible.

Yes. We can copy from other infoobject if it is same. We load data from PSA if it is already in PSA.

Question: HOW MANY DAYS CAN WE KEEP THE DATA IN PSA, IF WE R SHEDULED DAILY, WEEKLY AND MONTHLY.

Answer: We can set the time.

Question: HOW CAN U GET THE DATA FROM CLIENT IF U R WORKING ON OFFSHORE PROJECTS. THROUGH WHICH NETWORK.

Answer: VPN. Virtual Private Network, VPN is nothing but one sort of network where we can connect to the client systems sitting in offshore through RAS (Remote access server).

Question: HOW CAN U ANALIZE THE PROJECT AT FIRST?

Prepare Project Plan and Environment

Define Project Management Standards and

Procedures

Define Implementation Standards and Procedures

Testing & Go-live + supporting.

Question: THERE is one ODS AND 4 INFOCUBES. WE SEND DATA AT TIME TO ALL CUBES IF ONE CUBE GOT LOCK ERROR. HOW CAN U RECTIFY THE ERROR?

Go to TCode sm66 then see which one is locked select that pid from there and goto sm12

TCode then unlock it this is happened when lock errors are occurred when u scheduled.

Question: Can anybody tell me how to add a navigational attribute in the BEx report in the rows?

Answer: Expand dimension under left side panel (that is infocube panel) select than navigational attributes drag and drop under rows panel.

Question: IF ANY TRASACTION CODE LIKE SMPT OR STMT.

In current systems (BW 3.0B and R/3 4.6B) these Tcodes don't exist!

Question: WHAT IS TRANSACTIONAL CUBE?

Answer: Transactional InfoCubes differ from standard InfoCubes in that the former have an improved write access performance level. Standard InfoCubes are technically optimized for read-only access and for a comparatively small number of simultaneous accesses. Instead, the transactional InfoCube was developed to meet the demands of SAP Strategic Enterprise Management (SEM), meaning that, data is written to the InfoCube (possibly by several users at the same time) and re-read as soon as possible. Standard Basic cubes are not suitable for this.

Question: Is there any way to delete cube contents within update rules from an ODS data source? The reason for this would be to delete (or zero out) a cube record in an “Open Order” cube if the open order quantity was 0.

I've tried using the 0recordmode but that doesn't work. Also, would it

be easier to write a program that would be run after the load and delete

the records with a zero open qty?

Answer: START routine for update rules u can write ABAP code.

Answer: Yap, you can do it. Create a start routine in Update rule.

It is not “Deleting cube contents with update rules” It is only possible to avoid that some content is updated into the InfoCube using the start routine. Loop at all the records and delete the record that has the condition. “If the open order quantity was 0” You have to think also in before and after images in case of a delta upload. In that case you may delete the change record and keep the old and after the change the wrong information.

Question: I am not able to access a node in hierarchy directly using variables for reports. When I am using Tcode RSZV it is giving a message that it doesn't exist in BW 3.0 and it is embedded in BEx. Can any one tell me the other options to get the same functionality in BEx?

Answer: Tcode RSZV is used in the earlier version of 3.0B only. From 3.0B onwards, it's possible in the Query Designer (BEx) itself. Just right click on the InfoObject for which you want to use as variables and precede further selecting variable type and processing types.

Question: Wondering how can I get the values, for an example, if I run a report for month range 01/2004 − 10/2004 then monthly value is actually divide by the number of months that I selected. Which variable should I use?

Question: Why is it every time I switch from Info Provider to InfoObject or from one item to another while in modeling I always get this message “Reading Data” or “constructing workbench” in it runs for minutes____ anyway to stop this?

Question: Can any one give me info on how the BW delta works also would like to know about ‘before image and after image’ am currently in a BW project and have to write start routines for delta load.

Question: I am very new to BW. I would like to clarify a doubt regarding Delta extractor. If I am correct, by using delta extractors the data that has already been scheduled will not be uploaded again. Say for a specific scenario, Sales. Now I have uploaded all the sales order created till yesterday into the cube. Now say I make changes to any of the open record, which was already uploaded. Now what happens when I schedule it again? Will the same record be uploaded again with the changes or will the changes get affected to the previous record.

Answer:

Question: In BW we need to write abap routines. I wish to know when and what type of abap routines we got to write. Also, are these routines written in update rules? I will be glad, if this is clarified with real-time scenarios and few examples?

Answer: Over here we write our routines in the start routines in the update rules or in the transfer structure you can choose between writing them in the start routines or directly behind the different characteristics. In the transfer structure you just click on the yellow triangle behind a characteristic and choose “routine” In the update rules you can choose “start routine” or click on the triangle with the green square behind an individual characteristic. Usually we only use start routine when it does not concern one single characteristic (for example when you have to read the same table for 4 characteristics). I hope this helps.

We used ABAP Routines for example:

To convert to Uppercase (transfer structure)

To convert Values out of a third party tool with different keys into the same keys as our SAP System uses (transfer structure)

To select only a part of the data for from an infosource updating the InfoCube (Start Routine) etc.

Question: What is ODS?

Answer: An ODS object acts as a storage location for consolidated and cleaned-up transaction data (transaction data or master data, for example) on the document (atomic) level.

This data can be evaluated using a BEx query.

Standard ODS Object

Transactional ODS object:

The data is immediately available here for reporting. For implementation, compare with the Transactional ODS Object.

A transactional ODS object differs from a standard ODS object in the way it prepares data. In a standard ODS object, data is stored in different versions ( (new) delta, active (change log), modified), where as a transactional ODS object contains the data in a single version. Therefore, data is stored in precisely the same form in which it was written to the transactional ODS object by the application. In BW, you can use a transaction ODS object as a data target for an analysis process.

The transactional ODS object is also required by diverse applications, such as SAP Strategic Enterprise Management (SEM) for example, as well as other external applications.

Transactional ODS objects allow data to be available quickly. The data from this kind of ODS object is accessed transactionally, that is, data is written to the ODS object (possibly by several users at the same time) and reread as soon as possible.

It offers no replacement for the standard ODS object. Instead, an additional function displays those that can be used for special applications.

The transactional ODS object simply consists of a table for active data. It retrieves its data from external systems via fill-or delete-APIs. The loading process is not supported by the BW system. The advantage to the way it is structured is that data is easy to access. They are made available for reporting immediately after being loaded.

Question: What does InfoCube contains?

Answer: Each InfoCube has one FactTable & a maximum of 16 (13 + 3 system defined, time, unit & data packet) dimensions.

Question: What does FACT Table contain?

A FactTable consists of KeyFigures.

Each Fact Table can contain a maximum of 233 key figures.

Dimension can contain up to 248 freely available characteristics.

Question: How many dimensions are in a CUBE?

Answer: 16 dimensions (13 user defined & 3 system pre-defined [time, unit & data packet]).

Question: What does SID Table contain?

SID keys linked with dimension table & master data tables (attributes, texts, hierarchies)

Question: What does ATTRIBUTE Table contain?

Master attribute data

Question: What does TEXT Table contain?

Master text data, short text, long text, medium text & language key if it is language dependent

Question: What does Hierarchy table contain?

Master hierarchy data

Question: What is the advantage of extended STAR Schema?

Question: Differences between STAR Schema & Extended Schema?

Answer: In STAR SCHEMA, A FACT Table in center, surrounded by dimensional tables and the dimension tables contains of master data. In Extended Schema the dimension tables does not contain master data, instead they are stored in Masterdata tables divided into attributes, text & hierarchy. These Masterdata & dimensional tables are linked with each other with SID keys. Masterdata tables are independent of Infocube & reusability in other InfoCubes.

Question: As to where in BW do you go to add a character like a \; # so that BW will accept it. This is transaction data which loads fine in the PSA but not the data target.

Answer: Check transaction SPRO____Then click the “Goggles” -Button ⇒ Business

Information Warehouse ⇒ Global Settings ⇒ 2nd point in the list. I

hope you can use my “Guide” (my BW is in german, so i don't know all the english descriptions).

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

Question: When are Dimension ID's created?

Answer: When Transaction data is loaded into InfoCube.

Question: When are SID's generated?

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

Question: How would we delete the data in ODS?

Answer: By request IDs, Selective deletion & change log entry deletion.

Question: How would we delete the data in change log table of ODS?

Answer: Context menu of ODS ‘Manage’ Environment' change log entries.

Question: What are the extra fields does PSA contain?

Answer: (4) Record id, Data packet?

Question: Partitioning possible for ODS?

Answer: No, It's possible only for Cube.

Question: Why partitioning?

Answer: For performance tuning.

Question: Have you ever tried to load data from 2 InfoPackages into one cube?

Answer: Yes.

Question: Different types of Attributes?

Answer: Navigational attribute, Display attributes, Time dependent attributes, Compounding attributes, Transitive attributes, Currency attributes.

Question: Transitive Attributes?

Answer: Navigational attributes having nav attr these nav attrs are called transitive attrs

Question: Navigational attribute?

Answer: Are used for drill down reporting (RRI).

Question: Display attributes?

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

Question: How does u recognize an attribute whether it is a display attribute or not?

Answer: In Edit characteristics of char, on general tab checked as attribute only.

Question: Compounding attribute?

Answer:

Question: Time dependent attributes?

Answer:

Question: Currency attributes?

Answer:

Question: Authorization relevant object. Why authorization needed?

Answer:

Question: How do we convert Master data InfoObject to a Data target?

Answer: InfoArea ‘Infoprovider (context menu)’ Insert characteristic Data as DataTarget.

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

Answer: Using Flexible update method while creating InfoSource.

Question: Steps in LIS are Extraction?

Answer:

Question: Steps in LO are Extraction?

Answer: 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. Question: Steps in FlatFile Extraction? Answer: Question: Different types in LO's? Answer: 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. Question: What does LO Cockpit contain? Answer: Maintaining Extract structure.

  • Maintaining DataSources.

  • Activating Updates.

  • Controlling Updates.

Question: RSA6____Maintain DataSources.

Question: RSA7____Delta Queue (allows you to monitor the current status of the delta attribute)

Question: RSA3____Extract checker.

Question: LBW0____TCode for LIS.

Question: LBWG____Delete set-up tables in LO's.

Question: OLI * BW____Fill Set-up tables.

Question: LBWE____TCode for Logistics extractors.

Question: RSO2____Maintaining Generic DataSources.

Question: MC21____Creating user-defined Information Structure for LIS (It is InfoSource in SAP BW).

Question: MC24____Creating Updating rules for LO's.

Question: PFCG____Role maintenance, assign users to these roles.

Question: SE03--Changeability of the BW namespace.

Question: RSDCUBEM____For Delete, Change or Delete the InfoCube.

Question: RSD5--Data packet characteristics maint.