Analytics

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

Not able to Filter the Report Data based on Year
I need to filter the report data in BIRT based on the year selected in the report parameter. If I select 'Current Year' from the parameter, it should only return me the data for 2020 year and not previous year. Please find the attach screenshot for the report result I'm getting. I have applied the filter for 'Planned…
Set different day as start and end of the week in BIRT Report
Hi All, Generally Monday is considered as start of the week and Sunday is considered as the end of week. I would like to understand whether there is a way to change this to start of the week = Wednesday and end of the week = Tuesday . User would be entering start date and end date as report parameter which would be…
Webservice problem with tutorial and previewing data set
Hi, I've followed the following step-by-step tutorial (great !!! <3 ) to train myself using web services and BIRT. http://otadocs.opentext.com/documentation/ihub31-dev/DAG/index.html#page/DAG%2Faccessing-data-webservice.10.4.html But I encounter an issue :'( : in step 10 ("In Edit Data Set, choose Preview Results."), my…
Setting the content key of a text label using an "onCreate" script
Hi OpenText-forum, after doing some research I could not find any documentation or advice on the following topic, therefore I am opening this discussion. In a report design I have a text label that is localized using properties files. The key to read out the localized value is entered as content key, please see the first…
Unable to create dynamic parameter for current year and previous year
Hi All, I am trying to create a BIRT report where I need a parameter which needs to show the current year and previous year as the value in the dropdown. For example, the parameter should show 2020 and 2019 as the values as per the current date and it should change next year and going forward. I'm using Scripted Data…
How to create bar chart out of pie chart? (one bar, split by x axis entries)
I have the following info: ___ | | | | ___ | | | | ___ | | | | | | =========================================== #1 #2 #3 I want to display it in a single bar chart like the following: ---- | | | | | | #1 | | ---- | | #2 | | ---- | | #3 ---- Preferably horizontally. Essentially, I want to create a "pie chart" out of my data…
Parameter: Listbox with Dynamic value from DataSet is empty on the production server.
I create a parameter with data set for using with Listbox. In my birt designer with jetty, it's showed correct data from database in Listbox. I, however, deploy rptdesign file to production server (Tomcat 8, Birt 4.8, OpenJDK 8) then showed empty data in Listbox. How can I fix this issue?
Calling a JavaScript function in data binding of chart
Hello forum members, in a report design that contains tables and pie charts I am trying to display values based on predefined different time frames e.g. YTD. Therefore I am using a Javascript function in a .js file that is in the resources of the report design. The calculations work fine in the tables. However, when I call…
Set chart meter region at runtime
Hello, I'm tryin to set the start value and end value of regions in a meter chart in the beforedrawserie function but I got the error "TypeError: Cannot find function getDial in object class org.eclipse.birt.chart.model.component.impl.SeriesImpl" for this code : function beforeDrawSeries( series, isr, icsc ) {…
Chart Hyperlink in BIRT Maximo 7.6
Hello Folks , Hyperlink(drill through) from Chart is not working when I upload the report in Maximo . It is working in Designer though.It gives me error Error 401: SRVE0295E: Error reported: 401 Interestingly, hyperlink is working on the table row (using…
custom font
I have build a report with a special font. The report is generated from a web-application. Because i cant force any customer to install the special font on his system, i need to integrate the font in the pdf. So any customer can see the report with the custom font. I already searched but could not find a solution for this…
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…
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…
Chart Legend Size/Wrapping
I'm working through my first chart and I'm having trouble getting the legend to render properly. It's truncating the values. Can someone tell me what properties I should be tweaking to get the legend correct? Thanks!
Weird issue with a report when user tries to run it
Good afternoon, all! I have a user that is having an issue with running a report from Edge Chromium. When she inputs a parameter value, and clicks 'Finish' she gets the following error: I tried replicating the error, but it ran fine for me. The only time it would give me the same error, is if I hit the 'Enter' key instead…
Dual Y Axis Scales Not Sticking
Hi- So I'm having issues with my scaled on actuate reports. I know there is a an option to set min/max, and set the step interval. What I have for my graphs is on the first Y Axes I have values like numbers, on the second Y Axes I have a variable that is a percentage that will always be capped at 100. I 'd like for my…
Disabling Stack trace for BIRT Viewer Exception
I need to stop stack trace information coming back to the browser if a report design file is not found or fails. Please confirm if there is any best approach to stop BIRT exception stack trace to browser. using following versions for reporting. Viewer version : 2.6.2 Engine version : 2.6.2 JRE version : 1.7.0_141 Thank…
StoryTeller Windows 10
Hello, Sinc I upgraded to Windows 10 my StoryTeller starts with an Error window saying that the entry point was not found and points to an exception type System.EntryPointNotFoundException, followed by a stack trace. If I ignore it, as soon as I want to add any component like a TextBox etc. a similar error pops out. Any…
Data Object fails with Exceed the file length
 Trying to run a data object in BIRT iHub 3.1 (Build 231A150206) Fails with following: <p…
Which is faster: having one dataset for all charts or one dataset per chart?
Suppose I have a chunk of SQL queries to extract transactionCount and warehouseID from a hundred or so warehouses: --this is just an illustration and not the main part of my question select transactionCount, warehouseID from warehouse1.itrn union select transactionCount, warehouseID from warehouse2.itrn union select…