Answer Posted / s.kumanan
By pass the intermediate tables and give the altenate path
between the two tables is called shortcut join.
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
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?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Can we configure two instances of CMS pointing to two different CMS system databases?
What task is 98% of the required work of a business analyst?
How can you first report in Business Objects by using broadcast agent?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What are the join problems comes appart from loop,chasm & fan Traps
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is the difference between the public object&schema object?
Explain is data mart?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
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?
