Analytics

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

Partial or Incremental Data Load
Hi all, We have implemented an OpenText Report based on SAP BW Data. Now, we need to decrease the amount of data loaded nightly. I know this is possible in SAP BW via partial data load mechanisms like “delta load”. Do you have any idea how to load data incrementally in OpenText? Would it be an option to only load changed…
Multiple datasets for each query or one dataset for all queries?
Suppose I have a chunk of queries that counts the number of times a transaction occurs in each warehouse and runs said query for all warehouses elect transactionCount, warehouseID FROM warehouse2.itrn where..., select transactionCount, warehouseID FROM warehouse3.itrn where..., select transactionCount, warehouseID FROM…
Issue in Hyperlink between Dataset in BIRT Report
There is a BIRT report which has 3 datasets and all the 3 data set has a field LOCATION. This field should have hyperlink to move from first dataset to second data set and then to third dataset. It is not necessary that all the 3 dataset would always have values. If all the 3 dataset has values then the hyperlink moves…
BIRT Report Parameter Markers in FROM clause
Suppose I have a simple SQL query: select * from wmwhse21.itrn where adddate = 20191111 I want the user to be able to choose the database upon which to run the query at run-time. I've tried putting select * from aa where adddate = 20191111 and aa = ? i.e. placing a parameter marker in the FROM clause, but after keying in…
Opening several pannels with different reports in web-browser - iportal 16.4
Could someone share the way to open several reports in iportal 16.4. Now only one panel is opened and another report only rewrite this panel in browser window. I need to open the several pannels each one with different report.
Birt Aggregation SUM on reg hours
Hi Mathew, I couldn’t find the examples you attached here. Could you please post your examples again? Thanks
In BIRT report, I cannot set page type as US Legal
Hello, In birt report, how to make page Type as us legal. In master page I have tried but it is not working while generating xlsx file
In Birt report, I cannot set page Type as US Legal
In birt report, how to make page Type as us legal. In master page I have tried but it is not working while generating xlsx file it showing a4. But if I export in xls it having page Type as Us legal.
BIRT 4.7.0 runtime in Maven
Why the BIRT 4.7.0 runtime is not available in a maven repository? Do you have plans to add it here?
BIRT Designer 16.4 crashes upon clicking the "Script" tab
I use BIRT Open Text designer v16.4 and all of a sudden, when I click the "Script" tab the entire application crashes/closes unexpectedly.I have tried restarting my Mac a few times. I have Magellan too on my machine which works fine. The last time I got this issue, I had to delete my existing Mac user profile and create a…
Conditionally enable Hyperlink for a field in BIRT Report
I have a BIRT report which has 2 dataset and both of them have a common field displayed. When I click on this common field in first dataset which is a hyperlink then it should automatically move to the second dataset and show the same common field . I'm able to get this working however id the value is not present in the…
How to diplay Page Number in the BIRT 3.7.1 report as per the Group By implemented in the report.
Hi, I have a query on BIRT report. I am attaching the output of a report in pdf format. The requirement is to restart the page number for each group. There is group by based on Work Order number. Currently the page number are appearing sequentially. for example if total page is 7 then the page number is…
Chart Scripting: Pie Chart Series Color
My question is, how can i color a SERIES in a pie chart dynamically, depending on the Value of the Series. The trick is, i just want to color the first series. I can identify the series with in the beforeDrawSeries functionseries.getSeriesIdentifier() i…
Pie Chart: Color by Categories
Hi, I'm using a multiple pie charts and the slices are colored based on what the value of the category series is. This is working as intended, but the question I have is can I specify the color based on the value of the category. For instance, my current slices are 'Agree', 'Disagree' 'Strongly Agree'. Depending on the…
Parameter Data Types keep changing
Is there a way to keep the parameter datatypes from changing? I have one set to Integer, but it will periodically change to decimal or string for no reason.
Where to deploy .jar files in Magellan
Don't know if this the correct forum for this question.... Mods feel free to move if it's not. Anyway, we are upgrading from iHub to Magellan, and I was wondering where in the Magellan file structure to deposit the .jar files we currently use. I'm guessing here: Please correct me if this is the wrong location. Thanks, Scott
Using khmer language in Birt Report
Birt report version being used is 4.6.0. PDF file is being generated. I want to use khmer characters in the pdf. Steps performed : Download and Install the khmer font being used in the report. Ex : KhmerOSbattambang Set the Charset of the report to utf-8. Ex : <?xml version="1.0" encoding="UTF-8"?> Create a text element in…
remove dataset records if null on fetch
When I write the following code on fetch for dataset var tmpArray = reportContext.getPersistentGlobalVariable("timeValues"); if (tmpArray.contains(row.Timeslice) == false && row.Timeslice != null) { tmpArray.add(row.Timeslice + '-'+row.GroupNo + '-'+ row.Type + '-'+ row.Value); }…
birt chart not displaying Caused by: java.lang.NullPointerException
Feb 20, 2020 12:05:46 PM org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor processExtendedContent SEVERE: null org.eclipse.birt.chart.exception.ChartException at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.onRowSets(ChartReportItemPresentationBase.java:952) at…
How to show grouped aggregation data in line chart?
Hi everbody, This is my first question in this platfrom. I have grouped date in my birt report and all grouped data also has aggregation. I have added and image. ı need to show the grouped aggregation data in line chart. But I could't be successfull. Chart does not show the correct data as its calculated in grouped…