very slow performance of cube analysis

hardik_982hardik_982 Junior Member
edited December 31, 1969 in Designing Analytics Reports
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?

Comments

  • edited December 31, 1969
    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_982hardik_982 Junior Member
    edited December 31, 1969
    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?
  • mananmanan Junior Member
    edited December 31, 1969
    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.
  • hewbhewb Junior Member
    edited December 31, 1969

    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.




    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_982hardik_982 Junior Member
    edited December 31, 1969
    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
Sign In or Register to comment.