Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
script is executing multiple times because of cross tab
Migrateduser
<p>[font="arial, sans-serif;font-size:13px;"]Hi,[/font]</p><div style="font-family:arial, sans-serif;font-size:13px;">my birt report is having a dynamic cross tab.. the script (my sql script) is executing multiple times which i have observed from the log.. i found that the number of times the sql script is hitting database is based on the number of groups in the cross tab</div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">number of times the sql hits the DB == number of groups in the dynamic cross tab</div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">I am using BIRT 3.7 version..</div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">this leads to the delay in the execution of the report..</div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">please provide a solution for this ... <strong>what i exactly want is my sql script will execute only once for the cross tab</strong></div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div><strong>or is there any work around solution to represent the dynamic data by avoiding cross tab/ data cube completely???</strong></div><div style="font-family:arial, sans-serif;font-size:13px;"> </div><div style="font-family:arial, sans-serif;font-size:13px;">thanks in advance</div><div style="font-family:arial, sans-serif;font-size:13px;">Srikar.</div>
Find more posts tagged with
Comments
There are no comments yet