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 |
What we need to discuss with designer before starting the universe designing.
WHAT IS SYNCHRONIZATION IN BOXI?
how to overcome overflow of data in a report
can we cretae views in universe level?
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
What is the use of AFD? Where it can be stored?
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?
Analysis in business objects?
what is crosstab reporting,slice and dise and drill mode??
What is the difference between business requirement document and use case document.
can i use stored procedure in webi?
can anybody tell me about complicated object you have created