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?

Answer Posted / sourabh gosain

1 - if you have 2 tables in universe and no common column
between them to be joined, you can get the data but that
data will be Cartesian of data.

2 - If you have two universe and no common dimension to
join them , still you can use them on webi. You will get
union of data. You must choose same number of objects and
their data type must be same that way u can use 2 universe.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

898


Explain the difference between union and group?

821


What we need to discuss with designer before starting the universe designing.

2023


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?

3319


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3548


What is the profile and package?

2055


What is the difference between absolute and relative div positioning?

777


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

765


Difference between b.o 5.1 and 6.1b?

873


what are the tables used in health care domain project and columns used in report?

4246


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.

2155


What is the functional & architectural differences between business objects and web intelligence reports?

2136


Explain about a tricky situation for which you found a very simple solution?

748


Explain how to execute the plsql procedure from the report by clicking with mouse?

802


Explain what are the steps to do to use alerts in bo?

796