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.
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.
Using cube CubeA and cube CubeB that contains calculated measure TotalClients. I would like to use TotalClient calculated measure from a compound cube CubeC (CubeA,CubeB).
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 would like to pass multiple values of a FILTER from one DeepSee DASHBOARD to another DeepSee DASHBOARD. The documentation indicate this can be done via an URL. Are there any examples this type of configuration?
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.
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.
I have a cube with two dimensions, DimA and DimB, with the following structure:
DimA/H1/LevelA
DimA/H1/LevelC
DimB/H1/LevelB
DimB/H1/LevelC
LevelC is modeled in such way because its bound property (C) is group by properties A and B in transactional database, but A and B haven't relation.
I can use DeepSee REST API service /Info/FilterMembers/:datasource/:filterSpec specifying each dimension one filterSpec parameter and handle the results.
But, I would like to have the results for both dimension in only on service call.
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.
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.
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:
-- 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.
I built a dashboard to show hourly instrument capacities based on a term list. The term list consists of the TestInstrumentID and the number of tests that instrument can perform in 1 hour. The calculation works correctly and the data is accurate but periodically if you go to check the dashboard the percentages all get changed to 100% across every hour. If you check it later or add an additional site to the filter then the percentages correct themselves. I don't know what's causing this or how to troubleshoot it because it does calculate correctly but is not consistent.
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
My testers are getting this Internal Server Error inconsistently. There is no specific steps to reproduce this error. Can you any one explain when will we get this error in DeepSee.
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]
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
By views
.png)