Analytics

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

WebSphere to Tomcat 9 - error calling Actuate SOAP API - axis.jar
Hi, I am kind a new at JAVA stuff. We are in the process of switching from WebSphere to Tomcat 9. Currently we used JAVA to call Actuate SOAP API to generate report or set permission on a new report. We are using the Axis.Jar, it works fine in WebSphere but when I try to run it on Tomcat in ECLIPSE it give me an error…
How to create Report using Rest web Service
Hi, I am trying to create report using Rest Web Service. Pls help me Thanks Hamsa
Esc sequence with Troy Printer
I'm trying to use BIRT to print checks on a Troy printer. It has a signature chip that uses a ESC sequence to print the signature and the MICR numbers. Has anyone done anything like this? The signature prints when using the test page they send me. But I can not copy the ESC code…
how to fix optional parameter box
im new to birt tool, i have created 3 parameter box, one is madatory( asterick symbol), others 2 optional (without asterick ), if i give value in first parameter box and click ok ,it should return all data's, without giving 2nd and 3 rd parameter box. anyone please help me
Image DPI
I am having an issue with the quality of the images in my report design. If I change the image dpi for the report, all of the images shrink. Is it possible to change the dpi of an image in my header only but not the rest of the images in the report?
After server upgrade SOAP call fails saying parameter missing
After server upgrade from SP1 to SP6 suddenly report started working strange. we calling ROX file from SOAP call from java, after SP6 upgrade parameter value passed as mandate DB parameter showring error saying missing parameter. [main 2021-12-23 15:36:32,020]ERROR - Soap Server error. AxisFault faultCode:…
Actuate cloning
I'm hoping someone can help me with exporting Actuate iserver 11 from one server to another. We have three actuate systems. Prod, QA, and Test. I'm looking for a process to copy Prod to the two lower environments. We used to do this with Actuate 10 and lower but those used SquirrelData and tools that I can't find with…
How to remove non-UTF8 character from a string in OTIC 21.2
Trying to remove non-UTF char from a string in OTIC. Can you pls help?
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.
Drill down for details in a report
I've been trying to get drill-down working in my reports (by grouping) within the same page via expand/collapse is highly preferred. Looking around I've seen lots of references to these two pages: This one sounds like it could be what I want. http://www.birt-exchange.org/devshare/designing-birt-reports…
Question about "Collapse Groups Client Side" DevShare
Hey, So I am trying to recreate this report, found at: <a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/1126-collapse-groups-client-side/#description'>Collapse groups client side - Designs & Code - BIRT Exchange</a> And I am clearly missing something. When I…
Excel Columns are shifted when exported to xlsx format
Hi team, When I am exporting my data into xlsx format which has more than 10000 rows then the data is shifting to thers cells and not aligning properly with respective cells. Can anyone please assist on this issue.
Help need on Security/ACL/ grouping
Hello all, i am new to Actuate. trying to implement a page level security settings for a report. this report has agent level pagebreak summary & at the end of the report have grand summary. when setting the Grantexp expression GrandTotal frame is coming as a new page as shown below grandtotal is initiated using NewAfter…
How to download file pdf from ihub server by REST API
I use ihub 16 and i try to download file pdf by REST API use method /files/{fileId}/download , but i can't view file obtained . Please help me !
Get Folder list of custom categories
Hello, How Can I get the Folder list of custom categories in OpenText using T-Sql?
actuate.getUserID() returns null after authenticated using JSAPI - authenticate
Once the user is authenticated using acutate.authenticate(), and tried to access the actuate.getUserID(). It returns null. Any steps is missed out. Plz do know the steps to retrieve the user id once authenticated
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…
Can't set x-axis intervals
Hi guys, I am creating a birt reporting template where I need to create a histogram. In the chart, on x-axis, i want to plot maximum and minimum value coming out of my data source. Basically there is a coloumn which consists of several values. From these values, maximum and minimum values should be plotted on the x- axis.…