Analytics
Analytics applications that use Magellan BI & Reporting (OpenText iHub, iServer, or Eclipse BIRT runtime)
-
BIRT: Combining results from two tables or cubes
Hello, My report scenario, I have two tables getting data from same database but can't use same sql statement and need to check if the first column in each table is the same, then put them in the third table with their accumulated costs. The below screenshot explains my scenario clearly. _
-
Export BIRT report to xlsx format in single page
We have deployed BIRT report in IBM Tririga application and enable option to export BIRT report to xlsx. We set pageBreakInterval=0 to avoid pagination. But Each page is taking 10000 records per page. When we export BIRT report to xls, it works fine but for xlsx format, after 10000 records next records appear on new sheet.…
-
How to use IN operator in Like operator using actuate birt
Hello Team, Good day! Can anyone please tell me how to use IN operator in LIKE. Thanks in advance. Regards, Sai
-
Show Data in One Excel (XLSX) Tab
<p><span style="color:rgb(0,0,0);font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">Hi,</span><br><br><span style="color:rgb(0,0,0);font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial,…
-
Java-heap issue while exporting a BIRT report in excel using v4.5
Hi Guys, I am facing issue while exporting a BIRT report in excel using v4.5. For a report with 40 columns and .5m records it consumes like 40gb of memory which eventually causes java heap error. Now i know BIRT used spudsoft emitter for generating excel and I read that…
-
Birt Designer on macOS Big Sur
Hi, It's possible to install Birt Designer on new macOS Big Sur? How to? Thanks
-
A simple percentage question
Can anyone please tell me how to describe numberformat for percentage correctly ? My script says : if (this.getRowData().getColumnValue("UnitName")=='Percentage'){ this.getStyle().numberFormat = "###,##0%";} but the data from my dataset : 80,00 this way results in : 8.000% instead of 80% thanks, Bea
-
Multiply data in Row
Hello All , Need help/ suggestion/ advise on this problem I have this requirement to multiply all the data in the row and show the total at the end in table. Here r(1) is row 1 of table and so on. The row can increase and decrease. I am open to idea of changing how data comes to solve this r(1) 2 r(2) 3 r(3) 5 Total : 30…
-
Change/Rotate Text Direction in Birt Grid/Table/Crosstab using Labels or Text Item
Dear Folks, I am just wandering around the internet to look for a very simple solution to change/rotate the text direction in Birt Grid and achieve the result illustrated below, though it seems very simple yet I couldn't find any workable solution to achieve this result.
-
How to add a horizontal line to a bar chart?
Quick question that's been stumping me. I'm displaying some data in a stacked bar chart, where the total height of the stack should be compared to a target value. How can I draw a horizontal line on the chart to represent that target? Thanks, Chris
-
Confusing error info in org.eclipse.birt.core.framework.jar.ServicePlatform.getExtensionRegistry
Eclipse2019-12 BIRT 4.8.0-20180626 - We have a test setup that runs the following snippet to get the factory to create a report-engine but we cannot get past a classloader error in rg.eclipse.birt.core.framework.jar.ServicePlatform.getExtensionRegistry. Can someone advice on how to resolve this error. See below for couple…
-
BDA Crosstab created in 16.4 is not working in 16.7
I have a crosstab which was created with BDA version 16.4 and now upgraded BDA to 16.7. when ever i try to open and the crosstab in BDA then i am getting "Incorrect version or crosstab cache type" error. below is the electron.log 20200916 17:15:55.625 INFO…
-
how to embed a video in a report
<p>Hi, embedding a video in a dashboard is easy using the provided video gadget, but we would like to embed a video in a report.</p> <p>Our reports are served from a secure site and accessed through a dashboard.</p> <p>Vimeo provides users with embed codes (using iframes), but these do not seem to work in the structure we…
-
How to change the host name in CVS Respository using Actuate BIRT
Hello Team, Can anyone of you please tell me - 'How to change the host name in CVS Respository using Actuate BIRT'. I need to change the Host name so then I can commit my reports in CVS. I am struggling to fix this. Please help me. Thanks, Sai
-
What is meant by Integration Developer?
Hello team, Good day! Can anyone you please tell me what is the difference between Integration Developer and BI developer. What type of tasks does the Integration Developer do. Thanks in Advance. Regards, Sai
-
Edit Parameter Window on server
Hello everyone, I'm using Birt Version: Neon Release (4.6.0). What options are there to change the content in the parameters window (the inscription Parameters marked with * are required) if I upload a report to the server? I cannot influence Birt Viewer.
-
Job
My apologies in advance and please remove this post if this is not allowed here. I was laid off in June and I'm looking for a new position. I have 20 years of experience using Actuate erdPro and BIRT (Both development and administration). Please contact me at ejdjap111@gmail.com if you know of any open positions.
-
Dynamically controlling visibility
Hello, I have reports with a table and a chart. Chart is hidden by default in "HTML" output because I'm using some flash based component. However, in some cases, even in HTML, I would like to be able to display the chart. Is it possible to control it dynamically from JavaScript of the rendering engine? Thanks,
-
Parameter validation error and warning messages?
<p>Hi,</p> <p> </p> <p>I have a report that has a start and end date parameter. I want to do the following validations</p> <p> </p> <p>1) If start date is null and end date is some selected date ( or otherwise), show error message that either both should be nulls or both should be a selected date..(in case of start date…
-
Hyper link BIRT report is not loading in TRIRIGA 3.5.1
When I import the Hyperlink Report in TRIRIGA using the document manager, then the detail report is displaying the Blank page but the master is running fine. Note: The BIRT reports are built on SQL Queries. Can anyone have any idea about this issue that how to import the hyperlink birt reports in TRIRIGA?