system
April 12, 2011, 9:42am
#1
Hi all,
I am new to BO.We have created a universe on DB2 (Non-SAP database) and created some webi reports.
But the problem is the performance is very low.It is taking nearly 10 min to run the report.
Can any one help me to find out the root cause for the problem.
It would be greatefull if you could provide me any links related to this reporting on DB2 database.
Thank you
kencha (BOB member since 2010-05-11)
system
April 12, 2011, 8:45pm
#2
Cross post ! you have posted in various sections.
Hi All,
Greatings for the Day!!!
We are using BOXI3.0 and database is SQL Server 2008.
we have one Executive report which have 9 millions of records.So my user wants it to run in 30 seconds.
We are tried with all possible ways like
In Database Created new database with proper indexes and created Aggregate tables.
Created Universe using aggregate tables.still query is running for 10 mins.
Can anyone suggest me that is there any other possibilities to get results with in 30 secs.
Thanks inโฆ
Bhargava Ram (BOB member since 2005-09-27)
system
April 12, 2011, 8:49pm
#3
Please do not cross-post . It leads to fragmented discussions and is against our forum rules. Carry on here . This topic is closed.
You can always report a post using the proper icon, found on the lower right-hand corner of any post so we the moderators will not skip attending the cross posts.
Jansi (BOB member since 2008-05-12)