Interview Questions.

Q1. What Are The Advantages Of An Extended Star Schema Of Bw Vs. 'the Star Schema?

Uses generated numeric keys and aggregates in its very own tables for faster access.

Uses an external hierarchy.

Supports more than one languages.

Contains grasp facts not unusual to ;dl cubcs.

Supports slowly converting dimensions.

Q2. What We Do In Business Blue Print Stage?

SAP has described a business blueprint segment to assist extract pertinent records approximately your agency this is vital for implementation. These blueprints are inside the form of questionnaires that are designed to explore for data that uncovers how your organization does enterprise. As such, in addition they serve to document the implementation. Each enterprise blueprint file essentially outlines your future business procedures and business necessities.

Q3. Can You Add A New Field At The Ods Level?

Yes.

Q4. Give Me One Example Of A Functional Specification And Explain What Information We Will Get From That?

Functional Specs are requirements of the business user.Technical Specs translate these requirements in a technical fashion.Let's say Functional Spec says,

the person need to be able to enter the Key date, Fiscal Year, Fiscal Version.

The Company variable need to be defaulted to USA but then if the person desires to trade it, they could test the drop down listing and choose different countries.

The calculations or formulas for the report will be displayed in precision of one decimal point.

The document have to return values for twelve months of information depending at the fiscal 12 months that the consumer enters Or it ought to show in quarterly values. Functional specs also are known as as Software necessities.

Now from this Technical Spec follows, to remedy every of the line items listed above.

To supply the option of key date, Fiscal yr and Fiscal Version – sure Info Objects ought to be to be had within the system. If to be had, then have to we create any variables for them - so that they may be used as consumer entry variable. To create any variables, what's the technique, in which do you do it, what is the technical of the objects you will use, what'll be the technical name of the objects you may Crete due to this record.

Same clarification goes for the rest. How do you installation the variable,

What changes in houses will you do to get the precision.

How will you get the 12 months of records. What can be the technical and show call of the report, who'll be authorized to run this document, etc are without a doubt particular in the technical specs.

Q5. How To Load Data From One Infocube To Another Infocube?

Through DataMarts facts can be loaded from one InfoCube to every other InfoCube.

Q6. What Is The Use Bapi, Ale?

BAPI & ALE are applications to extract facts from DataSources. BW connects SAP systems (R/3 or BW) and flat documents thru ALE. BW connects with non SAP systems through BAPI.

Q7. What Is Difference Between Saving And Activating?

In BIW, Saving à in reality saves the defined structure and retrieves every time required.

Activating à It saves and generates required tables and structures.

Q8. Can An Infoobject Be An Infoprovider, How And Why?

Yes, when we want to report on Characteristics or Master Data. We must proper click at the InfoArea and select “Insert feature as records goal”. For instance, we are able to make 0CUSTOMER as an InfoProvider and document on it.

Q9. How Many Extra Partitions Are Created And Why?

Two walls are created for date earlier than the start date and after the end date.

Q10. What Is A Meta Chain?

Process chains which might be clubbed collectively are known as a Meta Chain. Each sub chain is induced handiest whilst the preceding Process Chain is successful.

Q11. What Is The Difference Between Amount /quantity Number Type Key Figures?

Amount /amount is continually mixed with devices. For instance, sales might be related to forex and stock can be related to amount in gadgets. In your design if you don't want gadgets then you definitely ought to use quantity or integer to enhance performance.

Q12. When An Ods Is In 'overwrite' Mode, Does Uploading The Same Data Again And Again Create New Entries In The Change Log Each Time Data Is Uploaded?

No.

Q13. What Is Replication Of Datasource?

Replication of Data Source enables the extract shape from the supply system to be replicated within the BW.

Q14. What Is The Specific Advantage Of Lo Extraction Over Lis Extraction?

The load performance of LO extraction is higher than that of LIS. In LIS  tables are used for delta control this is bulky. In LO most effective one delta queue is used for delta control.

Q15. Can We Extract Hierarchies From R/3 For Co-pa?

No, we cannot, there aren't any hierarchies in CO/PA.

Q16. When Filling The Set Tables, Is There Any Need Of Delete The Setup Tables?

Yes. By deleting the setup tables we are deleting the records this is within the setup tables from the previous replace. This avoids updating the statistics twice into the BW.

Q17. What Is The Function Of 'selective Deletion' Tab In The Manage Contents Of An Infocube?

It lets in us to pick out a specific fee of a specific field and delete its contents.

Q18. About Dtp ?

Data Transfer Process:

Data switch process (DTP) hundreds facts within BI from one object to some other object with respect to adjustments and filters. In quick, DTP determines how facts is transferred between  persistent objects.

It is used to load the facts from PSA to information goal (dice or ods or infoobject) accordingly, it replaced the facts mart interface and the Info Package.

Q19. Which Object Connects Aggregates And Infocube?

