New post

#InterSystems IRIS BI (DeepSee)

25

InterSystems Business Intelligence enables you to embed business intelligence (BI) into your applications so that your users can ask and answer sophisticated questions of their data. Specifically, your application can include dashboards, which can include the following:

  • Interactive widgets that execute queries designed for specific user roles or for specific areas of your user interface.
  • Controls such as drop-down lists and data choosers that enable users to modify these queries.
  • Interactive drill options that enable users to view the displayed data in different ways.
  • Options to export, print, and send alerts to other users.
  • An option to launch the Mini Analyzer, which supports free-form analysis.
  • Execute custom actions that are provided as buttons or other controls.

In contrast to traditional BI systems that use static data warehouses, Business Intelligence is kept closely in synchronization with the live transactional data, as required for your business.

Learn more.

Question
· Mar 7, 2017
Grand Total

How can I create a calculated field that will give me the grand total of a column? For instance, if I have a row that has 200, 300, 500, 600, how do I get the Grand Total?

I have already used the wrench under Column Options as % of Total so, I can't use that option.

0 9
0 395

Hi everybody,

I have to create a pivot that shows the result comparing the last week of the current date with the last week of the last year in the same month. I tried using the function LAG, but didn´t work. Works only if I want to compare the months between the two years. If someone has some idea, i will appreciatte a lot.

Thanks.

Jaqueline Krieger

0 4
0 322

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 429
Question
· 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 244

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 450
Question
· Nov 23, 2016
DeepSee: Filtering a filter

When creating a filter located on a dashboard that targets all, is there a way to narrow that filter down?

For example, in our data we have some dates that are well out of range due to data quality issues, but they still appear in the drop downs. Is there a way to say, only make available the below dates in the filter?

Another example, If we want to only look at Emergency data, it still provides all the wards for inpatient activity and activity in other hospitals, meaning, to get to just the Emergency wards you have to scroll through everything?

Hope that makes sense.

0 4
0 451

Hi,

I want to include Info icon on DeepSee-Widget title bar like the image below. And when I click or hover on the icon it should display some information about the widget. I tried with the options available in Widget settings and referred InterSystems's documention as well, I couldn't find a way to get this.

Please help me to achieve this. Thanks in advance.

0 4
0 299

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 183
Question
· Nov 30, 2016
Accessing Deepsee plugin in MDX

Dear All,

From my web page, i am passing filter values to mdx query.

when mdx executes, i am getting Error #5001: Invalid member expression: empty name(2).

when i try the same in samples namespace (patient cube). I got the same error.

Below is my sample MDX from patients cube.

SELECT 
NON EMPTY %KPI("PluginDemo","HighScoreCount",,"%CONTEXT") 
ON 1 
FROM [PATIENTS] 
%FILTER %OR([HOMED].[H1].[ZIP].&[32000])

Result: 0 This works fine.

0 3
0 402

Hi community,

When I export the cube and the pivots that I made and import to another environment , the calculated metrics and dimension and also de pivot variable didn´t appear in the other environment. Because of this the pivot that use these metrics show error when you try to open.

I want to know that this behavior is normal or exist a way that you can export everything, independent if you build inside the cube or inside analyzer.

Thanks.

Jaqueline Krieger

0 3
0 388
Question
· 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 697
Question
· Aug 1, 2019
DeepSee security issue

Hey Guys,

Have enabled DeepSee on my cache db via 

Do EnableDeepSee^%SYS.cspServer(0)

I have created user with access to a profile with all the %Deep_See options (%DeepSee_Admin, %DeepSee_Analyzer etc etc) as well as %All. I have also added %All to unknownuser

When click the DeepSee page and choose a namespace Architect, Analyzer, Reporting Data Definition and Reporting Builder are all greyed out with 'you do not have privilege to view this page

0 3
0 228

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 235

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 157