Sap-BW-Frequently asked Questions Home | Link with Us | Advertise with us | Contact Us | Site map | Rss
Interview Tips Faqs_Questions_And_Answers Articles Faqs_Questions_And_Answers Blog Faqs_Questions_And_Answers Forum Faqs_Questions_And_Answers Shopping Faqs_Questions_And_Answers Jobs Faqs_Questions_And_Answers Jokes Faqs_Questions_And_Answers News
Antivirus Faqs_Questions_And_Answers Software Tips Faqs_Questions_And_Answers ERP Faqs_Questions_And_Answers Internet Faqs_Questions_And_Answers Spoken English Faqs_Questions_And_Answers Web Designing Faqs_Questions_And_Answers SEO Tips Faqs_Questions_And_Answers Hacking
General Knowledge Faqs_Questions_And_Answers Question Papers Faqs_Questions_And_Answers Study Abroad Faqs_Questions_And_Answers Career Advice Faqs_Questions_And_Answers Training Institutes Faqs_Questions_And_Answers Exam Results Faqs_Questions_And_Answers Games Faqs_Questions_And_Answers Free Classifieds
SAP Faqs
C Faqs        C++ Faqs        Java Faqs        J2ee Faqs        Springs Faqs        Hibernate Faqs        Web sphere Faqs        Web Logic Server Faqs   
WordPress        Siebel Faqs        Shell Scripting Faqs        Perl Scripting Faqs        Open Source        Data Ware Housing Faqs        Joomla Faqs
Ajax        Oracle Apps Faqs        Testing Tools Faqs        Mainframes Faqs        Tibco Faqs        PHP Faqs        .Net Faqs       Operating System
 
BW
Custom Search
 SAP  |   FICO  |   ABAP  |   SD  |   MM  |   PP  |   HR  |   CRM  |   BW
1 What is BW Statistics and how is it used?
Ans:

The set of info cubes delivered by SAP as a part of SAP BIW which are useful in measuring the performance of how quickly a query is calculated, or how quickly data in loaded into BW and so on. BW statistics are the name suggest are useful in showing data about the costs associated with BW queries, aggregative data, OLAP, SAP business warehouse management.

 
2 Explain what is table partition?
Ans:

In order to improve the performance SAP is using the fact table. It can be partitioned only on 0CAlMONTH or 0FISCPER.
 
3 In Data Ware housing what are the nine decision points?
Ans:

The nine Decision Points of Data Warehousing are:

  1. Identify Dimension Tables.
  2. Identify Attributes of entities.
  3. Define granularity of the fact table.
  4. Pre Calculated Key figures.
  5. Slowly changing dimensions.
  6. Define attributes of entities.
  7. How long data will be kept.
  8. Aggregates.
  9. How often data is extracted.
 
4 When ABAP code is required during the transfer rule what important variables can be used and what are the options available in transfer rule?
Ans:

When ABAP code is required during the transfer rule the important variables that can be used are by assigning info objects, assigning a constant, ABAP routine or a formula.

 
5 How many dimensions are in Cube?
Ans:

There are 16 out of which 3 are predefined time, unit and request, customer is left with 13 dimensions.

 
6 How the dimensions are optimized?
Ans:

It system can be used as many as possible for performance, for instance it may be assumed that 100 products and 200 customers; if one dimension for both, the size of the dimension will be 20000; if it was made individual dimensions then the total number of rows will be 300. Even if they are taken more than one characteristic per dimension, the math considering worst case and decide which characteristics may be combined in a dimension.
 
7 As per the update rule what are the conversion routines for units and currencies?
Ans:

As per the update rule, the Time dimensions are automatically converted for example if the cube contains calendar month and the transfer structure contains date, the to calendar month is converted automatically.

 
8 What are the advantages of SID table?
Ans:

The SIC table Surrogate ID table is the interface between master data and the dimension table, and the advantages are:

  1. Uses Numeric as indexes for faster access.
  2. Master Data independent of info cubes.
  3. Language support.
  4. Slowly changing dimension support.
 
9 How can an info object as info provider and why?
Ans:

When the report on characteristics or master data, it can make them as info provided for example make 0CUSTOMER as info provided and do Bex reporting on 0CUSTOMER, right click on the info area and select “Insert Characteristic as data target”

 
10 What other tables are created for master data?
Ans:

The tables that are created for master data are:

  1. M view – Combines P and Q tables.
  2. P table – Time independent master data attributes.
  3. Q table – Time Dependent master data attributes.
  4. X table – Interface between master data SID and time independent navigational attributes SID where P is linked to the X table.
  5. Y table – Interface between master data SID and time dependent navigational attributes SID where Q is linked to the Y table
Page : 1 | 2 | 3 | 4
Top

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player
Our Portals ::: Seo Training | Health & Fitness Tips | Hospitals in Andhra Pradesh | Temples in India | Ladies Fashion Tips
  Examination Results| Tollywood Movies | Training Institutes | Questions and Answers | Best Deals | Leather Industry
Terms and conditions     Rss     Privacy Policy    Disclaimer    All copy rights reserved © Tips on interview