InterSystems IRIS Analytics (DeepSee) is a Business Intelligence (BI) technology that enables the real-time analysis of transactional data, and is designed to be optimal for embedding within transactional applications.
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.
Pivot tables created in DeepSee Analyzer can be used in user dashboards. Pivot tables analyze the data based on the dimensions and measures defined in the cube or subject area. Column and row totals can be added to a pivot table in a variety of ways.
DeepSee MDX supports several statements to generate a pivot or listing. SELECT is the most used statement. DRILLFACTS and DRILLTHROUGH return detail row information from the fact table and source table respectively.
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'm trying to immigrate some of my HealthInsight dashboards and pivot tables to another HS instance.
In some pivot tables, I defined them with a set of calculated dimensions defined in the analyzer, e.g as below:
Then when I exported the cubes and pivot tables in used to my new envirmonment. When I open my pivot tables again, the calculated dimensions are missing and hence my pivot tables no longer work:
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'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.
Best-in-Class companies leverage strategies for embedded BI in order to exploit the widespread nature of their existing toolsets, equip more business users with analytical firepower, and ultimately drive substantial business performance improvements.
Paul Grabscheid, InterSystems Vice President of Strategic Planning, talks about embedded real-time business intelligence capabilities and InterSystems DeepSee.
The DeepSee MDX Shell allows execution of MDX statements in a terminal session. The WITH clause, as well as the CREATE and DROP MEMBER and CREATE and DROP SET statements are also demonstrated.
I have a dashboard which shows the growth of the months compared with the month from the last year.
The way I found to develop that, it was with a kpi. So, I overrode the %OnLoadKPI method with two mdx:
SELECT NON EMPTY [DataD].[H1].[MothYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2016]
SELECT NON EMPTY [DataD].[H1].[MonthYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2015]
I am trying to figure out how to compare two dimension values in a MDX query such that records where two dimension values are the same will be filtered out.
To test this, I have modified the HoleFoods cube in SAMPLES namespace to have a new dimension called RandomRegion
I want to create a MDX query where the [Outlet].[H1].[Region] value is not equal to the [RandomRegion].[H1].[RandomRegion] value.
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.
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 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.
By likes.png)
.png)
.png)