nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Provide some tips to increase crosstab performance

rockjava123 · 2013-09-12T08:37:28+00:00

hi i am using BIRT 3.7 verison We have created crosstabs as part of reports , but it is taking very longer time to render it. please give me some suggestions on how to render very quicky. Advanced Thanks

rockjava123

hi i am using BIRT 3.7 verison We have created crosstabs as part of reports , but it is taking very longer time to render it. please give me some suggestions on how to render very quicky. Advanced Thanks

Find more posts tagged with

Comments

mwilliams

How much data are you processing for this crosstab? Are you using a SQL dataset where you could do some of the grouping at the dataset level rather than forcing BIRT to do it? This would probably speed things up.

CBR

Hi, most time is spent on creating the data cube. The biggest performance improvement can be achieved by grouping the data on the database site. There is a checkbox in the create data cube dialog that can be checked if you are already provide grouped data in the cubes dataset

CBR

Oh sorry missed mwilliams post

rockjava123

hi williams, Thankyou for Quick reply i am doning grouing in BIRT data cube level only, other than that any other factors are there to improve rendering performance.

mwilliams

Number of levels in your cube and the amount of data that you're aggregating would contribute most to the time. If you can't do your grouping in your dataset, you could always consider limiting the rows/grouping levels returned in your initial report and allowing your users to drill down to a more detailed report that they can expect will take longer to produce. Like cbrell said, most of the time will be spent on the grouping in the data cube. If you can group before the cube gets the data and check the box, that's where you'll find the biggest boost in performance.