#InterSystems IRIS BI (DeepSee)

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:

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:

SELECTFROMSELECT

This 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?

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:

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.

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?

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

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, 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?
 

Hi All,

I am working on SQL based KPI in IRIS BI. I want to remove below highlighted search text box in "auto" filter type.

We cannot use other type like only dropdown etc. Is there a way we can do this ? 

One way I can see is writing own control instead of using default control but I am not aware how to do this. I didn't find any sample code for this. 

Is there any sample code available for writing custom control which I can refer.

Please assist

Hello all,

Currently I am trying to create a pivot table based on a cube with several calculated measures that perform a distinct member count, as in https://docs.intersystems.com/iris20231/csp/docbook/DocBook.UI.Page.cls… . However, when I add these measures as the columns of the pivot table, the resulting row generation step can take a long time (at least five minutes). This includes row generation when performing drill-downs.

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? 

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.

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

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

    <TITLE>Not Found</TITLE>

    <H1>Not Found</H1>

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

Hi All,

I'm looking to write a 3rd party front end for BI cubes and have been directed towards the REST API here: https://docs.intersystems.com/iris20222/csp/docbook/DocBook.UI.Page.cls…

I've had quick test using postman and can use those fine, the issue I have is that there are some areas of metadata not exposed by the api that are essential to write a front end tool. I can list the cubes and measures using the /INFO/ paths, but that seems to be the limit of what is available.

does anyone have an example of using %DeepSee.Utils:%GetDimensionMembers where you want to apply certain filters

For example I have a date dimension that I want to get all of the months level but filtering for only a specific year.

Thanks

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

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

Anyone know why and how to fix  ?

Thanks - Steve