Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nitish
A table is joining to itself is called as a self join let us take an example of there is a table emp and dept, the user want to analyse the report how many employees are working in a particular dept
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Did you face any problems while creating reports? Name? Solutions?
Explain how we drill up week to month?
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!!!
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What sort of existing documents should business analysts refer to when starting on a new project?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What is report template in b.o?
Explain what are the steps to be taken to schedule the report?
Can we Save (save as) WEBI Doc as DESKI?
what are the tables used in health care domain project and columns used in report?
What is the difference between condition & filter?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
how to create reports on screech?
Which versions are used in the bo dashboard work?
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...
