Recent Posts in My Followed Categories
Switch the "Categories" drop down to see either Recent posts in All categories or only posts in the categories you Follow.
-
Magellan BI and Reporting
I am having issues with my reports displaying on AppWorks. On the Dev and QA environments, the platform service keeps shutting down. In production, the dashboard would show but the report would say "The file type is not supported". Usually when that happens, I stop and restart the cluster in the System Console and it all…
-
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.…
-
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.
-
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…
-
Birt scripting in Dashboard
Is it possible to do scripting in Birt Dahboard, i can see Scripting option in Datasets, but for the dahbaord itself, i dont see any option where i can write by scripts, basically, iam using a report paramter in my Dahboard, and my laoding icon is not showing until the query gets executed, it just appers and disappers, i…
-
Code example for BIRT OTMM
Hi, Iam trying to create Custom reports on OTMM and BIRT, as per OTMM document i see code examples would be available under But i wasnt able to locate, kindly share me the link to locate the code example for BIRT OTMM reporting
-
Spudosoft xlsx emitter occupies more heap space
I have requirement to export the Birt report into xlsx format. I see Birt is using spudosoft emitter for xlsx format. For less records , the export seems to be fine. if there is more records involved, then export takes lot of time and heap space is filled up. But xls export seems to be fine with limited 65 k records. Do we…
-
Does any Magellan components offer to upload .parquet files from HDFS?
I see there are data sources like Hive/sparks to load data, but I cant see any way we can upload hdfs .parquet files directly? I see Flat Files offer url to browse but only csv,.xls,.data but not .parquet?
-
How I can get connection properties on OdaDataSourceHandle
How I can get properties from org.eclipse.birt.report.model.api.OdaDataSourceHandle? if I use REST Data source with predefined connection profile, i want to read properties of connections in report, either in beforeFactory or in datasource beforeOpen etc methods.
-
Localizing row data for PDF TOC
I'm working on a report build where I've got a few tables that have multiple grouping levels. The groups are indicator text (think regulatory report sections) that needs to be localized, so I created all the mappings in a resource properties file for the detail rows which works as expected. However, whenever I try to set…
-
Intermittent Class Loading issues for ScriptedDataSetEventHandler in MBIRT 20.4
We are using ScriptedDataSetEventHandlers for loading data in report elements like table and for dynamic parameters list but with a version upgrade from iHub16.0.1 to MBIRT20.4 there are intermittent issues in loading class for scripted event handlers. Jars which includes the classes for extended…
-
Combining static and dynamic columns in a BIRT report
I'm interested in using a crosstab to combine a a set of dynamic and static columns. A similar question was asked previously at https://forums.opentext.com/forums/developer/discussion/59595/dynamic-columns-in-birt-report but I am unable to see the attachments. The only way I found to do this was to create a multi-level…
-
ihub sys console : Cluster "Platform" and "Monitor" services are not starting up
Hello All, ihub sys console : Cluster "Platform" and "Monitor" services are not starting up. Whenever I am trying to start "Platform" service it is showing following error : 7014: Requested process is already running.Parameter0: ihub whereas monitor service is not starting. I have checked logs…
-
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…
-
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. _
-
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…
-
TeamSite Standard Report Error
Hi, We are using TS 16.6.1 on Linux Environment with PostgreSQL. The TeamSite Standard report was working fine earlier and stopped working now. And getting below errors. We have restarted all services but still getting this error. Error.ReportQueryLoadingError ( 1 time(s) )
detail :…
-
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.
-
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?