Hi Everyone,

We are using SQL based KPI's to display reports in IRIS dashboards. We have applied the filter functionality in these SQL based KPI reports.

I need your help for below scenario.

Below is my full report. Filter is applied on Name and Subject Name in this report.

Now I have used filter on Name and selected values 'Virat' and 'Big Show'

0 1
0 61

Hello everyone,

I am working with InterSystems IRIS and seeking guidance on how to perform specific tasks related to the FHIR SQL Builder using commands or code, rather than the graphical user interface (GUI). The specific tasks I am trying to accomplish are:

1 4
1 136

Hi Community,

I hope this message finds you well. I am reaching out because I have encountered an issue with a new dimension I created, named "Region," and I could use your assistance in resolving it.

The problem is that when I open the cube analyzer, the "Region" dimension does not populate data as expected. Instead, it merely displays the text "sourceRegion," which I specified as an expression in the architect.

0 1
0 87

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 116

Hello community, I need to solve a complex but trivial issue.

Given:

Two tables "Comment" and "Post". Each one contains an "Author" field, which is essentially a user ID. In these tables, each user ID represents an author. The goal is to count all participants together and then group them by month, language, and other metrics.

The question is how to do this within the IRIS ecosystem. Is it even possible to take two tables, get distinct data from them and then combine into one cube?

0 1
0 147

Our team has had success creating and publishing Power BI reports using an ODBC connection to an IRIS database, but there have been concerns about the responsiveness of these reports.

As an attempt to improve responsiveness, I'm trying out the "DirectQuery" connection using the InterSystems IRIS connector available in our version of Power BI Desktop (September 2021).

The version of IRIS I'm connecting with is "IRIS for Windows (x86-64) 2022.2"

0 3
0 1.2K

I built a dashboard to show hourly instrument capacities based on a term list. The term list consists of the TestInstrumentID and the number of tests that instrument can perform in 1 hour. The calculation works correctly and the data is accurate but periodically if you go to check the dashboard the percentages all get changed to 100% across every hour. If you check it later or add an additional site to the filter then the percentages correct themselves. I don't know what's causing this or how to troubleshoot it because it does calculate correctly but is not consistent.

0 6
0 204

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

0 2
0 207

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?

0 2
0 387
Question
· Oct 6, 2022
MDX Syntax Help

we have this container code where we want to create more CalcMember properties

<sharedCalcMember FullName="HSAAPATIENT||DEMOGRAPHICS||CITIZENSHIP.NATIONAL.sharedCalcMember" Dimension="Demographics" Name="Citizenship.National" Expression="[Demographics].[H10].[Citizenship].&amp;[USA]" SolveOrder="0" CubeName="HSAAPATIENT" UpperCaseDimension="DEMOGRAPHICS" UpperCaseName="CITIZENSHIP.NATIONAL"></sharedCalcMember>

0 3
0 176

Hi guys,

Does rebuilding of Data Quality Manager cubes affect patient index linkage definition data?

What I want to understand is, does DQM have any negative impact on the data each time you rebuild the cubes.

Additionally, if I make changes to the cube and rebuild it..will this have any impact on the original data?

0 6
0 330

Hi,

I have 3 simple tables: Encounter, Patient and Immunizations. Encounter makes a reference to Patient, and Patient contains a list of Immunization objects.

I've tried using PowerBI to access IRIS (using ODBC connector, not InterSystems BI connector), PowerBI reports the error:

Expression.Error: The column 'Patient' of the table wasn't found.
Details:
    Patient

it does this for two of the three tables I need only (Patient and Encounter), but not for Immunization IRIS table..

0 1
0 191

I have an SDA feed from an Edge server that eventually is fed into HSHI / Analytics. This edge server is loading up patient demographics (in the Patient object), which feeds the HSAA.Patient table in HSHI / Analytics.

However, we have other edge servers also feeding into the same HSHI database, and these other edge servers have better demographic information.

1 2
0 300

Is there a way to add/substract from a pivot variable?

I have this MDX:

SELECT
  NON EMPTY [DateOfSale].[Actual].[YearSold].&[$variable.Year] ON 0,
  NON EMPTY [Product].[P1].[Product Name].Members ON 1
FROM [HOLEFOODS]

And with pivot variable Year equal to, say, 2016 it works:

Now I want to add previous year first with one pivot variable and one explicit reference. It also works:

0 3
0 117

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 149

Dear Folks,

I have recently studied deepsee and developed few dashboards needed for our web app users. I am trying to embed them in our existing web app which uses angular with delegated user access. I need to embed the native IRIS dashboard into it. ( I can't use Highcharts or any other js tools).

How do I setup the dashboards to work with delegated authentication (Without providing access to management portal or other parts) ? Also should I use the default csp/{Namespace}/_DeepSee.UserPortal.DashboardViewer.zen? or any other web application URL ?

Thanks

0 1
0 186