Analytics

Analytics applications that use Magellan BI & Reporting (OpenText iHub, iServer, or Eclipse BIRT runtime)

Different headers in BIRT report
Hi! I would like using different headers on the first page and the others. On the MastePage I placed a grid with 2 rows. In the 2 rows I placed 1-1 other grid with a simple label. On these grid's OnPrepare event I wrote a little script, wich depend on then pageNumber variable set the grids "display" attribute value. But it…
Magellan OpenText deployment on generated VM, can't get node details in deployer
I've created a template instance of OpenText v24.3, and I can access the base instance (used for creating the template) just fine. However, with the new instance created from the template, I can have the deployment/installation program connect to it, at least enough to get the instance name. However, when I open the…
how to configure OTDS Oauth2 to use on JSAPI authentication viewer.
OTDS version 22.4, Ihub version 16.7 The purpose is to get a token automaticately (Oauth2 probably) to set the credential of the JSAPI configuration, to view some rptdesign. Since the implementation of OKTA authentication with SAML, i have to define the credentials for the connexion : var extOTCredentials ="TOKEN VALID";…
QR Code in Magellan Analytics Designer
Is there a way to create a QR code in Magellan Analytics Designer that would open a link?
Change the color of row based on multiple data in BIRT Report
We have a BIRT report that would run on one or multiple records and display the output. For example if the report has ran for 3 records then the report will display output in 3 pages (1 record per page). We need to change the color of a row based on the status field as mentioned below, Record Part Number Status Color One…
Add 'WOFF' file to my BIRT Report
Hi, Im trying to use custom fonts defined in WOFF file in my BIRT report, Can you please help here how can I able to use in my reports? Im using BIRT Runtime 4.8.0. Thanks, Kiran
Using the output of one dataset as parameters to another dataset in a chain
In BIRT, how can we use the result set of one dataset as parameters to another dataset? I'm not refering to dynamic report parameters (where the user selects between results from a query). I want to chain together datasets from different data sources. How can I use the output of a MySQL dataset to parameterize a query…
Execute a query in beforeOpen and pass the output as a variable in open method in BIRT Report
I need to execute a query like ( SELECT column1 FROM table 1WHERE column2='ABC 'AND id = '1234859') . The output of this query will be 'X2224891', 'Y2839120' . I need to pass this output as a variable to the main query written in the open method. Is this possible to do it in the beforeOpen or any other way to achieve this?
Maximo Doclinks within BIRT Report
Is is possible to create a report that embeds doclinks within it? What I would like is to create a report which has work order details at the…
How to compare current row value and next row value in a column using Magellan
Hi Team, I am working on a Magellan report which contains a column with the following logic: If( Next(col1)!=col1 ) { Result. } Here it was comparing the current row value in column(col1) with next row value in that same column. How to write this logic in Magellan using javascript. I got strucked on this task from 1 week.…
How to delete corrupt server profile in OpenText Analytics Designer
Where are the local server profiles located? I would like to delete it.
To backup database of existing server and use in docker image
Hi Team, We are trying to use docker container and move the report server from EC2 to AWS ECS. server version we are using : RS4.1.0-6064 (2022-06-09-12-24-17) We are able to create a docker image but not able to back up existing database. We would like to understand the commands or steps to take current database back up…
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…