9 Application(s) results for #bi
Filter
Show only
Last release on OEX
Categories
Works with
Industry
Application NameDeveloperMade withRatingLast updatedViewsInstalls

PivotToPowerBI

View extracted data from IRIS BI cubes in Power BI

P
Peter Steiwer
Docker
IPM
0.0 (0)22 Jun, 2025 62 18

ReadyForAction

Demo for "Demos and Drinks" at InterSystems READY 2025

P
Peter Steiwer
Docker
Python
5.0 (1)20 Jun, 2025 66

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

CustomCubeActionManager

Easily manage InterSystems IRIS BI custom cube actions

P
Peter Steiwer
Docker
IPM
0.0 (0)06 Jun, 2025 20 21

iris-analytics-template

Basic template for IRIS Analytics solutions

Evgeny Shvarov
Docker
IPM
5.0 (2)13 Aug, 2024 1.0k 88

samples-bi-demo

Demo of InterSystems IRIS BI cubes, pivots and dashboards in DSW

Evgeny Shvarov
Docker
IPM
4.5 (1)14 Jun, 2024 323 14

iris-analytics-package

This project has the intention to show a basic approach using the Analytics capabilities of InterSystems IRIS

Henrique Dias
Docker
IPM
5.0 (1)25 Mar, 2024 424 28

Samples-BI

Provides sample data for use with InterSystems IRIS Business Intelligence, as well as fully developed sample BI models and dashboards.

Evgeny Shvarov
Docker
IPM
5.0 (1)25 Mar, 2024 868 972

covid-19 analytics

analytics for covid-19

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

dataking-server

A simple and fast way to send data from your application to the IRIS database for further processing and search for insights.

Alexey Nechaev
2.0 (1)20 Dec, 2020 142