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.
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
Is there a way to add a scroll bar to a widget on a dashboard. I want to shorten the width of my bar graph widget but it causes the bar graph to be scrunch together. Also, is there a way to expand the width between each bar on the graph?
How to setup dollar ranges to get the number of patient accounts. So, I want to capture the number of patient accounts based on the original balance of:
0 to 499
500 to 999
1000 to 2499
5000 to 9999
10000 to 24999
25000 to 49999
50000 to 74000
75000 to 99999
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.
This year while at the Global Summit, I came to learn of a component that Stephen Morrison of Intersystems had written that was capable of infusing SVG content into a PDF document. Apparently Stephen was approached about this and was amenable to sharing the code with us as we have recently encountered a similar need. I'm hoping this post will lead to the sharing of this utility code, so that we can determine if it will indeed suit our need.
I'm looking for a means to dynamically specify and/or limit the data from the source that goes into a cube at build time.
I have a single data class that defines my source, and as the data within this table/collection grows/changes over time, I would like to be able to control which records actually make it into the indexed cube, but I'm having a hard time (short of defining a stored procedure to use instead of the extent query) for populating my cube indexes.
The situation is, I have a Partner that is looking to create common Dashboards in a SaaS model where the Partner's Clients would want to have their individual views of this common dashbaord be branded (logos, color, styles, etc.) to match the Client's branding. This my Partner's Client's End Users will see this common dashboard as the dashboard from the "Client" and not the "Partner" (and certainly not ISC branding)
In looking at the Production monitor within Ensemble, I was wondering if there is a way we could customize it for our use. I notice it is basically a dashboard.
For example I would only like to truly display those Services, Processes, and Operations that are truly in dire need of attention. The Monitor out of the box just seems too busy, and I would like to simplify it.
Is it possible to lock down health insight so a client can only query their own patients? and
Is there a way to use a visualization tool like Tableau instead of the dashboard of DeepSee while still querying from DeepSee?
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.
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.
In DeepSee, having a customer account cube. The cube includes a time dimension AccountCreationDate.
How do you create a calculated measure to get the total number of accounts from the beginning to a certain date in abscissa ?
I tried many things including this:
AGGREGATE(%TIMERANGE([AccountCreationDate].[H1].[MonthYear].&[190001],[AccountCreationDate].[H1].[MonthYear].CURRENTMEMBER) ,[Measures].[%Count])
But I don't get the right result because the date in abscissa creates a filter on the first date.
Hi! I am working on a project and I am facing a weird problem. I have created an MDX using Analyzer. This MDX executes very fast. I am trying to automate its execution with %DeepSee.ResultSet and the query never returns:
Set tSC = oMDX.%PrepareMDX(tMDX)
Quit:$System.Status.IsError(tSC)
Set tSC = oMDX.%Execute()
Quit:$System.Status.IsError(tSC)
What could be causing %Execute() to take so long to run while Analyzer is responding fast?
I need to pass multiple values to a FILTER to a DeepSee DASHBOARD via the URL. The documentation seems to indicate this can be done, i.e.: "Where each filterspec is filter_name.filter_values" but there are no examples I can find that indicates what is used to separate multiple values. Say I want to pass the three values 5, 6, and 1395 to a filter. To pass just the 5 I know this works:
&SETTINGS=FILTER:LEAD.MYUSERID.H1.MYUSERID.5
but how do I include 6 and 1395. None of the following seem to work:
Aside from doing a print to PDF is there any way to use the existing DeepSee "export to PDF" functionality to export the entire dashboard rather than each individual pivot or chart?
I would like to know if DeepSee has some feature regarding synchronization which could help me with this:
I have two tables, TableA and TableB in a 1:n relationship, and one cube for each table, CubeA and CubeB. CubeA have a list dimension based on records from TableB. Both tables has DSTIME parameter set to "AUTO".
Some application proccess updates data only on TableB, leading an entry on ^OBJ.DSTIME global for synchronization of CubeB. However, as the TableA wasn't updated, there isn't such entry for CubeA.
-- We have our Pivot ready for some data for all accounts. And we want to now filter it by Account
[Account].[H1].Account.&[1]
It works fine at the pivot level and it filters the records. We save the pivot with no filter values as we want users to decide the Account they want to filter for
-Now If i save this pivot without a value of a filter , then obviously it has all records and I want to filter it at the Dashboard level on my page.
Class DSW.Addons.htmlViewer Extends %DeepSee.Component.Portlet.abstractPortlet
{
Property Data As %String;
ClassMethod %OnGetPortletSettings(Output pInfo As %List, ByRef pSettings) As %Status
{
Kill pInfo
Set pInfo(1) = $lb("Data", , , "Data", "Data setting")
Quit $$$OK
}
}
It's a ZEN component and DeepSee portlet. It's immediately available in the namespace I created it in. DSW package is mapped to %ALL and to Samples, but if I try to create a widget with this portlet I get ZEN class not found error.
I want to know how I can see all of the export options when the widjet is located in the below part of the window. This example is the deepsee web demo, but it's passing in my real application and I can´t move to another place.
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?
By replies
.png)
.png)