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.
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 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.
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:
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.
I am trying to calculate a dimension percentage for WFRole on a child cube named MbMRouteHistoryInitiatorObj joined to a parent cube named MbmQaSObj by using a calculated member dimension within MbmQaSObj.
If I use the calculated member dimension value expression of [WFRole].[H1].[WFRole].CurrentMember/ [WFRole].[All WFRole].%ALL in the child cube MbMRouteHistoryInitiatorObj, the percentages work correctly.
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?
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 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 that lists services, processes, and operations information and wanted to make the names of the items more user-friendly to end users and to use a flag to determine which components would be displayed in the dashboard.
We created another table/cube that has a status flag (1/0) to determine whether we would look at the item, the existing name, and the human-readable name.
What is the best way to reference the data in the new cube from the original cube to use the human-readable name?
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?
I tried using the DeepSee Troubleshooting guide but the suggestions weren't working. Let's say that the source data we are using to build the cube on has a value out of range. This would cause the cube build/update to fail. How do I see the error log that explains which field has the value out of range? Please be detailed on exactly what command I should enter and where I should enter it in.
Hi, I cannot edit properties (title etc) of Widgets within Dashboards outside of the ENSDEMO namespace: I have a namespace "HL7Report" for example; I have some Pivots created looking into a cube's data; I click "DeepSee", "User Portal" from the Management Portal; I click "+", "Add Dashboard", folder/name/title/category all as "new", "OK", new dashboard appears; I click ">", "Widgets >", "+", and select a pivot to display as a table (chart / anything);
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?
How do I best create a filter in DeepSee to restrict query results for the current login, that is where the results are filtered by a Dimension compared to the ObjectScript special variable $USERNAME or an ObjectScript expression that restricts what the current user is allowed to see?
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.
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 ?
By likes
.png)
.png)
.png)
.png)
.png)