Garuda Trainings

What other tables are created for master data?
The tables that are created for master data are:
-> M view – Combines P and Q tables.
-> P table – Time independent master data attributes.
-> Q table – Time Dependent master data attributes.
->X table – Interface between master data SID and time independent navigational attributes SID where P is linked to the X table.
->Y table – Interface between master data SID and time dependent navigational attributes SID where Q is linked to the Y table

How can an info object as info provider and why?

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

What are the advantages of SID table?

The SIC table Surrogate ID table is the interface between master data and the dimension table, and the advantages are:
->Uses Numeric as indexes for faster access.
->Master Data independent of info cubes.
-> Language support.
->Slowly changing dimension support.

As per the update rule what are the conversion routines for units and currencies?

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.

How the dimensions are optimized?
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.

In Data Ware housing what are the nine decision points used in BW ?
The nine Decision Points of Data Warehousing are:
-> Identify Dimension Tables.
-> Identify Attributes of entities.
-> Define granularity of the fact table.
-> Pre Calculated Key figures.
->Slowly changing dimensions.
-> Define attributes of entities.
->How long data will be kept.
->Aggregates.
-> How often data is extracted.

What is BW Statistics and how is it used?

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.

See More Details :http://ow.ly/z0Y3w

SAP Business Objects Online Training

SAP BO (Business Objects) is the enterprise reporting tool in the SAP Suite and offers extensive reporting and data visualization solutions by means of dashboard and reports along with various cross platform and integration utilities. It has five different servers or tiers-Client, Application, Intelligence, Processing and the Data tier. Together, these tiers help in easy reporting and analysis features for diverse enterprise needs.

For More Details: http://ow.ly/yYOZZ

What is aggregate awareness? What is its advantage?

Aggregate awareness function is used in scenarios where we have same fact tables in different grains.
The advantage is that in a Web or Desk report when one drags the measure object with the dimension object of a particular granularity, the measure column from the Fact table of the corresponding granularity is selected in the BO default Query. If we did not use aggregate awareness, we would need to define separate objects for each of the fact tables which would be difficult to understand from a user’s point of view.

List out the .?
The are:

How many Domains are there in Business Objects? What are they?

There are three Domains in Business Objects and they are:
->Security
->Document
->Universe

How can Chasm Trap be solved?

Chasm trap should be solved by making use of two different methods.

In the case of SQL parameters in universe, the option generates numerous queries for each and every measure that needs to be chosen. This helps in generating SQL statement for every measure and gives the correct results.
Another approach is to include two joints in different contexts, where the problem will get solved by generating two synchronized queries.

Define a Chasm Trap.?

Chasm trap is a condition that arises when the values inside the fact table get inflated at the time of measuring the values from two different fact tables by considering the dimensions inside dimension table.

How can Contexts be created?

Context can be created by making use of feature associated with context or by manual procedures. The context are usually created by making use of logical calculation or based on the business requirements. The detect context may not be much useful in this case and so it should be done by making use of manual procedure.

Define a context in the universe?

Context can be defined as the particular path of join between a specific group of joins or the tables for the purpose of a particular query. A particular object that can be found inside the column of a table, belonging to particular context is supposed to be compatible to all the various kinds of objects belonging to the same context. In the case of objects that are from the various kinds of context, different kinds of SQL can be generated, and the results can be merged inside micro cube. This is for making sure that there is no incorrect result associated with a loop or any other kind of issue related with join path.

Define custom hierarchies?

The custom hierarchies can be used for defining the universe for facilitating drill down that is customized and can happen between objects from different or same classes considering the user requirements.

What is a secured connection?

Secured connection is a kind of connection that can be helpful in overcoming the various limitations associated with the former connections. The rights related with this kind of connection can be set over documents as well as objects. Universes can be brought inside central repository only by making use of secured connection. The parameters regarding these connection care usually saved inside CMS.

What is Shared connection?

This is a kind of connection that is usually made used by other user via a server which is shared one. The details regarding the connection can be stored within the SDAC>LSI file which can be found within the installation folder of the business objects.

What is a personal connection?

Personal connection can be created only by a single user and it can’t be made used by others. The details regarding such a connection can be usually stored inside PDAC.LSI file.

Define drill mode.?

This is a kind of analysis mode associated with business objects and helps in breaking down data as well as in viewing data from all the possible angles and the levels of detail for discovering the factor that has caused good – bad result

Define the kinds of data providers?

There are various kinds of data providers available for the business objects and they are

Stored procedures
Queries over universe
Free hand – SQL
VBA procedures
SAP
OLAP servers
Personal data files

What are the various data sources available?

Business objects help you in accessing the data from variety of sources. You have the possibility of accessing data from RDBMS like oracle, MS SQL server and IBM DB2.

