InterSystems IRIS BI (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.
-- 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'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.
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 am looking for a reporting tool (Analytics purpose) which can be built using cache object script/MUMPS. Basically my requirement is to find a tool where I can implement cache code to report data for my application.
I am unaware of DeepSee and how it works. Please assist for the same.
I am programming a daily reporting that will send by e-mail when people will add a dashboard as favorite by clicking on the star :
I asked Intersystems WRC on how to automatically generate a report with some line coding, but I heard there is no way to do this without a headless Browser.
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 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?
Since I'm just starting to use this aspect of IRIS I can't tell if this is a bug or some kind of nuance. If I run a single column query like this, I get results:
However if I try to retrieve using a DISTINCT or GROUP BY, I get no results:
And again except with a GROUP BY, with no results:
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.
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
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 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.
I tried to learn DEEP SEE Analytics for our HealthShare "SAMPLES" Name Space. I followed our documentation and tried it. But my management portal analyzer and visual reporting fields are hidden. So Please help me for how do I use the deep see concepts and provide some examples or demo.
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
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 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.
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.
Hi I am experienced with Ensemble but working in my first DeepSee project, so forgive me if this seems elementary.
My question is, how do I clear the data out? Every time I build I am adding more and more data. But I would like to revert my cube to being 0 so I can reload it and start over? Set my row count back to 0?
I am unable to remove/purge through the management portal
-I've tried to kill my cube Do ##class(%DeepSee.Utils).%KillCube("MyCube.Cube") and then Rebuild it.
The >/</= etc. operands in named filters are great... except they won't work with measures ('native' or calculated - and what a boon it would be if they could work with both).
Are there any plans to add this capability?
And are there any plans to have a 'named filter' control within widgets that would let you change the operand?
In the MDX Query Tool I can't seem to get the NOW relative syntax to work correctly. If I just use ".&[NOW]" it works, but something like ".&[NOW-1]" or ".&[NOW-1d]" (for dates extracted using DayMonthYear) it throws an error.
So this works:
But if I change .&[NOW] to .&[NOW-1] I get this cryptic error message.
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.
By views
.png)
.png)
.png)
.png)