#InterSystems IRIS BI (DeepSee)

In DeepSee, having a customer account cube. The cube includes a time dimension AccountCreationDate.

How do you create a calculated measure to get the total number of accounts from the beginning to a certain date in abscissa ?

I tried many things including this:
AGGREGATE(%TIMERANGE([AccountCreationDate].[H1].[MonthYear].&[190001],[AccountCreationDate].[H1].[MonthYear].CURRENTMEMBER) ,[Measures].[%Count])

But I don't get the right result because the date in abscissa creates a filter on the first date.

Hi all,

I have a dashboard which shows the growth of the months compared with the month from the last year.

The way I found to develop that, it was with a kpi. So, I overrode the %OnLoadKPI method with two mdx:

SELECT NON EMPTY [DataD].[H1].[MothYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2016]

SELECT NON EMPTY [DataD].[H1].[MonthYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2015]

Learn the fundamentals of how and when to use the DeepSee Analyzer.

A customer needs to add lines in the Excel sheet before the MDX resultset content.

Is there a more elegant/convenient way than modifying %DeepSee.UI.MDXExcel methods ?

Thanks in advance.

Sylvain

Good afternoon!

Is this a good place to find a fellow developer with specialization in IRIS? I have an opportunity and looking for someone with significant experience (10 years).

It's a two and a half year contract, fully remote. Please let me know if you are interested in speaking about the opportunity.

More info here: https://teckpert.applytojob.com/apply/TudQizeFx2/Senior-Database-Manager...

Best,

Gabriel

TECKpert

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!

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!!

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.

Suppose I created a new DeepSee class to display a new item in the dashboard.

DeepSee.Component.datePick

Wich, in general, is just a copy of a similar class in %ZEN with minor changes. I need to include it in the base install. How can i do this? Am I ever allowed to change the composition of system classes?

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

When requesting pivot variables from a cube, a 404 error is displayed. What's the problem? Is it IRIS or is it API?

<HTML>

<HEAD>

<TITLE>Not Found</TITLE>

</HEAD>

<BODY>

<H1>Not Found</H1>

The requested URL /MDX2JSON/PivotVariables/Patients was not found on this server.

</BODY>

</HTML>

Hi

I have a pvot table defined. that generates a set of data. I want. to. execute the pivot table programatically which I believe involves using %DeepSee.ResultSet. Does someone have an example showing how to apply filters to the results?

For. example

[DateTime of Filing].[Date].[Date Filed Year] = &[2023]

Thanks

I would like to define an advanced filter within my pivot table that allows me to look at diagnosis codes, or at procedure codes - but I do not want to hard code values within the pivot table definition (get the %OR defined).

I would like to be able to allow my dashboard user to chose what specific diagnosis codes or procedure codes they are interested in. So for example one user may want to look for # of patients with cancer dx or patients who have had a radiation procedure.

How can I accomplish this OR feature using dashboard filters?

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).