very slow performance of cube analysis

hardik_982 · 2007 04

i have database oracle 9.2.0.1 and birt 2.2
i have created view in oracle for geting efficient data from no. of diffrent tables with group by fuctions,now i made cube from this view with dimesions,mesures,
when i trying to preview report with crosstab of this cube it takes 25 minutes
because i have more than 24 lakhs records
please help me to increase efficiency of my project
is there any another option?

rmurphy · 2007 04

How many groups and measures to you have in your crosstab? When you say 24 lakhs, is that equal to 2.4 million (2,400,000)? Have you tried this with BIRT 2.2.1?

Rob

hardik_982 · 2007 06

thanks 
 
 
i have tables like branch,sales executive,distributor,retailer in one schema 
which can be used as one dimension in BIRT cube 
i have another two tables brand and item which can used as dimension item in BIRT cube 
 
now i have have three another table which is used to gate bill_date,qty and 
another measures from diffrent schema, 
now instead of using different tables and diffrent schema in BIRT 
i am creating a view with group by option which 
contains my all fields which can be used in birt 
in BIRT i simply select this view in data set and create my cube with three dimesions like chanel,product and time and try to use in cross tab 
 
my view conatains more than 1,50,000 records and when i try to preview this report it takes more than 1 hour ,what is issue? 
how can i resolved this ? 
is there any option to use materialized view creted in oracle 9i?

manan · 2007 08

Hi , I think BIRT also uses java applets for Cube viewing as Actuate cube Designer. The Recommended size for data used in the Cube Designer was 5 MB, exceeding which will lead to crash in efficiency.

Also if you are using so many nested subgroups and applying aggregate functions in those, lot of calculation is need to be performed leading to more response time as well.

hewb · 2007 08

<blockquote class='ipsBlockquote' data-author="manan">Hi , I think BIRT also uses java applets for Cube viewing as Actuate cube Designer. The Recommended size for data used in the Cube Designer was 5 MB, exceeding which will lead to crash in efficiency. 
 
 
Also if you are using so many nested subgroups and applying aggregate functions in those, lot of calculation is need to be performed leading to more response time as well.</blockquote>
 
I would like to clarify on this: 
 
BIRT cube has no relationship with the existing Actuate cube designer or Actuate analytics technology. It doesn't use java applets to view the cube data. Actually BIRT 2.2.X doesn't offer the capability for you to perform dynamic data analysis yet. The only way to view the cube data is to add a crosstab in a BIRT report design. 
 
In future releases of Actuate BIRT (most likely in iPortal interactive viewer), we will add the capability for people to perform data analysis on a BIRT cube. The crosstab interactive viewer feature will allow people to perform filtering, sorting, aggregation/calculation, or pivoting on a BIRT cube stored in a report document. iPortal interactive viewer is ajax based, so this feature will be a server-based feature. It will not download the cube to the client side. 
 
-wenbin

hardik_982 · 2007 12

u have told that threre is a future release of acutate i-portal viewer ,i have exact requirements like this
can you told me please the specific time for release of this version
so i decided for wait or not

very slow performance of cube analysis

Comments

Categories