Home > Default > BW report running slow

BW report running slow

November 30Hits:0
Advertisement
Hi,
We have reports build on one multicube and its is running very slow ..after entering selction paarameters it keeps running for long time even when i am running for one cal year/month but earlier it was running fine
we have compressed req of cubes which are in this MP
and moreover we have other reports also based on same MP they are running ok only problem with 1 report
can anyone pls tell what to check for ?also i tried executing in web same report there also it took lot of time
any quick helpa pprecaited
thanks
nilesh

Answers

I faced a similar issue once. Upon investigating the execution plan, i found that the query was reading 0VENDOR Text multiple times because we had 4 or 5 different vendor partners displaying text. We moved those vendor partners into free characteristics and asked the users to drill down by those partners as needed instead of having it in the initial report view.
We also had an issue with reading UOM conversion tables and currency conversion tables at query run time. One query which did not use those conversion tables ran fine but one query which used those conversion tables on the same info provider was running real slow. We then moved the calculation in the transformations and then the report ran much faster.
These are couple of things i have noticed on my reports that were running slow.
You can run RSRT in debug mode. Select Query execution plan and Query Statistics. Both of these will give you wonderful insights into what really is happening when the query is executed.
The query statistics will tell you how many fact table records were actually read. The Query execution plan will tell you each table that is being accessed by your query.
Good Luck.
MP.

Read other 7 answers

Tags:

Related Articles

  • Strange problem... Query runs faster, but report runs slow...November 30

    Hi Gurus, We are using Report 10g on 10g Application server and solaris. we created a report on a table which has 10,000 rows. The report has 25 columns. when we run this query in Toad it took 12 sec for fetching all these 10,000 rows But when we run

  • SSRS reports running slow while fetching data from SQL server DBOctober 11

    We are currently facing issues with lots of our SSRS reports running very slow. Approx they are taking around 15-20 minutes compared to earlier which was 2-3 minutes. Also, the SSRS reports which fetch their data from a Database is acting as Subscrib

  • Oracle 10g Reports running slowNovember 30

    On one server we have an issue with some reports of 2pages taking 2 minutes or more to run, but on another server with the same data transferred across the same report runs in about 3-5 seconds. The reports we are having issues with contain graphs. T

  • Reports running slowNovember 30

    Hi All, I am struggling with this issue that reports are running slow & it is taking few minutes to execute. In BEx Analyzer it is running slow. Please tell me reason why this can happen & possible solution. Thanks.Hi, For the query in BEx we can

  • Financial Reporting batch reports run slow at randomNovember 30

    FR reports version: 11.1.2.1 This is a summary of our environment: -Linux server where Hyperion batch reports run -Linux (SLES-11) server where Essbase resides -Windows 2008 server where Hyperion Print Service and GhostScript reside This is what we o

  • BW report running slowNovember 30

    Hi, We have reports build on one multicube and its is running very slow ..after entering selction paarameters it keeps running for long time even when i am running for one cal year/month but earlier it was running fine we have compressed req of cubes

  • APEX report running slowNovember 30

    Hi the following query runs slow in APEX (:P10_start_date => 01-sep-08, :P10_end_date=>10-sep-08) but in pl/sql developer it takes a second only (11g, APEX 3.1.1) any suggestions select /*+ index (jane_don pre_test_idx)*/ stud_mode, stud_nr, test_nr

  • Web discoverer report run slow after upgrade to AS10.1.2.48.18October 11

    We just upgraded our application server to 10.1.2.48.18, our web Discoverer report were running extremly slow on tables that contain large amount of data. We have good speed with those report in the past. The backgroud database was the same as well a

  • Customized Reports running slow in PRD system.October 11

    Dear all, All the zreports in our PRD system(900) is running very slow recently. Simple customized reports which used to and should take very less time are taking more than 10 mins. for execution. Some customized reports are not getting excecuted eve

  • First report run slow...then reasonable.November 30

    I'll call it a performance issue for lack of a better description.  I am accessing an .rpt file on the Crystal Enterprise server and then accessing it using java.  It works fine...after the first run of the day.  The first run takes up to 2 minutes..

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.785 s.