ReadPointer connects Aggregates and InfoCube. We can view the ReadPointer in desk RSDDAGGRDIR, the field name is RN_SID, every time we're rolling up the data, it includes the request variety, it's going to test with the next request for 2nd roll up. Just comply with the desk for a particular InfoCube and roll up the facts.

Q20. What Are Data-marts?

Data Marts are used to alternate records between special BW structures or to replace facts inside the identical BW system (Myself Data Mart). Here, the InfoProviders which might be used to provide data are known as Data Marts.

Q21. What Are Start Routines, Transfer Routines And Update Routines?

Start Routines: The start ordinary is run for each DataPackage after the facts has been written to the PSA and before the transfer policies were accomplished. It lets in complicated computations for a key determine or a function. It has no return value. Its motive is to execute initial calculations and to save them in worldwide DataStructures. This shape or table may be accessed inside the different exercises. The whole DataPackage inside the switch structure layout is used as a parameter for the habitual.

Transfer / Update Routines: They are defined on the InfoObject level. It is just like the Start Routine. It is unbiased of the DataSource. We can use this to define Global Data and Global Checks.

Q22. How Is The Delta Load Different For An Infocube And Ods?

An InfoCube may have additive Delta, however you'll still be able to see all man or woman facts in the InfoCube contents. This is due to the fact if you pick out to delete the modern request - then the records have to be rolled back to the previous fame. You construct a question at the InfoCube and at the query you may discover that the statistics is surely summed up. The ODS facts will now not have reproduction records. You could have most effective one report.

Q23. Differences Between Star And Extended Star Schema?

Star schema: Only traits of the size tables may be used to get admission to statistics. No based drill downs may be created. Support for plenty languages is difficult.

Extended big name schema: Master statistics tables and their associated fields (attributes), External hierarchy tables for established get entry to to information, Text tables with substantial multilingual descriptions are supported using SIDs.

Q24. What Is Ods?

Operational DataSource is used for precise garage of information. We can overwrite records inside the ODS. The information is saved in obvious tables.

Q25. Change Attribute Run.

Generally characteristic alternate run is used whilst there's any exchange within the master data. It's far used for realignment of the grasp information. Attribute alternate run is not anything however adjusting the master facts after its been loaded sometimes so that it could trade or generate or alter the Sid’s so that u won't have any problem while loading the transaction statistics in to records objectives. The detail clarification approximately Attribute exchange run. The hierarchy/attribute trade run which activates hierarchy and characteristic changes and adjusts the corresponding aggregates is split, into 4 levels:

Finding all affected aggregates

Set up all affected aggregates again and write the bring about the brand new aggregate desk.

Activating attributes and hierarchies

Rename the new mixture table. When renaming, it isn't viable to execute queries.

In some databases, which cannot rename the indexes, the indexes also are created in this segment.

Q26. What Is The Importance Of The Table Roidocprms?

It is an IDOC parameter supply machine. This table consists of the details of the facts switch just like the source system of the information, facts packet length, maximum number of traces in a records packet, and so on. The information packet size can be changed via the control parameters option on SBIW i.E., the contents of this table may be changed.

Q27. What Options Are Available In The Transfer Rule?

Assign an Infoobject - direct switch, no transformation

Assign a constant eg. If you are loading facts from a particular country from a flat report, you may make the us of a (17s) as a constant and assign the value explicitly

ABAP recurring eg. If you want to do a little complex string manipulation, expect that you are becoming a flat document from legacy facts and the fee center is in a field and you have to "rubdown" the information to get it in. In this situation the usage of an ABAP habitual is most suitable 

Formula - for easy calculations usc components eg. If you need to convert all lower casc cl~uractcrst o top case, use the TOUPPER components. You can use formilla builder to help put your formulas collectively.
 

Q28. What Are 3 Update Methods In Logistics Extraction?

Direct Delta

Queued Delta

Unserialized V3 Update

Q29. You Get New Status Or Additive Delta. If I Set Here (on R/three) What Is The Need Of Setting In Bw.

In R/3 the report mode determines this as visible inside the RODELTAM desk i.E., whether or not it will likely be a brand new reputation or additive delta for the respective DataSource. Based in this you need to pick the right update type for the facts target in BW. For e.G., ODS supports additive in addition to Overwrite function. Depending on which DataSource is updating the ODS, and the report mode supported by this DataSource, you want to do the proper choice in BW.

Q30. What Happens When You Load Transaction Data Without Loading Master Data?

The transaction facts gets loaded and the grasp statistics fields stay blank.

Q31. What Are Aggregates And When Are They Used?

• An mixture is a materialized, aggregated view of the statistics in an InfoCube. In an aggregate, the dataset of an InfoCube is stored redundantly and persistently in a consolidated form. Aggregates make it feasible to access InfoCube information speedy in Reporting. Aggregates can be used in following instances:

To speed up the execution and navigation of a specific query.

