<p>Hi All,</p>
<p> </p>
<p>I am converting a set of 70+ reports, already developed in other BI tools, into BIRT 4.4.2.</p>
<p> </p>
<p>I have attached a screenshot of my data model. The data model has close to 60 dimension tables, 10 snowflake tables and 1 fact table. (<em>Screenshot has fewer components as it just gives a picture of how the model looks like</em>)</p>
<p> </p>
<p>I have tried creating a sample report with 4 measures and 8 dimensions and it works fine. The reports comes within 5 secs. But now, I am unable to expand it. (<em>Report design attached</em>)</p>
<p> </p>
<p><strong>I need to now add the remaining dimensions.</strong> All these dimension will be available to the user as parameter inputs. I have tried creating separate datasets, tried writing custom sql query, tried creating joint data sets etc., but all effort goes for a toss as the report is not running at all.</p>
<p> </p>
<p>Any thoughts/ideas aound the designing part will be highly appreciated.</p>
<p> </p>
<p>Best Regards</p>
