Welcome to Open Exchange

At InterSystems, we deeply appreciate the rapid innovation enabled by open-source development. Our team acknowledges the significant impact of the community's dedication, which has been a driving force behind the evolution of software and data technology.

Top contributors

Featured applications

68 Application(s)
Filter
Show only
Last release on OEX
Categories
Works with
Industry
Analytics
Clear filters
Application NameDeveloperMade withRatingLast updatedViewsInstalls

PivotToJupyter

View extracted data from IRIS BI cubes in Jupyter Notebook

P
Peter Steiwer
Docker
Python
IPM
5.0 (1)14 May, 2025 23 2

PivotSubscriptions

Subscribe to Pivot Tables in InterSystems IRIS Business Intelligence to receive scheduled emails

P
Peter Steiwer
Docker
IPM
0.0 (0)14 May, 2025 543 18

InterSystems Ideas Waiting to be Implemented

Programmatic reports

The report creation is a tedious and non-productive task. You need an IDE, create a connection, create a SQL query, define report bands, drag-and-drop/design report columns, fields, labels, summarizations, margins, charts and prepare perfect pixel reports for print. To create a tradicional report the effort takes 4 to 12 hours. The idea is to define reports using object script instructions. With some minutes and with writing a few object script lines you can get a report equivalent to a tradicional report, with the benefit to create dynamic content for the reports (productivity). The idea includes yet the feature to allows to the developer set print restrictions for the PDF report generated (reduce carbon emission, not allowing print, only read). Benefits of this idea: 1 - Productivity - develop a report in minutes not in hours 2 - Reduce carbon emission - is possible restrict the PDF print 3 - Create dynamic reports using ObjectScript 4 - No need to install a report server, saving processor and memory resources (decreasing emissions) To create a report using source code, see this sample with Java, but could be in ObjectScript too: TextColumnBuilder<String> itemColumn = col.column("Item", "item", type.stringType()); TextColumnBuilder<Date> orderDateColumn = col.column("Order date", "orderdate", type.dateType()); TextColumnBuilder<Integer> quantityColumn = col.column("Quantity", "quantity", type.integerType()).setFixedWidth(50); TextColumnBuilder<BigDecimal> unitPriceColumn = col.column("Unit price", "unitprice", type.bigDecimalType()); ColumnTitleGroupBuilder titleGroup2 = grid.titleGroup("Group 2", quantityColumn, unitPriceColumn); ColumnTitleGroupBuilder titleGroup1 = grid.titleGroup("Group 1", orderDateColumn, titleGroup2).setTitleFixedWidth(450); report() .setTemplate(Templates.reportTemplate) .columnGrid(itemColumn, titleGroup1) .columns(itemColumn, orderDateColumn, quantityColumn, unitPriceColumn) .title(Templates.createTitleComponent("ColumnTitleGroup")) .pageFooter(Templates.footerComponent) .setDataSource(createDataSource()) .setSecurityRule(PrintRule.READ_ONLY) //if you want restrict print .printPDF();

Y
by Yuri Marx

5

Votes

3

Comments
Vote

AnalyzeThis

Easily transform a CSV file/Table/SQL query into a personalized preview of InterSystems IRIS BI

P
Peter Steiwer
Docker
IPM
5.0 (3)09 May, 2025 1.2k 777

iris-vector-search

Quick and easy ways to use iris vector search with Python.

F
Fan Ji
Docker
AI
ML
ML
4.0 (2)21 Apr, 2025 1.5k

DeepSeeWeb

Renderer for DeepSee Dashboards in Browser with MDX2JSON as a Serverside and JS web-client

Anton Gnibeda
Docker
IPM
4.5 (2)01 Apr, 2025 2.6k 33.4k

pyiris-iceberg

Demonstrates copying IRIS tables into Apache Iceberg tables

P
Patrick Sulin
Docker
Python
0.0 (0)20 Dec, 2024 56

iris-DataViz

Exploratory Data Analysis with Visualization Application

Muhammad Waseem
Docker
Python
IPM
5.0 (1)28 Sep, 2024 210 2

IRIS-Log-Monitor

