Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Performance Issue in Drill Thru Reports

Status
Not open for further replies.
JDipen

JDipen

Technical User
Sep 15, 2002
3
IN
Hi,

I have created a cube that drills down to Impromptu Web Reports.
It takes around 1.5 to 2 minutes to generate the Impromtu Report in pdf or excel format.
Need to improve the performance.....
Please provide tips.....

Thanks.
 
Sort by date Sort by votes
Did you check the SQL behind the IWR report and tuned it? Usually the drill through Queries are dynamic where clause, try to get the Dimensions indexed int eh database to get better performance.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

NicolaTesla1
  • Locked
  • Question
Hi, Anyone has ever had issues w
Replies
0
Views
131
NicolaTesla1
NicolaTesla1
tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
158
tushargaurav
tushargaurav
sreevp2020
  • Locked
  • Question
Cross tab intersection drill through
Replies
0
Views
132
sreevp2020
sreevp2020
Emperatriz Stredel
  • Locked
  • Question
Two Cognos reports with two Models (Framework Manager)
Replies
0
Views
145
Emperatriz Stredel
Emperatriz Stredel
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
131
deborahyr63
deborahyr63

Part and Inventory Search

Sponsor

Back
Top