Hey Community,

Enjoy watching the new video on InterSystems Developers YouTube:

Reporting & Business Intelligence: What's New? @ Global Summit 2022

https://www.youtube.com/embed/H2KiAk4c6jU
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 157

I have a cube that lists services, processes, and operations information and wanted to make the names of the items more user-friendly to end users and to use a flag to determine which components would be displayed in the dashboard.

We created another table/cube that has a status flag (1/0) to determine whether we would look at the item, the existing name, and the human-readable name.

What is the best way to reference the data in the new cube from the original cube to use the human-readable name?

Thank you, LG

0 1
0 155

In addition to charts on a dashboard we have a request to have a crosstab which would be populated by some entries queried out of an error log. It's basically a detail query with mostly text data. I have tried making a pivot widget for this using both a cube and kpi source, and while succeeding with the KPI, it leaves a lot to be desired.

0 3
0 153

After creating a new dashboard the filters and favorites are not displaying on the left side.

The version info is as follows:

Cache for Windows (x86-64) 2017.2.1 (Build 801_3_18358U) Tue Jul 24 2018 16:38:29 EDT [HealthShare Modules:Core:15.032.8680 + Linkage Engine:15.032.8680 + Clinical Viewer:15.032.8680 + Active Analytics:15.032.8680

Thanks,

LG

0 3
0 147

I'm looking for a means to dynamically specify and/or limit the data from the source that goes into a cube at build time.

I have a single data class that defines my source, and as the data within this table/collection grows/changes over time, I would like to be able to control which records actually make it into the indexed cube, but I'm having a hard time (short of defining a stored procedure to use instead of the extent query) for populating my cube indexes.

0 2
0 145

When creating pivots in DeepSee, there is the ability to group date dimensions by Day, Week, Month, Quarter, Year. For some of our reporting the Week option is desired. However the display looks like the image shown below. Notice the "YYYYW##" formatting.

Is there any ability within DeepSee to modify the display of grouped week dates? E.g. instead of 2020W14 it could be 03/30/2020-04/05-2020, or even just the start or end date, etc.

0 2
1 140

Hello,

I am still trying to figure that Calculated Measure stuff and I hope to learn from you. I have several cubes I am trying to create calculated measures using the Calculated Member Expression.

I have a cube called Cards. There is a measure called count that give total cards count of 15,000. There are two dimensions I am considering. One is the CreditGrade (A, B, C, D, nograde) and the other is the date of the scoredate.(2000-2015).

The CreditGrade dimension has two hierarchies. H1 being the creditnumber and H2 being the CreditGrade (The one I need).

0 2
0 140

Job Title: Software Engineer- IRIS InterSystems

Work Location: Remote

Note:

Main Demand is that we need someone with technical familiarity of IRIS, Familiar with Integration, software development, maintenance, designing, configuration and so on. FHIR good to have. Do not go 100% by the Job description, lets have a discussion and get to know whats exact demand is.

0 0
0 129

When requesting /MDX2JSON/PivotVariables/Patients?Namespace Patients shoud be passed to a method but its not. When argument passed directly into the method it works.

<Route Url="/PivotVariables/:Cube" Method="GET" Call="WritePivotVariablesForCube"/>

Has something changed in IRIS and this syntax is deprecated, or is there a bug and the colon is ignored? What could it be?

This question is continuation from https://community.intersystems.com/node/534811

0 1
0 118

Below is the job description for your reference

Position: Integration Engineer/SME (US only)

Location: Remote

Contract: 12 months

Job Description:

Description:

Looking for IRIS experience must have

Lead the implementation of FHIR (Fast Healthcare Interoperability Resources) standards within the data warehouse, ensuring accuracy and efficient data exchange across the ecosystem of partner APIs

0 1
0 116

Hi Community,

Play the new video on InterSystems Developers YouTube:

InterSystems IRIS Business Intelligence - Tips & Tricks @ Global Summit 2023

https://www.youtube.com/embed/Ekjzny8zj98
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 114

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.

0 0
0 98

Using InterSystems Embedded Analytics March 6-10, 2023 – Virtual 9:00am-5:00pm US-Eastern Time (EST)

This course is offered only a few times each year so take advantage of this session!

  • This five-day course teaches developers and business intelligence users how to embed real-time analytics capabilities in their applications using InterSystems IRIS Business Intelligence and Natural Language Processing.
  • The course presents the basics of building data models from transactional data using the Architect, exploring those models and building pivot tables and charts using the Analyzer, as well as creating dashboards for presenting pivot tables, meters, and other interactive widgets.
  • The course also covers securing models, tools and elements (dashboards, pivot tables, etc.) using the InterSystems security infrastructure.
  • Additionally, the course presents topics such as customizing the User Portal, troubleshooting and deployment.
  • This course is applicable for users of InterSystems IRIS Data Platform, InterSystems IRIS for Health, and DeepSee.
  • Register Here
0 0
0 93

Hello everyone,

I am new to Deepsee (BI intelligence) concepts in IRIS. I am looking for a solution of below question

Question: We have a server where we are currently storing archive PDF reports of our application.

We want to add and view these archive reports (PDF format only) in dashboards. Is there any way we can do this? Or any article which can help us performing this task.

Thanks in advance!!

0 1
0 85

Hi Community,

I have below scenario

We have IRIS BI Reports in my application. I want to create a automated backend utility (similar to background cache system task) which run these bi reports and export them to PDF at a specific path. In dashboard we have defined <property name="print">1</property> which allows report export to PDF.

Now I want to debug the code (line by line) from dashboard to %DeepSee.UI.MDXPDF.cls but I am not sure is this possible or not.

Please suggest. Thanks in advance!

0 1
0 71

Hi Community,

I have below scenario

We have IRIS BI Reports in my application. Now these reports currently being acessed by users through dashboard url's.

I want to create a automated utility (background cache system task) which run these bi reports and export them to a specific path.

I am looking for a system method through which we can open these dashboard url's through code and export the excel report to a speciific path.

Thanks in advance.

0 1
0 52

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.

0 0
0 17