#InterSystems IRIS BI (DeepSee)

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

Is there any open source tool like Power BI or Tableau that works well with IRIS? Thx!

How Can I resolve this?

ERROR #5001: Failure to determine first and last IDs in source table 'dc_irisbi.KeyResult'. Check indices on the source.

I trying to use this class in a deepsee cube, when I build, I get this error

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.

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

Is it possible to create a pivot table with a column containing a clickable hyperlink using a field from the cube definition as a part of the link?

Following instructions on this page https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=D2IMP_... I am trying to create a Data Connector to be used as a base class for a cube with update support.
That page suggests that putting an SQL query inside XData block is not suitable for a Data Connector that supports updates.
Later it also suggests that to enable updates your SQL query must include 

How do we return a member from a set?  For example if I want a calculated measure to return the NAME of the date with the max transactions, to get the set ordered I might do something like:

ORDER([TransactionDate].[YearMonthDate].[Date].MEMBERS, [Measures].[TransactionCount], DESC)

But how do I access the first member in the set as a member so that I can get to the properties such as the member NAME (what I want to return in this case)?

In some MDX implementations like Microsoft there are kind of backdoor functions for this like:

Is it supported to be able to use member functions to define a set, in particular a set defined with a member range in the form:

set = member1:member2? 

The docs only show hardcoded values being used for member1 and member2 and I can get it to work if I use hardcoded values.  However if I try to use member functions it throws an error:

"ERROR #5001: Both parts of a range must be members"

In the MDX Query Tool I can't seem to get the NOW relative syntax to work correctly.  If I just use ".&[NOW]" it works, but something like ".&[NOW-1]" or ".&[NOW-1d]" (for dates extracted using DayMonthYear) it throws an error.

So this works:

But if I change .&[NOW] to .&[NOW-1] I get this cryptic error message.

What is the shortest frequency of time I can set to have Cubes rebuilt.

Hi InterSystems Community,

Is there a way to have a logarithmic axis in a DeepSee widget?

Thanks,

Reid

As the title mentions, I'm trying to determine how best to handle an issue with nested data.  Essentially I have a setting like the following:

Object A has a transient property with an array of Object B. I want to create a level with a list of Object B.  I also want this level to contain properties belonging to each object B. 

So I have a layout of something like

Surely there is an easy way to invoke a ClassMethod from a DeepSee detail listing line, in a similar way to launching a URL.  In this case I need to do a little preprocessing of a request adding a SAML token.

I thought I knew how to do it long ago, but I can't read my faded notes on that old parchment.

-Kevin