Analytics
Analytics applications that use Magellan BI & Reporting (OpenText iHub, iServer, or Eclipse BIRT runtime)
-
Sorting repeater on Storyteller by numeric - Encountered NaN value
Hi all. I set a numeric sort order on a field of a repeating block. During testing I get the error: "Numeric sort with XPath 'field_name' encountered NaN value ''." If I set the sorting as Text type it works instead. In XMLIN I didn't initially set any function or format for that field. Even if I set the number(.) function…
-
What is SAP Business One used for?
What is the role of ?
-
Birt with NETSUITE
<p>Hi everybody,</p> <p> </p> <p>Can anybody help me? someone had worked with birt and Netsuite integration?</p> <p> </p> <p>I can find a Jar to conect my database .</p> <p> </p> <p>Thanks</p>
-
Unsupported major.minor version 52.0 in dfc code
Hi, We are getting below error message while uploading documents in repo using the dfc 7.2 code. Exception in thread "main" java.lang.UnsupportedClassVersionError: com/documentum/mailapp/operations/inbound/DfSeparateAttachments : Unsupported major.minor version 52.0 at java.lang.ClassLoader.defineClass1(Native Method) at…
-
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…
-
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.…
-
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?
<p>Hi,</p> <p> 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…
-
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 external CSS programmatically
<p style="font-size:15px;font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;">Hi,</p> <p style="font-size:15px;font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;">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
<p>I am using iHub trial version and I am currently having an issue with some reports only when I run them on "schedule".</p> <p>I have run the same reports using "Run" and they came out perfectly with no errors. </p> <p> </p> <p>There seems to be a connection problem when the dataset is being generated.</p> <p>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
<p>I have a Date which I retrieve as a string "Dec 20 2007" from my front end app and insert into a BIRT table.</p> <p> </p> <p>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. </p> <p> </p> <p>My ultimate goal is to sort the table…