Monitor and display some information,Can be viewed more convenie

s
sara aplin
Docker
IPM
3.0 (1)22 Sep, 2024 132 1

BridgeWorks WebReports

Web based reporting and dashboard platform

Tony Coffman
0.0 (0)26 Aug, 2024 496

BridgeWorks VDM

BridgeWorks VDM is an ad hoc reporting and graphical SQL query application.

Tony Coffman
0.0 (0)26 Aug, 2024 524

Database Growth - Data Collection and Analysis

The two continued repos are linked at the end of DataCollection.

A
Ariel Glikman
Docker
4.0 (2)04 Aug, 2024 213

DataAI

http://DataAI.link - Where Data Meets Intelligence!

I
Irina Yaroshevskaya
AI
0.0 (0)03 Aug, 2024 68

iris-errors-analysis-graph

Analyze errors on the IRIS portal generate statistical graphs.

L
Lucas Fernandes
Docker
Python
IPM
AI
1.8 (2)28 Jul, 2024 216

MDX2JSON

RESTful web api for MDX to JSON transformation (plus JSONP and XML/A) for InterSystems Caché. Also provides information about DeepSee objects.

E
Eduard Lebedyuk
IPM
4.5 (2)12 Jul, 2024 1.0k 34.0k

AdvancedIRISBISamples

Advanced samples for InterSystems IRIS BI

P
Peter Steiwer
0.0 (0)10 Jun, 2024 83

Perftools IO Test Suite

Tools to exercise and measure the IO capacity of hardware

P
Pran Mukherjee
4.0 (1)17 May, 2024 341

DNA-similarity-and-classify

Classify gene family find similar DNAs with Vector Search and ML

D
Davi Massaru Teixeira Muta
Docker
Python
AI
ML
ML
5.0 (1)12 May, 2024 297

iris-fhirsqlbuilder-dbt-integratedml

Demonstration of building predictive models trained on FHIR data

Thomas Dyar
Docker
Python
AI
ML
ML
0.0 (0)29 Mar, 2024 176

iris-analytics-notebook

A notebook approach to use IRIS analytics capabilities.

José Pereira
Docker
IPM
4.0 (1)25 Mar, 2024 377 26

iFindPortal

A Search Portal demo app for iFind, part of InterSystems' iKnow technology

B
Benjamin De Boe
IPM
3.5 (2)25 Mar, 2024 201 107

covid-19 analytics

analytics for covid-19

Evgeny Shvarov
Docker
IPM
5.0 (2)25 Mar, 2024 640 21

dsw-map

It is map examples of different regions to render in DeepSeeWeb

S
Semion Makarov
Docker
IPM
3.0 (1)25 Mar, 2024 332 11

trino-iris

Trino InterSystems IRIS Connector

Dmitry Maslennikov
Docker
Python
0.0 (0)01 Feb, 2024 187

CubeEventMonitor

Tool for monitoring BI cube events and build errors

S
Samuel Duncan
Docker
IPM
4.0 (1)29 Jan, 2024 455 46

OUReports

Online User Reports - automatically analyzes data - generates automated reports - provides interface for ad hoc reports - conducts statistical research. Connect to your database and see reports made for you by Online User Reports at OUReports.com

I
Irina Yaroshevskaya
5.0 (1)11 Dec, 2023 283

iris-dmn

IRIS + DMN, make business logic visually

Alexey Nechaev
Docker
IPM
5.0 (1)25 Nov, 2023 248

iris-size-django

A portal for visualizing and keeping track of memory usage of an

H
Heloisa Paiva
Python
4.8 (2)06 Oct, 2023 418

iris-fhir-generative-ai

An experiment to use generative AI and FHIR

José Pereira
Docker
Python
IPM
AI
0.0 (0)16 Jul, 2023 529 25

IntegratedMLandDashboardSample

A simple example of generating machine learning prediction data

Shanshan Yu
IPM
ML
ML
0.0 (0)06 Jul, 2023 343 3

generate-dates

Generate a CSV file containing dates with additional information

Asaf Sinay
Python
3.5 (1)04 May, 2023 141