List out the kinds of users associated with business objects.?

There are various different kinds of users associated with business object, they are

General supervisor
Supervisor
Graphical Interface
Designer
Supervisor Designer
End User
Versatile User

List out the various kinds of methods related with multidimensional analysis that is inside business objects.?

There are two different methods related with multidimensional analysis available inside BO and these methods are

Slice & Dice
Drill down

What are the kinds of modes associated with designer and business objects?

There are especially two different kinds of modes associated with these platforms, they are

Enterprise mode
Work group mode

Define Designer.?

Designer is a module related with Business Objects IS used by the designers for creating and maintaining universes. Universes can be considered as semantic layer that can isolate the end users from the various issues that are technical and related with the structure of database. Universe designers has the possibility for distributing the universes to the end users after moving these as file through the system of files or can be done by exporting the files to the repository.

List out the different products related with Business Objects.?

There are various kinds of products related with business objects and they are

User module
Designer
Supervisor
Auditor
Set Analyzer
Info View
Business Objects – Software Development – Kit
Broadcast Agent

Explain the pros of using business objects.?

There are many advantages in making use of business objects and they are

User friendliness
Business terms that are familiar
Graphical interface
Deployment of documents on an enterprise basis by making use of WebI
Dragging and dropping
Powerful reports for a lesser amount of time.

SAP Business Objects(BO) Training online

Define Business objects.?

Business object can be considered as integrated analysis, reporting and query for the purpose of finding solution to some business professionals that can be helpful for them to retrieve data from the corporate databases in a direct manner from the desktop. This retrieved information can be presented and analyzed within a document that of business objects. Business objects can be helpful as an OLAP tool by the high level management as a major part of Decision Support Systems.

http://garudatrainings.com/sap-business-objects-online-training/

garudatrainings.com SAP BO Online Training from garudatrainings. we provide sap business objects training from real time experts.

What is a derived table in data warehousing?

Advantages of derived table: It can be created using an SQL statement with complex expressions, joins and prompts which are not possible to create in BO Universe using normal approach.

What are the different types of filters available in business objects?

There are 2 types of filters in BO.

1. Global: which is at universe level filter

2. Local : This is further divided into 2 types:

(a) Query filter
(b)Report filter

Query filter is further divided into 2 types:

(a) Static filter
(b) Dynamic filter

SAP HANA (High-Performance Analytic Appliance) is one of the most popular and widely used in-memory database technology for enterprise needs. Its a part of the SAP suite and is designed to greatly reduce the response time for time-critical applications in real-time business scenarios. Unlike conventional RDBMS (Relational Database Management System) which stores data in drives, in-memory databases follow a hybrid storage model in the main memory itself-thereby reducing the response time from an application. SAP HANA is designed to be a storage platform for applications needing a faster real-time response and greatly improves business transactions, analysis and reporting.

Web : http://goo.gl/gF579B

QTP Latest Interview Questions 2014

QTP Latest Inter view Questions 2014 By Garuda Trainings

http://goo.gl/gkvM4q

slideshare.net QTP (Quick Test Professional) is now called HP Unified Functional Testing (UFT) and is one of the leading test automation software for functional and regressio…

Explain QTP Testing process?

Quick Test testing process consists of 6 main phases:

1) Create your test plan - This is preparatory phase where you identify the exact test steps, test data and expected results for you automated test. You also identify the environment and system configurations required to create and run your QTP Tests.

2) Recording a session on your application - During this phase , you will execute test steps one by one on your AUT ,and QTP will automatically record corresponding VB script statements for each step performed.

3) Enhancing your test - In this stage you will insert checkpoints , output values , parameterization , programming logic like if…else loops to enhance the logic of your test script.

4) Replay & Debug - After enhancements you will replay the script to check whether its working properly and debug if necessary.

5) Run your Tests - In this phase you will perform the actual ex*****on of your Test Script.

6) Analyzing the test results - Once test run is complete, you will analyze the results in the Test Fusion report generated.

7) Reporting defects - Any incidents identified needs to be reported. If you are using Quality Center , defects can be automatically raised for failed tests in QTP.

See More Details Below:
http://ow.ly/yI7ir

What are the types of environment variables in QTP ?

Environment variables in QTP are of three types:

1) Built-in (Read only)

2) User-defined Internal (Read only)

3) User-defined External (Read/Write)

You Set the Environment Variable using the following syntax

Environment.Value( "name") = "Guru99"

You can Retrieve the Environment Variable using following syntax

Environment.Value("name") -- This will retrun name as Guru99

Environment.Value("OS") -- This will return your system OS

See More Details Below:
goo.gl/W4T15T