IRIS Analytics (DeepSee)

Syndicate content 57 

I need to convert a JSON payload to a custom object type. Currently, I'm converting the JSON object to a %Library.DynamicObject object and need to proceed from here.

As of now, these are my options

                 1. Using an external library talked about in this link:

Last reply 22 January 2020
0   0 2
111

views

0

rating

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. 

 

Thanks In advance

Last reply 23 November 2019
0   0 1
66

views

0

rating

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?

Last reply 20 November 2019
0   0 2
47

views

0

rating

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:

0   0 2
46

views

0

rating

After creating a new dashboard the filters and favorites are not displaying on the left side.

The version info is as follows:

Cache for Windows (x86-64) 2017.2.1 (Build 801_3_18358U) Tue Jul 24 2018 16:38:29 EDT [HealthShare Modules:Core:15.032.8680 + Linkage Engine:15.032.8680 + Clinical Viewer:15.032.8680 + Active Analytics:15.032.8680
 

Thanks,

LG

Last reply 19 September 2019
0   0 2
40

views

0

rating

We have a rest service that collects production status information like whether a connection is disabled, enabled, etc.

I would like to present that data in a DeepSee dashboard but do not know how to create a pivot that accesses the data gathered by the service.

Does anyone have any information or documentation about how a dashboard would be configured to use use a Rest service?

 

Thank you

Last reply 12 September 2019
0   1 2
80

views

0

rating

Hi, colleagues!

Suppose you have large set of cubes, pivots and dashboards in your DeepSee solution.

Then you  change the level, measure or dimension in the cube and is there any way to test that your new input didn't  break current pivots, dashboards, etc?

How to test this?

How do you test your DeepSee solutions?

Last reply 19 June 2019
+ 2   0 4
207

views

+ 2

rating

I want to have a generic PercentOfAll measure that can be used for any dimension of the cube. This PercentOfAll should act like Count, but instead of showing the number of rows in a cell, it will show the percentage  (100*number of rows for that member/all rows) .It should not matter what dimension is being viewed. Ex

There are a total of 100 rows in the source class.

0   0 1
117

views

0

rating

HI

-- 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.

URL I am passing

Last reply 4 February 2019
0   0 2
112

views

0

rating

 Hi Community,

  I am using a method taht calls a Dashboard in Deepsee web  from an application , but I want to know if it's possible  to not showing the header, this part that have the search button, the name of the namespace, etc..

This is the method : 

Method %OnAfterCreatePage() As %Status
{
    //Set contratistaId = $Get(%session.Data("ContratistaId"),"")
    //Set gerenciaId    = $Get(%session.Data("GerenciaId"),"")

Last reply 16 January 2019
+ 1   0 5
276

views

+ 1

rating

Hi community, 

 The question that I have , it's very simple. I developed a pivot that contains two rows, the first it's a date and the other another field. I need to orde by date in descending order and I can´t find where I can do this. I saw that it's a option Sort members, but it's based  in a condition of the measures. 

Can someone help me with this. 

Thanks in advance. 

0   0 2
201

views

0

rating

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);

Last reply 19 July 2018
0   0 3
192

views

0

rating

Hi hi,
  Is there any way to do an automated daily print-to-PDF of a dashboard (its' widgets / pivots etc)?
  I am able to add a "Print" Control to a Widget on a dashboard to do the default DeepSee Print functionality of a Control, but this is manual and browser dependent.
  Is there a way I can either:
    1) have say a scheduled task to automatically print the dashboard (as and instead of the manual Control click) including specifying filename?

Last reply 18 July 2018
0   0 3
206

views

0

rating

Hello,

I have imported my data with the following code (%DocDB).

set filename = "/home/student/Dokumente/convertcsv.json"

IF $SYSTEM.DocDB.Exists("Fitabase1") { 

SET db = ##class(%DocDB.Database).%GetDatabase("Fitabase1")

}

ELSE {

SET db = ##class(%DocDB.Database).%CreateDatabase("Fitabase1") 

}

set arr = ##class(%DynamicAbstractObject).%FromJSON(filename)

SET jstring = arr.%ToJSON()

//SET doccount = db.%Size()

DO db.%FromJSON(jstring) 

0   0 2
182

views

0

rating

Hi.

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.

Last reply 29 June 2018
0   1 2
104

views

0

rating

Hi community,

When I export the cube and the pivots that I made and import to another environment , the calculated metrics and dimension and also de pivot variable didn´t appear in the other environment. Because of this the pivot that use these metrics show error when you try to open. 

I want to know that this behavior is normal or exist a way that you can export everything, independent if you build inside the cube or inside analyzer.  

Thanks.

Jaqueline Krieger

Last reply 19 March 2018
0   0 2
200

views

0

rating

Hi guys,

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:

Last reply 2 November 2017
0   0 2
250

views

0

rating

Hi, Community!

How can I manage to show in MDX query months where every month shows the value of the last month?

Say, in HoleFoods the query:

SELECT NON EMPTY [Measures].[Amount Sold] ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HOLEFOODS]

will show me the sum of revenue per month.

This query:

Last reply 8 October 2017
0   0 0
1,085

views

0

rating

Hi, folks!

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.

Last reply 28 September 2017
+ 1   0 1
203

views

+ 1

rating