Business Objects - my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time

GeekInterview.com > Interview Questions > Data Warehousing > Business Objects

Go To First | Previous Question | Next Question

Business Objects | Question 15 of 233

my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?

Total Answers and Comments: 10

Last Update: July 01, 2008 Asked by: Reddeppa

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 22, 2006 18:15:50

kts

RE: my query takes 30 min to refresh ...there is any p...

- make sure to have the right context

- apply right indexes on the tables

Is this answer useful? Yes | No

April 08, 2007 09:57:34

Sandeep Dudhane

RE: my query takes 30 min to refresh ...there is any p...

There are various strategies like creating indexes to the columns, creating aggregate tables, creating filters (usually on date columns)

Is this answer useful? Yes | No

July 01, 2007 10:27:31

jay jaiswal

RE: my query takes 30 min to refresh ...there is any p...

You can partition the table, create proper indexes on that column,
You can define key type in Object Definition,
Use aggregate Awareness.

Is this answer useful? Yes | No

August 07, 2007 01:04:40

Tilak kumar

RE: my query takes 30 min to refresh ...there is any p...

1) Frequently used tables only you need to create the indexes.
2) Partioning the tables
3) Reduce the user defined objects
4) Always use the conditions, avoid string concatenations.

Is this answer useful? Yes | No

October 25, 2007 11:17:39

Balaji

RE: my query takes 30 min to refresh ...there is any p...

do not use more then one sub-query for the single report..this would help you in access the report faster

Is this answer useful? Yes | No

December 19, 2007 22:26:07

ravi_kumar_garre

Member Since: November 2007 Contribution: 33

RE: my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?

Make sure the following along with those specified our friends.
Use of possible short cut joins.
Cheers,
Ravi Kumar Garre
Phone: +91-9820350246

Is this answer useful? Yes | No

January 31, 2008 22:26:16

sreya_1234

Member Since: November 2007 Contribution: 15

RE: my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?

Make sure
1) you do not have traps in the universe.
2) use the right context
3) avoid morethan one sub query in the query panel

Is this answer useful? Yes | No

April 23, 2008 10:16:32

rahul07

Member Since: April 2008 Contribution: 4

RE: my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?

1) check for any traps in the universe.
2) use the right context
3) avoid morethan one sub query in the query panel
4) use right context
5) right index on the table
6) partion the table
7) use conditons
8) avoid user defined objects

Is this answer useful? Yes | No

May 02, 2008 02:26:36

abdul123

Member Since: May 2008 Contribution: 1

RE: my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?

Avoid too much of Report level formulae.

Is this answer useful? Yes | No

July 01, 2008 08:52:17

#10

sreenivas27

Member Since: November 2007 Contribution: 1

RE: my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?

Hi

First you have check your report format i.e filters,conditons, graphics, sorts, ranks....

mainly these you have check so that you can decided which option u can use better....

so that you can easily tune your query performance.

Regards,

Sreenivas.

Is this answer useful? Yes | No

Go To Top