Use attributes regularly in queries.

To speed up reporting with characteristic hierarchies through aggregating unique hierarchy stages.

Q32. What Are 3 Uses Of Sapi Technology?

Transfer information and Metadata from SAP Systems

Transfer data from XML documents

Transfer statistics among BW data objectives or from one BW gadget to another (Data Marts)

Q33. When Is Data In Change Log Table Of Ods Deleted?

When requests loaded into ODS object are neither required for delta replace nor for initialization, they may be deleted. If delta initialization for replace exists in connected data goals, the requests must be updated first earlier than the records may be deleted.

Q34. What Is Activation Of Objects?

Activation of items permits them to be achieved, in other phrases used elsewhere for different purposes. Unless an object is activated it can't be used.

Q35. As You Said You Have Worked On Info Cubes And Ods, Which One Is Better Suited For Reporting? Explain And What Are The Drawbacks And Benefits Of Each One?

Depending on the kind of file the facts is saved in Info Cube or ODS. BW is used to store excessive volumes of information and quicker reporting. Info Cube is used to shop normalized facts. Master Data and transaction data are saved in Info Cube as in line with the Extended Star Schema using SIDs. The reporting is speedy.

ODS shops data in greater element utilizing its structure of obvious tables. Reporting on this can be sluggish. ODS is higher used for RRI.

Q36. When Given A Choice Between Using An Infocube And A Multiprovider, What Factors To Consider Before Making A Decision?

One would should see if the InfoCubes are used for my part. If those InfoCubes are regularly used personally, then it's miles better to head for a MultiProvider with many InfoCubes since the reporting could be faster for an character InfoCube query in place of for a huge InfoCube with lot of facts.

Q37. What Is The Advantage Of Bw Reporting On Co-pa Data Compared With Directly Running The Queries On Co-pa?

BW has a better overall performance gain over reporting in R/@For a big amount of statistics, the R/three reporting tool is at a severe drawback due to the fact R/three is modeled as an OLTP device and is good for transaction processing in place of analytical processing.

Q38. What Are Serialized And Unserialized V3 Updates?

In serialized V3 Update information is transferred from the LIS verbal exchange structure, using extract systems (e.G. MC02M_0HDR for the header buy documents), into a relevant delta management region.

With Unserialized V3 Update mode, the extraction statistics continues to be written to the replace tables the use of a V3 update module and then is examine and processed by a collective update run (thru LBWE).

Q39. Is It Necessary To Create The Partner Profiles In Case Of File To Idoc Scenario?

NO, it isn't always continually vital to create the associate profiles in case of document to idoc scenario if you are doing it for testing purposes otherwise you have to configure accomplice profile to guarantee XI for receiver client.

Q40. What Is The Transaction For The Administrator Work Bench?

Transaction RSA1

Q41. What Is Db Connect And Where Is It Used?

DB connect is a database connecting software. It is utilized in connecting third party tools with BW for reporting motive.

Q42. How Many Hierarchy Levels Can Be Created For A Characteristic Infoobject?

Maximum of 98 tiers.

Q43. What Exactly Happens (background) When We Are Deactivating/activating The Extract Structure For Lo Cockpit?

If the extract shape is activated then any on line transaction or on the compilation of setup tables, the records is published to the extract structures relying at the update technique decided on. Activation marks the DataSource with inexperienced else it's miles yellow. The activation/deactivation makes entries to the TMC EXACT table.

Q44. How Can You Get A List Of The Users With Development Access On A Particular System?

Table DEVACCESS

Q45. How Was Data Modeling Done In Your Project? Explain

Initially we study the enterprise method of client, like what sort of information is flowing inside the system, the quantity, adjustments taking region in it, the analysis finished on the facts by using customers, what are they anticipating within the future, how are we able to use the BW capability. Later we have meetings with commercial enterprise analyst and advise the facts version, based totally on the customer. Later we deliver a evidence of concept demo wherein we demo how we're going to build a BW facts warehouse for his or her gadget. Once we get an approval we begin requirement gatherings and constructing your model and trying out follows in QA.

Q46. How Long Does It Take To Load A Million Records Into An Infocube From An R/three System?

Depending on work load on BW aspect and supply device facet loading time varies. Typically it takes half an hour to load one million facts.

Q47. What Is I_updmode?

Transfer mode as asked inside the Scheduler of the BW. Not generally required.

Q48. What Are The Major Errors In Bw And R3 Pertaining To Bw?

Errors in loading records (ODS loading, InfoCube loading, delta loading and so on)

Errors in activating BW or different items.

Q49. What Is Extraction Queue? What Does It Contain?

Newly generated statistics will be saved in the extraction queue and from there a scheduled job will push it to delta queue.

Q50. What Is The Use Of Hierarchies?

Efficient reporting is one of the objectives of the usage of hierarchies. Easy drilldown paths can be constructed the use of hierarchies.