IMP -> SAP - Business Warehouse Interview Questions

SAP - Business Warehouse

What is the time distribution option in update rule?
What is info provider documentation?
What is the transaction code for generic extraction tool?
What is the transfer routine of the info object?
What are the versions in objects?
Which table has the aggregate status and data?
What is high cardinality dimension?
What is a calculated key figure?
What is transactional ODS object?
What is the precaution you should take when archiving?
What are the update modes available?
What file formats are supported?
What are the reporting agent tasks?
Explain variable offsets?
What is a cell editor?
What is the use of setup table?
What is the use of setup table?
What are the important aggregation usage indicators?
What is Open Hub (OH)?
What is a typical setup of BW team?
Which transaction shows templates for authorizations?
What is filter area?
How do you debug user exit?
What are the mathematical functions?
What is SUMRT?
What are the two fact tables?
What are the steps within SBIW to create classes for BW?
What is aggregate realignment run maintenance?
What is an aggregate?
What are the project phases within ASAP?
What is COUNT function?
Explain the display properties?
What are the options available in update rule?
What are the other tables created for master data?
What are characteristics values?
What are the read modes for query?
What are value fields?
How will you add buttons to a template?
What are the system tools you can use?
How do you define exception reporting in the back ground?
What is the source for FIAP extractor?
How do you enable monitoring using BW statistics?
What are value sets?
What is authorization processing type?
How do you create a reusable structure from a local structure?
What is a SID table and advantages?
What is the ODS object settings?
What is the source for FIAR extractor from R/3?
What is flexible updating?
What is business content?
What are the control parameters for data transfer?
What are the steps to load non cumulative cube?
Where do you find which table is currently being populated
What are the load process and post processing?
What are the pre-requisites of DB connect?
What are the data target administration tasks?
What is the use of change log?
What are the LO extraction transaction?
What is the procedure to create a data mart?
What are nodes?
How do you replace a query result from a master query to a child query?
What is the maximum number of characteristics you can have per dimension?
What are the naming conventions for aggregates created from statistics?
What are the web related tuning we can do?
How would you send e-mail when a process ends?
What are the general restrictions?
What is the transaction for process chain?
What is a restricted key figure and give an example?
What are events and how you use it in BW?
What are the SAP enhancements to enhance HR data?
How do you install business content AWB?
What is the advantage of CO-PA?
Which transaction can you use to get current statistics data?
What is virtual info cube with services?
What is summarization level?
When should you do the alpha conversion?
What is CO-PA retraction?
What are the special conversions for time in update rules?
What is a free characteristic?
Define the record modes for delta?
What are the advantages of BW 3.x web server (WAS)?
What is compression or collapse?
What does the program RSMDCNVEXIT check?
What are the elementary tests you can run?
What are the query restrictions?
What does a Boolean operator returns?
What is the option ‘default chains’?
What is ‘filling’ of aggregate?
What is a content extraction?
What is a multi provider?
What is change run?
What are the steps to configure third party (BAPI)?
How do you create/maintain aggregates?
What are the template options?
What are the settings for Transport?
What are hierarchy levels?
What is an external hierarchy?
Where will you get more information on the delta methods?
How do you send XML data to BW?
Where will you get more information on the delta methods?
What is the maximum number of key figures you can have in an info cube?
How many dimensions in a cube?
What are the steps to create a generic data source?
What is a controlling area?
What is the optional size of the aggregates?
How do you set up the permitted characters?
What is ‘predefined characteristics’?
What is extraction setup?
What is the number of decimal places in scaling factor?
What are the limitations of line item dimension?
What is the unique data records flag?
What are the options to convert currency?
What is the new features of ODS after version 3.x?
What is automatic loading of similar/identical requests option?
What is percentage share?
What is early delta initialization?
What are the uses of data marts?
What happens when you use several conditions in a query?
What is the transaction for LIS?
How do you create a value set?
What are the steps to extract data from R/3?
What is translation key?
What is the table filled when you select ABAP?
How would you convert an info package group to a process chain?
What is the transaction to maintain services?
What are the added features in 3.x for multi provider?
What is the archival transaction?
What is the top transaction for extraction?
What are the options available for updates to data target?
What are the DATA_MODE options in the command line URL?
What are the parallel processes that could have locking problems?
What are the data types allowed for key figures?
What is the alpha check execution program?
What is the data loading tuning we can do?
Which report can you use to monitor change run?
What is standard and exception aggregation?
What is a source system?
What is E_T_RANGE?
What is ‘user master comparison’ in roles?
What is translation key?
What is table partition?
What is a template?
What is scaling factor?
What is the DIM ID?
What are the proposal options available?
What are the objects that support variables?
How do you transform OH data?
What is the transaction to check extractor?
What is a profitability segment?
What is the call sequence? What are the hierarchy relevant parameters?
What are the general services supported?
What are the data targets supported by open hub?
What are the options for hierarchy node variables?
What is the namespace of BW?
What is difference between star schemas and extend star schema?
What are the monitor settings?
What is direct updating of info objects?
What is a slowly changing dimension?
What are the steps in general to enhance data?
How will you get more details on data source and delta modes?
What is a transactional info cube?
How is multi provider different from info set?
What is replacement path?
What are the flags for general reporting?
Define an info source?
How many types of info sources are there? What are they?
How will you debug errors with SAP GUI?
What is the archival transaction?
What are the general tuning guidelines? 53
What is the cell restriction and the options?
What are the settings for flat files?
What are the types of reports you can use in reporting agent?
What is L_S_RANGE?
How do you upload currency exchange from a flat file?
How many LIS structures are created?
What is the include program name?
What is a profitability segment?
What are the reporting performances can we do?
What are the settings for Reporting?
How do you handle language dependent texts?
What is the component?
What is an exception?
What is the Meta data and Meta data manager?
What are the scheduling options for start process?
What is the monitor transaction?
What is the attribute only flag?
What are the variable processing types?
What is persistence mode in cache? 22
What is the transaction to check delta?
How do you delete change log?
What is processing type customer exit?
What is ASAP?
How is OLAP application different from OLTP application?
What are the nine decision points of data ware housing?
What is the default web template used in report?
What is an exception aggregation?
What is reconstruction?
What is the name restriction on field when you append structure?
How would you change the default template?
What is delete table before extraction option?
What are the different types of attributes?
How would you re-assign to proper component?
What is the procedure to be followed to archive cube?
How will you schedule the job in background?
What is alpha conversion?
How to create info set with info cube?
What is the cache monitoring transaction?
How do you enter documents?
What is the licensing requirement you should be aware of?
What is the option of ‘pause Automatic Refresh’?
Define a ‘Marker’?
What is inflow and outflow?
What is the function module to convert currency?
What does the VARIABLE_SCREEN URL parameter do?
What are the objects that support documentation?
What are the enhancements available for LIS?
What is the naming convention of LIS data source?
What is DB connect?
What technology is used in BW archiving?
What is alpha conversion?
What is persistence mode in cache?
How the master data is read?
What are the settings for data transfer?
What are the variable processing types?
What are intervals?
What are the views available for a process chain?
What is the procedure to implement structural authorization in BW?
What is a number range object?
What is a structure?
What is a constant selection?
What are the expressions allowed?
How will you change the default destination of open hub files?
What is the format of LO data sources?
How would you analyze the size of fact table?
What is characteristics derivation?
What are the enhancements one can do in SAP MM,
What are the data targets supported by open hub?
What is the 90 day rule?
What is the safety delta for CO-PA?
What is 1 ROWCOUNT key figure?
What is global transfer rule?
What are the table structures associated with ODS?
What are the general tuning guidelines?
What is a reusable structure?
What is user entry?
What are the advantages of new LO extraction?
What are the steps to create classes?
How is archiving advantageous?
What are non cumulative key figures?
What happens when you use several conditions in a query?
What is the program to maintain change run? 23
What is aggregate hierarchy?
What are the parameters available in user exit for enhancing master data?
Define a remote cube?
What are the restrictions DB connect?
How do you do EURO conversion at the database level?
When we use condition the totals do not match why?
What are the delta modes available?
How the query from BW is used?
What is the library?
What is the start routine?
What are the exits available in HRPTDW01?
How is an extended star schema of BW more advantageous
How do you improve the performance when creating setup table?
What is the grouping option available when installing?
What is a repair request?
What are the built in javascript functions available
How do you copy queries?
What is LIS?
Which transaction defines the background user in source system?
What are the steps to enable delta load for generic data sources?
What is the Oracle specific tuning should be done?
What is a characteristic in CO-Pa?
What is operating concern?
What is delta update?
What is the “$” as an authorization value?
What are the destination target options?
What is the DIM ID?
Where do you store your custom images (like logos)?
What is I_VNAM?
What is info object OTCTAUTHH?
What are the extractor types?
What are formula variables?
Define the update rule?
How would you debug web reports?
How do you install BW statistics?
What is the standard naming convention of the CO-PA data source?
How do you replace a query result from a master query to a child query?
What is the source for FIAR extractor from R/3?
What is the maximum number of customer defined
What is SUMGT?
What is SAP exit?
What is update mode for master data?
What are the data sources supported?
What is a validity determining characteristic?
What is a time reference characteristic?
What is a star schema?
What are the combined tests?
What is compounding?
Define the steps necessary to set up CO-PA for BW?
What are the servers related tuning?
What is ‘roll up’?
What is the scope of variables?
What is the scope of variables?
What is the function module for this user exit?
What is the use of BW statistics?
What are the data types supported by characteristics?
What are variables?
What is the data flow from LIS tables to BW?
What are the restrictions/recommendations for using remote cube?
What are the settings for web?
What is time dependent text/attribute of characteristics?
What are the size parameters for archiving?
What is the data model and how it is use?
What are the objects that support documentation?
What is COUNT function? 21
What are the options when defining aggregates?
What are the report-relevant settings in the hierarchy maintenance?
What are the return table options in update rules for key figures?
What is the conversion routine for units and currencies in the update rule?
What are the delta options available when you load from flat file?
What is the SAP enhancement of data sources?
What are processing commands?
What is an info object?
What are the options for conditions for key figures?
What is SUMCT?
What are the user exits within the enhancement?
What transaction is used to set the query read mode?
How will you configure BW to load data from data stages?
What are the options for ‘calculate single value as’?
What are text variables?
How do you create event chains?
Where do you store custom style sheets?
What are the naming conventions used for aggregates created from query?
What is the web download scheduler?
What is a characteristics variable?
Give us sample third party ETL tools supported by SAP?
Which table contains the exchange rate?
What is a control query?
What are the profile parameters for cache?
What are the follow-up actions available for reporting agent?
Define ODS?
Mention the options available in the transfer rule?
What is exception aggregation?
How BW was found?
What are the important formulas available in BW?
What is the SAP enhancement used for this user exit?
What is a line item or degenerate dimensions?
What are the aggregation options for key figures?
How are dimensions optimized?
What is the use of CO-PA?
What is an exception cell?