Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
processing probelm
404040
hi...<br />
<br />
while am filtering in cascading parameter it will take long time to filter....and showing a <strong class='bbc'>"processing wait"</strong> fro such time<br />
<br />
how can avoid i long time...and processing wait....<br />
<br />
i have attached a screenshot for u r reference<br />
<br />
kindly reply for this post....<br />
<br />
<br />
thank u...
Find more posts tagged with
Comments
kclark
What is the wait time you are getting? Can you post your query?
404040
thank u for reply here is my query
select distinct
COUNTRY_NAME,
ZONE_NAME,
STATE_NAME,
CITY_NAME,
AREA_MANAGER,
OUTLET_NAME,
TRAN_DATE,
ROUND (nvl(sum(WALKIN_WITHOUT_CGROUP),0)/ COUNT(*),2)APC,
ROUND((nvl(SUM(SALES_VALUE),0)+nvl(sum(total_sales),0)-nvl(sum(net_sales),0)+nvl(sum(discount),0))/nvl(sum(BILLS_WITHOUT_CGROUP),0))ASPB,
ROUND((nvl(SUM(SALES_VALUE),0)+nvl(sum(total_sales),0)-nvl(sum(net_sales),0)+nvl(sum(discount),0))/COUNT(*),2) ASPD,
nvl(sum(BILLS_WITHOUT_CGROUP),0) Bill,
trunc(nvl(SUM(SALES_VALUE),0)+nvl(sum(total_sales),0)-nvl(sum(net_sales),0)+nvl(sum(discount),0)) Sale,
nvl(sum(WALKIN_WITHOUT_CGROUP),0) WALKINS
from OUTLET_PAYMODE_REPORT_FACT A,OUTLET_DETAILS B
WHERE A.OUTLET_ID=B.OUTLET_ID and SALES_VALUE>0
and TRAN_DATE between '20-mar-2013' and '25-mar-2013'
sometime it will take 2-3 min to filter and some time it wil be hang as its
....
just give some idea to avoid it....
thank u
