Analytics

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

chart visibility format dynamically change at client side?
Hi, I see Visibility allows to hide certain given format [pdf->rue] meaning, it hide for pdf and visible to all other format. that is fine; I want to change expression and format at client side depends on other user selection/action. I want to handle these visibility property at any of client side exposed methods example,…
Calendar view in Birt
I have asked to create a Foward Schedule of Change using Birt 2.2.1.1. What my boss wants is a Calendar view for a month (like in Outlook) that per calendar day shows which Changes are due to implemented on that day. I can create the data sets I need but am having difficulty creating something that resembles a Calendar…
calendar
I need help with a reservation report. What I need to happen is, I have a calendar data set which I got from this forum which gives me the calendar days. I have two datasets. 1 for start time and the second for Finish time. I first joined start to finish to for a dataset and then joined that resulted dataset to the…
Help with displaying inputparams value in report
Good afternoon all I create a report that reflexes the data range parameter based on the current date/time and now I am having a hard time display the inputParams["START_DATE"] and inputParams["END_DATE"] values as either a text element or dynamic text element. I've tried using global variables based on searches online but…
Cross tab performance very bad
We habe a general problem regarding the performance of crosstabs. Here is an concret example: A crosstab report design with 3 parameters uses a iHub data objekt of size 36MB. Just the loading time (time until you can select the parameters) of the crosstab on the iPortal is 20 seconds. The Ram od the iHub server is 32GB.…
Dynamically change currency format (prefix) of y-axis series when running report
The software I work on gives users the ability to define their own home currency on the system, so I need to be able to change the currency symbol displayed in charts dynamically either in script or preferably as part of the engine integration we've developed. I'm sure I could work that out if I could figure out how it's…
How to refresh the parameter page on the Scheduler in iHub server?
Hello Team, Good day! I have created a Date prompt which shows "Today's Date" by default. But in Scheduler, the date value in the prompt was not getting refreshed it was showing the same date after sometime. Could you please tell me how to refresh that date prompt value in Scheduler (i mean, how to auto refresh the…
How to call REST API from BIRT report with JWT token
I have a requirement of calling REST endpoints from BIRT report. I created a simple report which is consuming response and showing data correctly. But I could not find solution for below use cases: * REST call to fetch JWT token using credentials. * REST call to any request with already fetched JWT token * REST call to for…
Adding Multiple Row in Cross Tab Report
Hey All, I want to design a report which has multiple row area in the cross tab report. I added it but now unable to add a column. The design of that report should look like this: Can anybody suggest to me if I can use a cross tab approach or if something else will work? Any help will be appreciated. Thanks.
Changing number format of chart series in script
I have a BIRT report with a chart containing sales data, I want to display the currency in the chart series labels which is achievable statically, but on my system the user can choose their currency. So I need a way to change the number format of series labels in code. I found an old forum post referencing my exact…
BIRT maintenance?
Hi all, i have a question regarding birt use in eclipse. It seems the last releases of eclipse does not include Eclipse IDE for Java and Report Developers anymore anymore. Could you give us more information regarding this fact? Thank you Gérald
Fetch number of days for each month based on Date Report Parameter in BIRT Report
Hi , I have a birt report which has report parameter on the date field i.e. Start Date and End Date hence user can run this report for 1/3/6 months or an year. Now what I have is based on this report parameter I need to fetch the number of days of each months. For example, Start date - 1 Jan 2020 End date - 31 March 2020 I…
AppWorks
I'm aware this question may not belong here, but I can't post in Appworks. Anyway, Can someone tell me if AppWorks uses OpenText Analytical Designer for reprot development? If not what does to use?
Eclipse BIRT roadmap - stuck at version 4.9RC1?
I'm a long time user of BIRT (since version 2), which we have integrated into our commercial ERP application. I'm struggling to find any definitive information on the future of the Eclipse project. The latest release - 4.8 - is now almost 2 years old. And the most recent build (4.9RC1) is over a year old. Does anyone have…
chart display property change using birt desinger API is not working?
Hi, I am using org.eclipse.birt.report.model.api.ExtendedItemHandle extensivily, but unable to set display property using it? as per rptdesign xml, <property name="display">inline</property> decides chart display setting org.eclipse.birt.report.model.api.ExtendedItemHandle setProperty("display","none") or…
How to Use JavaScript Variables in WebReport Tags
I've made an ajax request to ?func=personal.settings in order to get the user's language settings. I then used JavaScript to see if en_CA" SELECTED>English or fr_CA" SELECTED>Français is present. I like to put the results into a WebReport tag but I noticed two things. 1. WebReport tags seem to ignore JavaScript rules so if…
Actuate Idapi and SOAP to download as pdf
Hi All, I know this question is probably asked a few times but none of the solutions really helped. SO trying again: - Our requirement is to download and save all the reports in one of our volumes as PDF on our local shared drive. We already have idapi installed…
crosstab reports getting - There is no report design object available Error
Hi, I am getting the following error message anytime I add a crosstab to a report, even a really simple one. It works fine when I run it from within BIRT. As soon as I load it into my system I get the error below. I have other crosstab reports created years ago that work in the system but this one…
number to string conversion appending , example 2018 shown as 2,018
I have data set, query returns year, month, day (all these are integer in database). I am creating dataCube for drilldown but very first time, year shows as 2,018 To replicate this I created sample inline data in attached report, last third chart shows year as 2,018 Then I added computed column comp_year on year that…
how to change Legends text using dynamic birt scripts (beforeFactory) or client Scripts?
how to change Legends text when Group by on YAxix gives gives drilldown capability? example, if I have group by Id and legends shows id? but as id is internal, I want to show name inplace? attaching example where group by year shows 2018.... now, I want to show last year, current year text inpalce