Intelligence (Analytics)

Analytics applications that use Magellan BI & Reporting

Excel sheet contains 1 data column as merged cells after exporting BIRT report.
Hi, Could anyone please how to avoice merging cells in excel after exporting BIRT report. Thanks, Sai Krishna
Magellan BI& Reporting CE 22.4 - iHub failed to generate the reports which contains 84K+ records
iHub report is unable to generate the results if the report contains more than 84K+ recorders And in the report it shows 700+ sheets but not updating.
How to use external font families in BIRT Reports?
Hi, I'm using BIRT version 4.5.0. I want to use some specific font families (more specifically 'Open Sans') in reports. In the mentioned version of BIRT is supported few font families only and also I'm not able to add external font families by API and also by design. Is any APIs or JAR files available to handle…
Using external CSS programmatically
Hi, I want to use an external css when executing the BIRT report via a Java application. I've come along with a few articles (e.g. <a…
New parameter change in existing report getting the invalid dataset column issue
Hi All, I am currently facing the nvalid dataset column issue, after interduce the new parameter in report using analytics designer and trying to publish in iportal and schedule the report, while scheduling the report the below issue is popping up. There is an error in processing your request. Error code:…
An error occurred when executing the report.
Dear all, i'm new to BIRT. Our company is trying out the Actuate BIRT Designer Professional version 11.0.4. trial version. We have just install in 2 pc and accessing AS400 db2 database using JDBC connection (JT400) and do some simple report for a start. In the beginning, all went well but within just few hours and we are…
Data set issues only on scheduled jobs
I am using iHub trial version and I am currently having an issue with some reports only when I run them on "schedule". I have run the same reports using "Run" and they came out perfectly with no errors. There seems to be a connection problem when the dataset is being generated. The dataset…
Repeat a BIRT Grid on every page.
Hi All, I need help in solving a design problem. In LAYOUT section, I created a Grid with 2 columns. In first column I added TABLE to loop elements, in second column i used GRID to display Car info. When I generate PDF, TRABLE get dynamically expands to multiple pages, BUT GRID only Shows in first page, Is there any way I…
Numeric data type is lost after exporting to Excel
We are developing an ERP application and for the Reporting component we are using open source BIRT report engine & open source BIRT designer tool; however we are facing a miss functionality after exporting an excel formatted file that includes numeric data type. The problem arise after exporting an excel sheet as the…
Magellan Bi & Reporting - iHub 22.4 report's Export to excel gives wrong values to the Decimal field
Hi Team, I am using MDD & Magellan Bi & Reporting 22.4 and trying to export the report output into Excel. All decimal values shows wrongly in the excel file. if click on the specific value in the excel it shows the correct values in the formula. How handle this issue? Original report values Excel Values Value in the Excel…
LmsSystemtechnology
Sussessfully .........
OpenText Magellan BI & Reporting iHub – Performance degradation with CPU and memory usage increasing
Good day to you everyone. In OpenText Magellan BI & Reporting(iHub), after couple of days depending on the usage, the process starts using an increasing amount of RAM and CPU until it uses all the available CPU and causes severe performance degradation on the usage of iHub and the Online report generation. A restart of…
Convert string with date text to date format in BIRT table
I have a Date which I retrieve as a string "Dec 20 2007" from my front end app and insert into a BIRT table. Since the data type for this field is set as "Type: String" when I convert it to Date the table breaks and no data is visible in the Table. My ultimate goal is to sort the table…
The requested resource [/birt-viewer-osgi/frameset] is not available
I am new to birt reporting tool. I am trying to setup birt rum time on RockyLinux 8.8 BIRT Viewer Version: 4.9.0 BIRT Engine Version: 4.9.0 Java Version 11.0.19 welcome page displays fine but when I click on the view example link it shows an error like frameset is not available. I have checked the required permissions on…
BIRT, training/basics to get started?
New to BIRT report writing: stumbling through on my own. Wondering what kind of basics trainings (even just YouTube or LinkedIn learning, etc) or cheatsheets you all use. So far the trainings I have found all assume I've got understanding of writing in programming language but I don't. I am a very quick study, just need to…
BIRT / eclipse
HI All, I have been trying to install BIRT from Eclipse website but not of the versions I install work on my MacBook OS Montery, most of the error says download not supported or invalid file but I managed to download a version " eclipse-reporting-photon-R-macosx-cocoa-x86_64" that downloads but when I come to open the…
BIRT JDBC ResultSet Error using Stored Proc with MariaDB
Hi. We're trying to create a BIRT report Data Set in Eclipse, with a result set from a stored proc, using a MariaDB database and Java/JDBC driver. Using the following query syntax: {call sp_fetch_data(?,?)} This worked with an earlier MariaDB client version (1.5.9), but with newer versions (I've tried 2.0.3 and 2.7.1), it…
Using Magellan BI and Reporting platform with a Fast Object Storage product
I am looking for any documentation for any and all products that might support an external 3rd party Fast Object Storage as the primary storage. This would be an all flash system and looking for architecture diagrams, requirements needed for the object storage (features and speed requirements, networking requirements,…
BIRT Windows 10 / IE 11
Hello, I am new to the BIRT world. I need to use BIRT to create custom reports for SuccessFactors Learning (Previously Plateau Learning Management System). My question is about installing BIRT and issues with response time. 1. Can BIRT run in a Windows 10 / IE 11 environment. If yes, what version…
Action on click and double click?
When adding interactivity to a chart Birt allows you to define actions for a mouse click and a double click. I have setup different hyperlinks for the 'click' and 'double click'. However when I view the report only the 'click' hyperlink' works. The 'double click' isn't recognised it just goes to the 'click' hyperlink. Any…