Interested to Buy Any Domain ? << Click Here >> for more details...
HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
- 2 Answers
- 5199 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoj
Derived Tables decrease the performance because even if you
include one single object from this table the entire query
from the table is executed .
You can see this in the sql Query panel.
hence i would avoid using any derived tables unless
mandatory
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Which versions are used in the bo dashboard work?
Explain about a tricky situation for which you found a very simple solution?
How to generate the report from excel sheet?
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...
how to prepare the documentation in business objects and where to get the requirement?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
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 ?
How to restrict password to a user while sending a document in .pdf format
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
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 in detail about type 1?
