Intelligence (Analytics)

Analytics applications that use Magellan BI & Reporting

jsapi viewer chart submit() works only in same page?
I have some checkbox/ radio button that filters the chart if both this button and chart in same page, chart.submit works and chart filters if I change in two different pages, chart.submit never seems to be happen charts in second page always fresh/ unfiltered?
Creating BIRT Reports on the web
Is there a way to integrate designer into an existing web application so that the users can create on the fly reports using the designer? I know that Birt Report Viewer can be deployed so that reports can be viewed but can we do the same with Report Designer for creating reports? Thanks!
BIRT report to create the csv file and report generation
BIRT report Requirement: I need to create Labor report and display the columns such as (laborcode, startdatetime, finishdatetime, regularhrs,craft etc) with below mentioned 2 parameters and when run the report from Maximo application, the report generates in browser view. At the same time, the CSV file should be generated…
Multi select report parameter
Hi, Does BIRT has check box as report parameter for multi selection? I need requirement as in green below i.e. in green I am able to create Cascading dynamic report parameter that looks like in orange below But, I want to make them as check boxes for Multiple Selection! or can you suggest ay other alternative?
How to suppress FaultRelatedException return in http response
Hi, Would like to check is there a way to suppress Cordys:FaultRelatedException from returning in http response? Our company security scan through and stated that this is a risk for opentext to return exception handling message in http response.
Add BIRT Viewer to a Spring Project
Hello, I'm new to BIRT and I have been successful in running a birt report with data from my spring application. I'm now trying to embed the Viewer in my jsp so that when the report is executed, it's shown to the user in the Birt viewer. Unfortunately, I'm unable to embed the Viewer into my jsp. Could someone please give…
Optional grouping
I'm trying to create a report where the grouping in the report is optional. If a checkbox is ticked, then a grouping should be applied on the table. And if the checkbox is unticked, then there should be no grouping applied, and the data should be presented as a flat table. Here are a couple of approaches that I've…
Unable to pass multi selected values from data selector in dashboard into the report parameter
Multiple values selected on a Data Selector in dashboard, linking to a imported Report's report parameter, is not working. Report parameter takes only the last value selected from the data selector and shows the result on imported report. At report design time, in analytics designer, I've used a multiple values types…
Custom Report Item - Rotate Text
Hello BIRT community, The old version of the custom report item example are under https://www.eclipse.org/articles/article.php?file=Article-BIRT-ExtensionTutorial1/index.html and https://www.eclipse.org/articles/article.php?file=Article-BIRT-ExtensionTutorial2/index.html A new version of it can be found now on github. I…
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
Hi, <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…