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?

0 2
0 34

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.

0 5
0 89

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.

0 2
0 98

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

0 1
0 121

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.

<Route Url="/PivotVariables/:Cube" Method="GET" Call="WritePivotVariablesForCube"/>

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

0 1
0 184

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

0 2
0 190

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 243

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 177

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 213

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 214

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 252

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 208

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 534

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 443