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 67
Question
Chip Gore · Jul 24, 2018
Combo Chart scaling question...

Hi -

I'm trying to get my Combo Chart to dynamically scale the Y axis, but it's not doing what I would like. The 1st Y series, if the MAX value is set to null, scales the chart and the series fine, but then the subsequent Y axis are not to that same scale. Each "null" Max'ed series is setting it's own scale based only on it's own ranges and not in sync with anything else.

Is there a way to force all of the "null" scaled columns to be in the SAME scale as each other AND be dynamic.

0 1
0 180

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"

0 2
0 233

Hi All, We have been using DeepSee which has been the integrated Analytic Dashboard built over Cache Cubes. It works fine but it's visual capabilities are limited and most probably is getting phased out. If I am not wrong, Tableau is the suggested alternative to DeepSee . It is expensive and a big and considerable shift from existing technology I wanted to get an opinion of the community as to these few key points - What other BI tools others have been using with IRIS and what have been their experience - For which tools are the best inbuilt support / api's avaialble in IRIS

2 10
0 405

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 

0 2
0 165

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 107

greetings Community!

InterSystems Learning Services is working to identify and create libraries of high-quality learning resources for third-party technologies, platforms, and systems that are part of, integrated with, or commonly used with InterSystems products and technologies. we don't create content for these ourselves, but want to support our clients, external and internal, in learning about them and how to use them.

2 2
0 207

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 121

I was having trouble with some dimension based calculated members defined in Analyzer.  They would work and then not work.   At one point I had two identical calculated measures, same code, same specification and one would work and one would not.  I was trying to set them up in "shared storage", that checkbox in the calculated member dialog that should allow the measures to be used across multiple pivots. 

0 2
0 134
Question
JAQUELINE KRIEGER · Aug 27, 2018
Order by date

Hi community, 

 The question that I have , it's very simple. I developed a pivot that contains two rows, the first it's a date and the other another field. I need to orde by date in descending order and I can´t find where I can do this. I saw that it's a option Sort members, but it's based  in a condition of the measures. 

Can someone help me with this. 

Thanks in advance. 

0 3
0 559

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 108

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:

0 4
0 176

Since I'm just starting to use this aspect of IRIS I can't tell if this is a bug or some kind of nuance.  If I run a single column query like this, I get results:

However if I try to retrieve using a DISTINCT or GROUP BY, I get no results:

And again except with a GROUP BY, with no results:

0 2
0 171

Hi everyone, 

I'm creating something to test the Analytics capabilities. 

I have a table with 100k records. Consulting the data using ^%G or SELECT, everything is working fine. 

But, when I create a Cube using this same class as Source, the Build results in only 1 fact.

I would like to know if anyone else faces the same situation before and have some guidance. 

Some details:

1 6
0 156

Hello Community, 
I hope you're going well.

I am programming a daily reporting that will send by e-mail when people will add a dashboard as favorite by clicking on the star :

 

I asked Intersystems WRC on how to automatically generate a report with some line coding, but I heard there is no way to do this without a headless Browser.

0 4
0 184

Hi, Community!

I'm using Git with DeepSee and when I need to do a commit to the git repo I'm exporting ALL the pivots and dashboards from the namespace. But I can forget to do that) And it can take time for a large system.

What is the way to manage automatical export of DeepSee artefacts which we are editing in UI (Cubes, Pivots, Dashboards, Pivot Variables, Term lists, Shared Measures) into files every time when I push Save button?

0 5
0 339

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

0 1
0 155