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?

0 4
0 289
Carl Campbell · Nov 23, 2019
Clearing my cube of data

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

0 5
0 165
Derrek Kegler · Mar 4, 2017
Calculated Fields
  1. How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day.

  2. How to create a calculated field to show average daily collections divided by the number of the days passed in a month. So, for today, it would be the average daily collections divided by 4days.


0 3
0 397

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:

0 6
0 367
Tuan Minh Do · Jul 16, 2018
%DOC with DeepSee


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



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 2
0 308

I currently have an MDX query/calculated measure as per the below:

[DaysOnListRange].[H1].[DaysOnListRange].&[Days 91 - 180]+ [DaysOnListRange].[H1].[DaysOnListRange].&[Days 181 - 365]+
[DaysOnListRange].[H1].[DaysOnListRange].&[Days 365+]

however it currently doesn't sum when there is a blank in the data.
How can I amend this query to include empty cells/only sum cells with data?

I've tried using nonempty but it doesn't appear to work in this context

0 2
0 346
Ponnumani Gurusamy · Feb 11, 2018
Deep see Learning

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.

Thanks ,

Ponnumani G.

0 1
0 178
Derrek Kegler · Mar 7, 2017
Grand Total

How can I create a calculated field that will give me the grand total of a column? For instance, if I have a row that has 200, 300, 500, 600, how do I get the Grand Total?

I have already used the wrench under Column Options as % of Total so, I can't use that option.

0 9
0 331