Intelligence (Analytics)

Analytics applications that use Magellan BI & Reporting

Freeze Table Column Headers
I have a table with 30 columns and I would like to freeze the left 3 columns in HTML view while I do horizontal scrolling. Any ideas how this can be done in a regular table?
freeze pane in excel report using BIRT
Hi, I am generating excel report using BIRT open source. I have to freeze header row in excel report. How can i do this using BIRT. Thanks in advance, Ashish
BIRT - select into temporary table
Hi This is a simplier presentation of a query that I need for a report. I can preview data but nothing when run as PDF. My question: BIRT can "manage" this temporary table ? With tableA as (Select field1,field2, field3 from tableB) select tableA.field1, tableA.field2, tableA.field3 INTO TEMPORARY tabletemp from tableX left…
How to create multiple sheets(tabs) in single excel sheet using spudsoft emitter in BIRT 4.6
Hi All, How to creatre multiple sheets(tabs) in single excel sheet using spudsoft emitter in BIRT 4.6 version. Sheet name are selected from report group fields. For e.g: Currently Department wise all employee details are selecting in single excel sheet. Now I have to develop a report wherein each excel sheet(tab) should…
Integrate BIRT WebViewer in a Angular Page
Hello, I am new to BIRT framework. I am trying to develop a web application(specifically an Angular page) which can display the exact same contents (like pagination, export into PDF, CSV or other formats) which are displayed on BIRT WebViewer (internal server). Please let me know how can I start or if anyone has a working…
Getting multiple values from a data set to use as parameters in a BIRT report
I have a data set with a known number of rows like this: Name Value Cutoff 1 20 Cutoff 2 25 Cutoff 3 30 Now I would like to get these values (20, 25, 30) into parameters (cutOff1, cutOff2, cutOff3) that I can use in expression builders in tables and crosstabs. Any ideas?
Hide legend for a series with grouping
<p>As described elsewhere in this forum, the code:</p> <p> </p> <div>function beforeDrawLegendItem( lerh, bounds, icsc )</div> <div>{</div> <div>if(lerh.getLabel().getCaption().getValue() == "series_name"){</div> <div>lerh.getLabel().setVisible(false);</div> <div>bounds.set(0,0,0,0);</div> <div>} else {</div>…
iHub Error 3301
<p>I just installed the iHub Trial edition and tried to execute some of the sample reports but the following error keeps popping up:</p> <p> </p> <p>3301: Cannot get the report parameters for the specified file.</p> <p> </p> <p> </p> <p>The install said it completed successfully. Any suggestions would be appreciated.</p>…
Documentum, FileNet and Open Text Cloud Presence
Hello all, Here few points which i know on Open Text Cloud, FileNet. To be frank i don't have much knowledge on Open Text Cloud but I know about IBM if do any wrong please help me out. IBM offer all major ECM products in cloud: IBM FileNet P8 Platform IBM Case Manager IBM Content Manager OnDemand IBM Content Navigator look…
BIRT - Connection Profile - Security
Hi All, Need your assistance on the following, We are developing BIRT reports using Eclipse BIRT 4.5... We wanted to connection file to store the DB details for all the reports but unfortunately, the password is plain text (XML file)... How can I use the Encrypted password in the connection file as we don't want to expose…
How to add Dropdown dynamically using a dataset
Hi, I am new in Birt, can anyone help me how can we create a dropdown list in Birt such that a column should appear in a dropdown list and on selection of such column below tables should be refreshed Thanks, Dheeraj
How to set parameters in Report created through DEAPI
<p>Hi,</p> <p> </p> <p>I want to use parameterised query, where I should be able to set values through URL or JavaScript.</p> <p>I am using the same example code at <a data-ipb='nomediaparse'…
How to hide specific parameter section dynamically
We have request to create date parameter options based on the prior selection so if the user choose to select date range they can see start and end date. However, if they select number of days than they see just integer option to put the value in ex 7.
Data Not Displaying in Correct Row or Not Displaying at All
<p>I am attempting to create a simple report that has a single table where some of the Data Bindings use if statements or concatination of multiple fields. I am using version 3.7.1 of BIRT and Eclipse from the IBM All in One package for use with Maximo 7.5.</p><p> </p><p>The problem I'm having is that any time I create a…
DFC code for extended permission
HI Team Could some one hep me with some dfc code for extended permissions in documentum. Regards Shashank
How read array into same dataset
Hi, i need read an array into xml using one dataset in birt report, for example if my XML is datas.xml: <?xml version="1.0" encoding="UTF-8"?> 4bb8c4f7-7a39-4fc0-b13c-4eaca8ac8e3c 1028311026 DINAMARCA 1518612497345 4bb DAM-2018-107 1 5013292 2 5013292 3 5013292 I created 1 datasource to this datas.xml and have 1 dataset. i…
How to fit the report having Table and Crosstab in ANY export report Format other than HTML???
Birt Runtime=4.6.0 AS I am integrating Birt reports in my existing java Application, I was used to include "_fittopage=True" parameter in url .But insufficiently I was getting Corrupted data From reports I was Importing to various formats like excel,doc,pdf,xlsv.. The report layout i followed was " AUTO".so is there any…
Apache TomEE vs JBoss EAP vs WildFly?
Hello All, Im looking to install OpenText Media Management 16.2 on a Windows server. For the Application Server what is the most recommended Technology for a Windows 7 PC? Wildfly 9.0.2 Final Apache TomEE Plus 7.0.2 jBoss EAP 6.4 Please help me Thanks Gnanasekar
formatting attributes dynamically
I need help. I want change all atributes in beforeFactory or initialize I have #FF0000 Custom (#0.00) right col01 I can change color,textAlign,resultSetColumn elemento="Data04" myLabelHandle = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement(elemento);…
BIRT - How to show the Dimension on each page in cross tab
Hi all , Does anybody to know how I can show the "Dimension" data from Data Cube in each page of the cross tab. Exapmle: In attachment there is two pages of my report. I want to see the "Name" John and on the second page. I will happy if someone can help me . Thanks in advance! BR Georgi