CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Answers were Sorted based on User's Feedback
Answer / pers
Definitely its not possible to use more than one database
connection to a single universe
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / swades
you can a single database connection to a universe
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ranu
in my openion yes we can do this,....
using linked universe concept.
suppose we hv univ A connected to database Da
univ B conn to Db
univ C conn to Dc
now we can create univ E wiich is linked to univ A,B ,C.
correct me if i would be wrong......
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sivakumar.v
The Various data source are:
Universe
Free-Hand SQL/
Stored procedures
OLAP servers
Personal data files
VB procedures
Any number of data Source can be linked by common dimensions
Features of Dimensiion:
The dimension objects do not have to have the same name
(e.g. Person, Person Name)
Only dimension objects can be linked (e.g. Person
Name,Encounter Type,etc..)
The dimension objects must have a common data format (e.g.
character, numeric, etc.)
Common values must be in the same case etc..
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / mithru
yeahwe can have universe conn to more than one data
base....how we can can achieve is creating the db link
between two data bases and then conn universe two any of
the db
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / shaik.emambasha
yes we can linked to more than one data source
| Is This Answer Correct ? | 2 Yes | 9 No |
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Report have 10000 records,how to restrict the end user to 1000 Records?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What is a join? Explain different types of joins?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
In banking domain how many Fact tables,Dimension table are present?
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
Explain the BO Developer WORK FLOW?
what is meant by scorecards?
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
how to restrict null values in webi report?