HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO
YOU LINK THEM?
Answers were Sorted based on User's Feedback
Answer / augustine
Yes. When you pull data from different data souces, if the
dimension name is same then they get linked automatically.
Ex. You have "Month" in one DP1 and Month in another DP2
they get linked automatically. i.e. a Join is created
between the two. If the name is not same then we need to
link them in Data Manager.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sateesh
we have to take two data providers dp1,dp2
first we have to do in webi report
eg in our database emp,dept we have generate two
connections and export it
then
take dp1 ename,dept,sal then run query
after u can click edit query option then u click on
addquery then in the screen appers dilog box with 3 options
in that u have to select any option like 2nd onr then
click ok query2 ename,dept.com then run it
then
in that report panel insert one column then drag and drop
another measure comm
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shiva shankar sheela
you can create different universe for different sources and
link them in BO.
| Is This Answer Correct ? | 1 Yes | 6 No |
What is Cartesian product?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
Tell me about linked universe ?
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
can anybody tell me how many classes where there and objects in each class
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
Can anybody explain breifly about 5 tier's of BOXIR3. 1. Client tier 2. Application Tier 3. Intelligence Tier 4. Processing Tier 5. Data Tier
what is universe testing(not mention check integrity)
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,