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
When to use local filter and when to use global filter?
What would you consider as your biggest achievement and why?
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?
Difference between b.o 5.1 and 6.1b?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
any difficulitis have you phase while creating bo reports and how did u solve it
What is the dense rank?
Explain what would you consider as your biggest achievement and why?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain about a time when you discovered a more efficient way to do a work task?
What is the difference in creating filters in designer and business objects?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
How to restrict password to a user while sending a document in .pdf format
Explain what sort of existing documents should business analysts refer to when starting on a new project?
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?