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.
I have a persistent class “sp.SensorReading” which has a number of Properties: Date, SensorName, SensorReading. (sometimes multiple readings from the same sensor, on a given day)
... Temp 28 Jan 33.5 Temp 29 Jan 31.2 Temp 30 Jan 33.1 Temp 30 Jan 34.1 Temp 31 Jan 32.1 Temp 31 Jan 33.1
Hi everyone! My company has a Zen ERP application with CSP delegated authentication. Now, we're developing a separated BI application, using Angular, which consumes DeepSee REST API services. Both applications access the same Caché database.
How to implement single sign-on strategy in order to allow an already authenticated ERP user to access DeepSee REST services? Has anyone already implemented something like that?
When you deploy DeepSee solutions you often do not want grant a User %All Role to work with a particular Dashboard.
Consider a Dashboard 'Dash' with a few widgets where listings are being used.
If you manage a Role to get access to the Dash you need to grant access to %DB_DBNAME resource to have a database access, grant access to a Dashboard resource (if any) and ... grant SELECT accesses to all the tables involved in SQL queries being used in all the listings of widgets.
According to the documentation (2016.1) we can use either a system defined web application (/api/deepsee) or create a custom web application for handling requests. What are some reasons to use one rather than the other?
Hello, I've completed this tutorial: https://community.intersystems.com/post/deepsee-period-date-vs-same-peri... I've used the "year" level instead of a pivot variable. I want to calculate something like the following variation: 100 * ([DateOfSale].[PTD] - [DateOfSale].[LYPTD]) / [DateOfSale].[LYPTD] I create a new calculated member, under the same dimmension with the above expression.
Hello all, Can someone please tell me what will be the steps if I want to override css of deepsee dashboard widgets? Or if it's even possible. Thanks a lot.
I have a series of data organized by time (year and month) so I can use a time dimension to drill down data. So far so good.
However, I need to display the data not by calendar years and months but rather by seasons. The season has 12 calendar months but starts in September. So I'd like to see the data from September / Year N to August / Year N+1 using the same hierarchy as normal time dimension.
Has anyone done something similar?
Obviously, the season can start by any month, not only September :)
My boss would like to change the Ensemble logo that one sees in the mangement portal, because it's part of the DeepSee Anaylzer.
I can see where it lives on the generated html.
I kow that you can set the logo for the User POrtal settings in DeepSee -- you can specifiy a URL for your logo. But we'd like to go one stee further and change the Ensemble by InterSystems to our own logo / company name.
Is it possible to change this in the code? Is there a Configuration setting to change this?
I have to create a pivot that shows the result comparing the last week of the current date with the last week of the last year in the same month. I tried using the function LAG, but didn´t work. Works only if I want to compare the months between the two years. If someone has some idea, i will appreciatte a lot.
Can we use iknow in the Cache tool means if i don't have deepsee tool to work on like for doing some sample programs. Because i don't have deepsee tool with me?
And is there any open source for downloading deepsee?
In iknow they are mentioning that Japanese words cannot be used for iknow in CRC and in CC, If one needs to use iknow for Japanese character how does concepts and relation works for them?
I need to know where i can have good understanding about Deepsee in cache and please provider some example code referring to Deepsee as i am beginner in it. what purpose is it used for ?
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?
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.
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?
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 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.
By update
