Interested to Buy Any Domain ? << Click Here >> for more details...
how to increase the perfomance in ur designer & reporting?
how to reduce the refershing time & what precations would u
take ?
- 3 Answers
- 8468 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ashish
1. Increase array fetch size.
2. Use Bit map indexing on Fact columns.
3. Remove unwanted objects and classes from your universe.
4. Remove unwanted variables, filters and charts from report
5. Always ensure your fact table execute before your
dimensional table in the FROM clause (Query optimization)
ex. Select F1.A
D1.B
FROM
Fact F1,
Dim D1
6. Use of Derived Tables so that complex calculation can be
performed at universe level.
7. Aggregate table
8. Remove unwanted alias and context.
9. Always ensure in join condition you have fact table
appearing at LHS. (F1.A=D1.B)
10. For prompts related columns, have indexing done at DB
level
11. Also at universe level you can change row count for
table rows for SQL execution as per requirements.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
In banking domain how many Fact tables,Dimension table are present?
What is the difference between condition & filter?
Explain about a task that really tested your analytical abilities?
Explain what task is 98% of the required work of a business analyst?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Is there any other repository domains rather than universe, security, document?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain which versions are used in the bo dashboard work?
What is thumbnail?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
How to restrict password to a user while sending a document in .pdf format
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
How were the reports scheduled and how to resolve unexecuted documents?
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!!!
