Interview Questions Answers in Software Design Tools, SAP AllOther, Business Objects

Questions / { padmalatha }

Questions Answers Category Views Company eMail

Can i know what are your daily routines of an bo developer for 4 years experience guys

Software Design Tools 1469

How can we explain our project in interview panel?

SAP AllOther 1959

what are your daily activities as a bo supporter?

SAP AllOther 1526

Answers / { padmalatha }

Question { 5465 }

Can any body Explain me what are the critical problems you
have faced in the designer and repoting level in the real
time environment?

Answer

how can we overcome this

Is This Answer Correct ?

0 Yes

0 No

Question { 3865 }

What is mean by stored procedure ? and how we can generate
stored procedure universe?

Answer

stored procedure means generation of multiple sql queries

Is This Answer Correct ?

0 Yes

0 No

Question { CTS, 21544 }

what is the difference between input file repository server
and output file repository server ?

Answer

IFRS: Repoprts go for scheduling
OFRS: Out from scheduling

Is This Answer Correct ?

1 Yes

0 No

Question { HCL, 4663 }

Suppose i have the sinario like this
column1: e1,e2,e3,e4 :
column2: 1,0,1,0 :
column3: M,F,M,F : in this i want to disply 1 is male
and 0 is female which is added to the another column like
column 4 what is the process?

Answer

Drag and drop column 2 after column 3
then create condition for column 3 by using new rule in 4.1

Is This Answer Correct ?

1 Yes

1 No

Question { 3640 }

HI, Can any body explain me ? If we careate objects using
derived tables it will decreasess the performence? If we
are not creating the objects using the derived tables then
what is the use of having the derived tables?

Answer

we can create objects using derived tables
if derived tables increses then only performance decreses
but if we include one object form this table the entire query from this table is executed.we can see this in query panel

Is This Answer Correct ?

0 Yes

0 No

Question { 2864 }

HI, can anybody tell me aggrigate awareness is only for
aggrigate tables or if any?

Answer

can be used for nrml tables also

Is This Answer Correct ?

0 Yes

0 No

Question { 5169 }

Tell me about a complicated object you have created?

Answer

Complex object is nothing but
For example use a derived table which incorporates SQL function paired with a @prompt to display top 3 values.

Is This Answer Correct ?

0 Yes

0 No

Question { TCS, 5122 }

when you have three fact table and there is no relationship
between them. How you will tackle the issue.

Answer

no issue because a fact tabels were connected with the lookup tables.

Is This Answer Correct ?

0 Yes

1 No

Question { CTC, 8016 }

how to solve the incompatible objects and how they are
formed actually.

Answer

when we are creating hierarchies nthng but we created hierarchies for month,quarter,week.in the report level while performing drilling wen we drag the year to the result pane then automatically it will show incompatible error

Is This Answer Correct ?

0 Yes

2 No

Question { Wipro, 3470 }

normally we get many contexts when resolving loops or
traps,how do u take them to reports.

Answer

by solving those loops by alias,shortcut or context

Is This Answer Correct ?

0 Yes

0 No

Question { Exilant, 4640 }

please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.

Answer

star schema: it can be defined as a fact table sorrounded dy dimension tables and all the dimension tables should be de-normalised
snow flake schema: it can be defined as fact tables sorrunded by dimension tables and those dimension tables atleast one dimension table should be normalised

Is This Answer Correct ?

1 Yes

0 No

Question { TCS, 5970 }

How do you find what type of trap is there by seeing the
report?

Answer

by viewing we can define weather it is fan trap or chasm trap
Fan trap: When three tables were joined in one to many relationship then it is fan trap.
Chasm trap: when two fact tables depend upon the same lookup table then it is known as chasm trap.

Is This Answer Correct ?

1 Yes

0 No

Question { IBM, 5993 }

I have a report with two queries and each query have prompt
on some
object. Tell me how many times it will ask for the input?

Answer

if promp description is same it will ask for one time otherwise it will ask for two times

Is This Answer Correct ?

2 Yes

0 No

Question { Cap Gemini, 12195 }

In a column if the value is >10000, it has to show downwards
Arrow in green color,
If the value is <10000, it has to show upwards arrow in red
Color....

How to achieve this?

Answer

by using new rule in 4.0 version we can make condition and the value to that condition by using format option in that new rule

Is This Answer Correct ?

3 Yes

1 No

Question { L&T, 5866 }

I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page.
One report will display all the salary details and other report will display only max salary.
How will you achieve this.

Answer

1)by using ranking in another report we can display only high salaries
2)keeping condition on filter panel

Is This Answer Correct ?

0 Yes

0 No