Answer / narsi

in BOxir2 wise it is possible. would u have base uni &
dervied uni's. i think ur requirement is solve by
using "combining query" option & just select "union"
operator wise ur query is solve.

anotherwise u go for webi, select "MERGE" option it is
possible.

otherwise, ur requirement is not possible. because ur
columns names are not maching.

u go for deski, select "datamanager" --> click "link to"
Option it is possible.

Answer / naresh

It is possible only if one object each from each universe is
of same data type and then linking those objects from Data
Manager as said above.

Answer / swetha

You can do by synchronising both data providers i.e.
you need to use LinkTo command buttion in ViewData option
by matching corresponding dimensions that have the same
data type.

by default Null Values also placed in the report.then you
can use NotIsNull option to avoid Nulls.

Thanks,
Swetha

Answer / narsi

in BOxir2 wise it is possible. would u have base uni &
dervied uni's. i think ur requirement is solve by
go for deski, select "datamanager" --> click "link to"
Option it is possible.after use using "combining query"
option & just select "union"
operator wise ur query is solve.

anotherwise u go for webi, select "MERGE" option it is
possible.

otherwise, ur requirement is not possible. because ur
columns names are not maching.

Answer / suvarna

You can do a trick. Suppose u have different objects in
two data providers (lets say dpA and dpB),dpA have product
related objects for example product code, product name etc
and dpB have customer related objects.U drag a object from
a dp, lets take dpA.
Now when u try to drag a object from dpB u will not be able
to do that.
For this , go to the tool bar->view data->definitions->
link the object u want to drag(say customer name from dpB)
with any object from dpA ->select Ok.Now u will be able to
drag the customer name from dpB. U will see that data
displayed in the report is not correct.Now again go to view
data and unlink the objects->select Ok.
Now u will get the correct data in the report.

Is it possible to generate reports without having knowledge of the Universe structure?

4 Answers  

I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,

Draw the architecture of traps?

3 Answers   Wipro,

. User wants to modify a report and wants to add additional data. How will you approach.

2 Answers  

how will you move the universe/report from development to production?

3 Answers   TCS,

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..

4 Answers   IBM,

how do u implement dense rank in bo reports?

2 Answers   CTS,

Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

4 Answers   TCS,

Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?

1 Answers  

10.why we are going to data warehouse?

4 Answers   Satyam, TCS,

Can any body tell me,What is the universe testing ? What is the report testing Explain?

2 Answers  

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers   Polaris,