Analytics
Analytics applications that use Magellan BI & Reporting (OpenText iHub, iServer, or Eclipse BIRT runtime)
-
SQL Server Query
How can we check in a SQL Server WHERE condition whether the column is not null and not the empty string ('')?
-
Not able to login with other users after RSSE Integration with Process Suite
Hi, After RSSE integration, few users are pushed to iHub server when the reports are accessed from Process Suite. (There are also Home/XXXX folders created for these users in the iHub portal). But we are not able to login with these users to iHub iportal. Also we are not able to see these available users in the user tab in…
-
Birt report once generated the pdf in pdf file click on download it is showing only design file name
Birt report once generated the pdf file click on download it is showing only design file name I want to set input parameter as a Invoice no so that one I want to set as a download file name like in parameter is 123456 then my download filename is 123456.pdf how to do in birt report because I am using bilt in run servlet…
-
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…
-
Summary of a document generated by opentext
Hello everyone. I have a document of almost 70 pages generated by a statistical report. My difficulty is that I have to make a cover page on the 1st page and the summary of the document before the elements of the document start to display. Thank you to enlighten me. I am using OpenText Analytics Designer Version: 4.6.0…
-
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…
-
how to convert from utc to est in ihub birt reporting
Hi Team, Can some one help me how to convert the UTC to EST time zone in iHUB reports. Currently we are getting the date as UTC time zone from the Appworks DB and need to convert it in rptdesign/datadesign. Thanks in advance..
-
Birt Report Displays Server Time and Not EST
<p>When a report is run, despite the report locale being set to show EST it reports UTC which is the default server time. I am using the BirtDateTime.now function and the same happens when I use the getDate function. </p> <p> </p> <p>Is there something I might be missing in the report design to define the time output to…
-
Ability to get report usage count
Good morning, all! Is it possible to find the number of times a report is run by users (not scheduled jobs)? If 'yes', what log file would I need to look at to find said info? We are using iHub 3.1.1 Thanks in advance for any help provided! Scott
-
Unable to install CSV Emitter plugin using Jar file in Magellan Analytics Designer CE 21.1
I created the CSV Emitter plugin following the instructions given in APIs Programmer Guide provided by Actuate. I've tested the emitter in Magellan Analytics Designer CE 21.1 by running it as an eclipse plugin from Run Configurations. This will create a new instance of eclipse & in Designer Perspective under Run -> View…
-
jsapi viewer chart submit() works only in same page?
I have some checkbox/ radio button that filters the chart if both this button and chart in same page, chart.submit works and chart filters if I change in two different pages, chart.submit never seems to be happen charts in second page always fresh/ unfiltered?
-
Creating BIRT Reports on the web
Is there a way to integrate designer into an existing web application so that the users can create on the fly reports using the designer? I know that Birt Report Viewer can be deployed so that reports can be viewed but can we do the same with Report Designer for creating reports? Thanks!
-
BIRT report to create the csv file and report generation
BIRT report Requirement: I need to create Labor report and display the columns such as (laborcode, startdatetime, finishdatetime, regularhrs,craft etc) with below mentioned 2 parameters and when run the report from Maximo application, the report generates in browser view. At the same time, the CSV file should be generated…
-
Multi select report parameter
Hi, Does BIRT has check box as report parameter for multi selection? I need requirement as in green below i.e. in green I am able to create Cascading dynamic report parameter that looks like in orange below But, I want to make them as check boxes for Multiple Selection! or can you suggest ay other alternative?
-
How to suppress FaultRelatedException return in http response
Hi, Would like to check is there a way to suppress Cordys:FaultRelatedException from returning in http response? Our company security scan through and stated that this is a risk for opentext to return exception handling message in http response.
-
Add BIRT Viewer to a Spring Project
Hello, I'm new to BIRT and I have been successful in running a birt report with data from my spring application. I'm now trying to embed the Viewer in my jsp so that when the report is executed, it's shown to the user in the Birt viewer. Unfortunately, I'm unable to embed the Viewer into my jsp. Could someone please give…
-
Optional grouping
I'm trying to create a report where the grouping in the report is optional. If a checkbox is ticked, then a grouping should be applied on the table. And if the checkbox is unticked, then there should be no grouping applied, and the data should be presented as a flat table. Here are a couple of approaches that I've…
-
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…
-
Custom Report Item - Rotate Text
Hello BIRT community, The old version of the custom report item example are under https://www.eclipse.org/articles/article.php?file=Article-BIRT-ExtensionTutorial1/index.html and https://www.eclipse.org/articles/article.php?file=Article-BIRT-ExtensionTutorial2/index.html A new version of it can be found now on github. I…
-
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. _