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 is Cartesian product?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
what is the syntax for aggregate awareness?
3 Answers Exilant, i-Tree, Wipro,
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
what r the disadvanges in boxir2
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.
what is xcelsius architecture?
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?
How do you restrict access to rows of a database?