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.
I have a pvot table defined. that generates a set of data. I want. to. execute the pivot table programatically which I believe involves using %DeepSee.ResultSet. Does someone have an example showing how to apply filters to the results?
For. example
[DateTime of Filing].[Date].[Date Filed Year] = &[2023]
I am building a pivot table and need help creating a calculated field for a dollar range. For instance, I am trying to create a calculated field to show account balance greater than $5k and less than $10k.
I am moving some DeepSee components to another environment and would like to know if the pivots and dashboards have to reside in the "Other" branch of the Workspace in Studio.
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
suppose a part of my mdx query is [DIMENSION].[H1].[LEVEL1].CURRENTMEMBER.Property("PROP1").
If the source property of PROP1 is also used as a dimension level somehwere in the cube, this query will return a key to the entry in the coresponding star table.
Does anybody know how I can follow that key and display the real value value?
The row expression defines what dimensions and measures appear on the rows of your pivot table as well as how they appear. Sets and CROSSJOINs are used.
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.
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.
Sometimes I need to filter the widget on a dashboard from a different cube. And I face the following problem:
Widget A refers to a query from Cube A and I want to filter Widget B from Widget B.
Widget's B pivot refers to Cube B, and which has different dimensions for the same data.
E.g. cube A has the dimension Author and the Cube B has the dimension Member for the same data. So there is no way to filter such a widget B from the widget A.
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 ?
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?
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.
My group needs to be able to monitor items / tasks, and let a non-management-portal user see the monitoring. Is it possible to run DeepSee queries on Production items? I feel like I should not be recreating the production environment or the task manager just so that I can query on the items that are running, and on their states (like "successful" or "send email").
Also, I need to log custom events for each task, and I'm running into difficulties with the task manager in this regard; hence the question about using the Production instead, but querying it.
Can someone tell me if intersystems-ru/deepsee-sysmon-dashboards is developed for a specific version of Ensemble? Looks like it could be useful to my group but we aren't upgrading till later this year and we are on 2015.2.2.
Working on "HealthShare 2019.1 [HealthShare Modules: Core:17.0.9941 + Patient Index:17.0.9941 + Clinical Viewer:17.0.9941 + Active Analytics:17.0.9941] - Cache for Windows (x86-64) 2018.1.1 (Build 312_1_18859U) Tue Mar 19 2019 00:43:30 EDT"
In creating a DeepSee Cube - Pivot - Dashboard I am not finding out how to sort my rows by the row label value.
My Rows are numeric values, but they are sorting lexically not numerically. By this I mean that given the Row Values 1, 2, 3, 10, 100 the rows ar being displayed in the Analyzer in the alphabetic order of:
I was wondering if there was a DeepSee overview document available for a non-technical user. Something short and concise describing what DeepSee is and its key features.
I've looked at the documentation and although there are parts of what I am looking for there it is much too technical for my needs.
I have a cube that lists services, processes, and operations information and wanted to make the names of the items more user-friendly to end users and to use a flag to determine which components would be displayed in the dashboard.
We created another table/cube that has a status flag (1/0) to determine whether we would look at the item, the existing name, and the human-readable name.
What is the best way to reference the data in the new cube from the original cube to use the human-readable name?
Has anyone implemented the 'DeepSee Visual Reporting' tool in realtion to TrakCare? If so, has anyone used it to customise Zen reports for TrakCare questionnaire preview/printing?
Is there any way by which we can incline the Value Labels in Bar chart like on top of bar or outside of bar in InterSystems Dashboard like Other reporting tool.
I am new to Deepsee (BI intelligence) concepts in IRIS. I am looking for a solution of below question
Question: We have a server where we are currently storing archive PDF reports of our application.
We want to add and view these archive reports (PDF format only) in dashboards. Is there any way we can do this? Or any article which can help us performing this task.
is there any mechanism available in DeepSee to keep values of AGE dimension up-to-date without rebuidling cube? Can age be determined at the mdx query execution time?
Hi All - Been looking in the documentation to see if, in DeepSee->Analyzer there's a way to create a filter on the "Most" recent date in a dimension. The filter affords the ability to choose "Now" but sometime the most recent date in the data was a week ago.
By replies
.png)
.png)