InterSystems Business Intelligence enables you to embed business intelligence (BI) into your applications so that your users can ask and answer sophisticated questions of their data. Specifically, your application can include dashboards, which can include the following:
In contrast to traditional BI systems that use static data warehouses, Business Intelligence is kept closely in synchronization with the live transactional data, as required for your business.
Hi everyone, This is me again🥲...
Today I want to share a sad story, which is my Deepsee Web is not working properly.😭
The story is like that.
Initially, I have a dashboard on monitoring how much I spend on the sky (by time chart) and look like the following originally
Hello Community,
What is the correct way to import and compile .dfi files when using zpm load? Do .dfi files need to be defined in module.xml?
I have code that imports the .dfi file successfully; however, when I runzpm "load /home/irisowner/dev/ -v"
I get the message: Unknown file type. Skipping file: .pivot.DFI
zpm "install isc-dev"doThank you!
In this article, we will discuss all the debugging tools included in the Microsoft Visual Studio Code IDE.
What will be covered:
Let's start by learning about debugging requirements!
Prerequisites
There are two plugins (extensions) for debugging ObjectScript:
The first is part of the InterSystems ObjectScript Extension Pack. The second is Serenji, a standalone plugin that provides an editor, file manager, and debugging functionality. Both plugins can be installed from the plugin store. To activate key functionality, Serenji requires a license. For this article, we'll use the InterSystems ObjectScript Extension Pack to reduce the learning curve. After you've mastered the basics, you can consider purchasing a paid license for Serenji.
I use $SELECT() in Architect to aggregate various data conditions into a single dimension.
I have a data table like this: id, user, userData1, userData2...
Where each user action is the %Integer ID of that action from some source. Then in expression field i use: $SELECT(userAction1:"This user action", userAction2:"That user action".) and so on, up to 14 conditions, excluding the default placeholder 1:"Other" (which is always empty because there is a condition with 100% chance).
Hi community
I have a persistent data class where there are some properties that contain underscores in their names, for example:
Property "client_name" As %String(MAXLEN = 250) [ SqlFieldName = client_name ];
In Architect, I would like to use this property in an expression, in this field:.png)
But I can't figure it out. If I use %source.client_name, it gives a compilation error. If I use %source."client_name", it treats it as the string "client_name" instead of getting the value from the field. Any suggestions on how to do this?
Hello everyone! 👋
I have a question regarding roles and resources.
To give you some context: I have a user who has been assigned only the role %HS_UsageDashboard_Access.This allows them to access the dashboards correctly (by giving the direct URL). Then, if I try to access the Management Portal with this same user, I can log in with no access to any resources within it (as expected).
The point is that I would like to completely deny him access to the Management Portal, while allowing him to view only the dashboards, as expected from the %HS_UsageDashboard_Access role.
Hello all,
I'm trying to build a cube based on a linked table but seems that IRIS is not able to do it :O
Long story short, I have a linked table in IRIS that sources a Microsoft SQL table (using standard linked feature from the portal). It works fine, I can access it using SQL as many other times. On top of that, I've created in DeepSee (ok, Analytics) a cube that uses this class as source. It compiles correctly, no errors given. When I build it with 100 records, all goes well and using Analyzer I can see results.
Existing cube deleted. Fact table built: 1,000 fact(s) (Max number of worker(s) used at a time: 1) Fact indices built: 1,000 fact(s) (1 worker(s) used) Complete Elapsed time: 1.788246s Source expression time: 0.000856s
Hi community.
I have a query:
SELECTFROMSELECTThis query should filter the data by the minimum value of the somDate field, but it doesn't. It displays all values together, regardless of the external filter. The exact same query (without the $$$ tokens, of course) works fine in a regular SQL runtime.
My guess is that the $$$RESTRICT does this
WHERE source.%ID IN (And outer WHERE is just left unseen
Is there a way to fix this?
I work a lot with IRIS BI, but some features are still a mystery to me. There is a great feature here that allows you to create expressions in Architect.
I'm already very familiar with it, but I still don't quite understand what environment it uses.
It can execute system classes like $SYSTEM.SQL, $PIECE(), %cube, %source(), it can do string concatenation, call methods from another classes.
I have two questions actually.
What environment it uses to execute this? Is it ObjectScript, SQL, MDX or maybe even its own?
Ready to elevate your Business Intelligence game?
We've got an engaging video, perfect for all skill levels.
Discover how to get started with IRIS BI, optimize cube performance, and drive analytics adoption. Plus, get a sneak peek at what's next!
#InterSystems Demo Games entry
The Co-Pilot enables you to leverage InterSystems BI without deep knowledge in InterSystems BI. You can create new cube, modify existing cubes or leverage existing cubes to plot charts and pivots just by speaking to the copilot.
Presenters:
🗣 @Michael Braam, Sales Engineer Manager, InterSystems
🗣 @Andreas Schuetz, Sales Engineer, InterSystems
🗣 @Shubham Sumalya, Sales Engineer, InterSystems
#InterSystems Demo Games entry
Our Autonomous Business Intelligent Clerk, or ABiC for short, is a prototype revolutionizing how companies process data and make decisions. Normally, to get insights from data, you’d need IT knowledge or expertise in statistics. But with ABiC, that’s no longer necessary. All you have to do is ask your question in plain language. ABiC understands your interests and intentions, then shows a clear dashboard to guide your decisions. With ABiC, complex data is autonomously analyzed and turned into answers that support users, helping to accelerate business processes. This demo sends the metadata of InterSystems BI cubes to LLM. How does it work? Check out the video for more details!
Presenters:
🗣 @Tomo Okuyama, Sales Engineer, InterSystems
🗣 @Nobuyuki Hata, Sales Engineer, InterSystems
🗣 @Tomoko Furuzono, Sales Engineer, InterSystems
🗣 @Mihoko Iijima, Training Sales Engineer, InterSystems
What's in a name? That which we call a rose
By any other name would smell as sweet
William Shakespeare, "Romeo & Juliet"
In this article, we will describe a set of naming conventions for ObjectScript code.
Hi everyone,
I am trying to create a treeMapChart in IRIS BI that will then be displayed on my DeepSeeWeb dashboard. In the IRIS BI User Portal, this is an example of what my treeMapChart looks like:
.png)
I know there is a huge amount of rectangles in this graphic - I care most about the common components (the largest boxes) but I still want all of the boxes to show. However, it projects to my DeepSeeWeb dashboard as the following:
The labels do not show, even if I hover over the boxes.
We’re building out a data lake in IRIS 2025.1 that aggregates data across multiple business systems and departments. I’m trying to establish best practices for schema design and separation.
Right now, I’m thinking of using a separate schema for each distinct system of record feeding into the data lake - for example, one schema per upstream source system, rather than splitting based on function (e.g. staging, raw, curated). The idea is that this would make it easier to manage source ownership, auditing, and pipeline logic, especially when multiple domains are contributing data.
Hello,
I need to expose InterSystems HealthInsight dashboards over the internet to external operators. The authentication flow is managed externally. When a user is authenticated, our system receives an HTTP request with specific headers (e.g., operator’s fiscal code and hospital identifier) that we need to extract in order to:
Maybe this is well known but wanted to help share.
Consider that you have the following persistent class defintions
An Invoice Class with a property reference to Provider
ClassExtends%PersistentAsand Provider
If you call the Build method in Sample.Invoice you can query this with SQL
Asand see
.png)
The area this article discusses is deciding how to create a dimension on Provider.
What I have found works well is to following this pattern
What this does is
1.
I have a widget that uses "choose Data source" control option. Termlist for the control consist of the two data sources and i want to set one of them by default. For example: I have two data sources, one is grouped by month, the other by year. I need to set the one that is grouped by year by default
Using default value at the bottom return an error
How can i achive that?
Has anybody tried to extend the Menu on Management Portal? I like to add a new page or a dashboard that will be created soon to the Management Portal and allow others to use it also. I understand there are risks that I could lose things during an upgrade. I am okay with that. Does InterSystems support such an effort?
Hi!
I have question about MDX functionality in context of IRIS Analytics.
How does IRIS MDX distinct selection works? Is there any restruqtion when analyzing strings? Like special symbols or length?
Here is an example
I have this data:
6 rows and 2 of them unique
Then we create data cube based on this model and examine it with Analyzer
Detailed listing
6 rows an ONE unique string. Which is obviously not true.
This happed only with string with symbols in it
My task is to get the right amount of unique strings
Role: Principal Architect and Integration Engineer
Employment Type: Full Time
Note: Expertise in Rhapsody/Intersystems is Mandatory.
Main Responsibilities
Hello all,
We are currently developing a set of cubes in Unified Care Report (UCR) for data analysis purposes. However, we are encountering issues with cube dependencies, where certain cubes rely on others to be compiled beforehand. The complexity of these dependencies is becoming increasingly difficult to manage, particularly when attempting to deploy the cubes.
The problem arises when trying to compile a cube that depends on another cube, which may also have its own dependencies. For instance, when compiling the Test.Cube.EncounterHealthPlans
Hi everyone! I am hiring an InterSystems IRIS Engineer If you or anyone you know has a qualifying skillset and is interested, please email me your resume and I will give you a call. Thanks! email: isabella.nolen@insightglobal.com You can also apply to my posting on LinkedIn: https://www.linkedin.
Hi, I'm new to the Analytics world in Intersystems and was attempting to print and/or export selected rows from a detail listing in a pivot on a dashboard. I am able to print and/or export all the rows; but if I select a specific set of rows, it prints out the entire detail listing; not the selected rows. Please advise on the best approach to accomplish this task. Thanks.
Is it some certain class, method, global, api, application or neither? If the entity is some of this what is the syntax?
My team and I noticed that the %ZEN class documentation labeled all properties and methods as deprecated.
In this regard, the big question is: what will be used to replace these methods, in particular %ZEN.Auxiliary.altJSONProvider?
It is used as the basis for the MDX2JSON package, from which DeepSeeWeb gets data to build Analytical Dashboards.
Is a replacement proposed for deprecated methods of %ZEN class?
And when is this functionality scheduled to be permanently disabled?
Hi Community,
I seek your assistance for below scenario.
Scenario-1: How to add filter or where clause while displaying data with listing fields ( I have not used Custom SQL listing to display this data).
For below table, I have created a Cube Student and I have created listing fields of the columns mentioned in the table. Also I have created the pivot and I am able to create the same table as shown below.
Now in another pivot, if I want to display all same detail with Student marks greater than 82. How to do that. Basically I want to know how to apply filter when using listing fields in a cube.
Pandas is not just a popular software library. It is a cornerstone in the Python data analysis landscape. Renowned for its simplicity and power, it offers a variety of data structures and functions that are instrumental in transforming the complexity of data preparation and analysis into a more manageable form. It is particularly relevant in such specialized environments as ObjectScript for Key Performance Indicators (KPIs) and reporting, especially within the framework of the InterSystems IRIS platform, a leading data management and analysis solution.