Article
Peter Steiwer · Dec 31, 2019 3m read
Portlets that use data from DeepSee


In the previous part of this series, we saw how to reference a web page that will enhance our dashboard experience. Now we will look into referencing data that is already in our cubes.

In this example, we will be referencing the controller object and we will be extracting data from it. This data will then be displayed as text in our Dashboard. In Part 5, we will show how to incorporate this data into other charting libraries.

2 0
0 176

In the previous part of this series, we saw how to define a basic portlet. Now we will look into making this portlet reference a web page that will enhance our dashboard experience.

In this example, we will be embedding a Developer Community article along side a couple of widgets displaying information related to the number of views on the Developer Community articles. This example is not hosted on the Community Analytics server, but if it was we could see the view counts going up as we interacted with the page.

Why use this?

In a real case, perhaps you have an embedded page from an external web site showing the current Emergency Room wait times for Hospitals in your area. This portlet can be used along side widgets from your Emergency Room showing how many people are waiting, how many doctors are active, and how many people are being treated. As other Emergency Room wait times grow, you can possibly expect your volume to increase as well. This can help you make decisions on how to allocate resources.

1 0
0 302
Article
Peter Steiwer · Dec 12, 2019 2m read
Creating Portlets in DeepSee

What is a portlet?

The simple answer is: a custom widget. A portlet can exist by itself on a DeepSee dashboard, it can be used along side standard DeepSee widgets, or along side other portlets. The rendering of the custom widget is completely user defined. This means you can embed a web page, create a form to perform any sort of action needed based on the data on your dashboard, use third party charting libraries, or simply display data from outside of a DeepSee cube.

How to get started

6 1
0 356

This post provides further detail on the suggestions from the DeepSee Troubleshooting Guide about what to do if a user is not able to view a listing in a DeepSee cube, but instead sees errors like this:

ERROR #5540: SQLCODE: -99 Message: User <username> is not privileged for the operation [zfindStatement+118^%SQL.DynamicStatement.1:<namespace>] (8)

1 1
0 677

BridgeWorks is pleased to announce a VDM, v9.1.0.1. This release includes the following updates:

Updates

  • Historical Linking is now based off connection profile name
  • Saved Formatting is now based off connection profile name
  • Tables and Fields column headers no longer hide based on connection type

Bug Fixes

1 0
1 164
Question
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 160

Hello InterSystems Community,

We're excited to announce that we've completed our first Open Exchange submission for InterSystems platforms.

BridgeWorks VDM is an ad hoc reporting and graphical SQL query builder application that was designed for any user who needs access to their SQL projections in InterSystems Caché, InterSystems IRIS, InterSystems IRIS for Health databases as well as access to InterSystems DeepSee and InterSystems IRIS BI Cubes with minimal SQL scripting experience.

VDM features:

2 0
1 307

Why log in to view pivot tables when you can have them delivered directly to your inbox? Are you in need of automated reporting for InterSystems IRIS Business Intelligence? Pivot Subscriptions is your solution: a tool for subscribing to scheduled email reports of pivot tables inside InterSystems IRIS Business Intelligence (previously known as DeepSee).

6 0
1 417

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?

Thank you, LG

0 1
0 127

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 1
0 131

Here is an ObjectScript snippet which lets to create database, namespace and a web application for InterSystems IRIS:

    set currentNS = $namespace

    zn "%SYS"

    write "Create DB ...",!
    set dbName="testDB"
    set dbProperties("Directory") = "/InterSystems/IRIS/mgr/testDB"
    set status=##Class(Config.Databases).Create(dbName,.dbProperties)
    write:'status $system.Status.DisplayError(status)
    write "DB """_dbName_""" was created!",!!


    write "Create namespace ...",!
    set nsName="testNS"
    //DB for globals
    set nsProperties("Globals") = dbName
    //DB for routines
    set nsProperties("Routines") = dbName
    set status=##Class(Config.Namespaces).Create(nsName,.nsProperties)
    write:'status $system.Status.DisplayError(status)
    write "Namespace """_nsName_""" was created!",!!


    write "Create web application ...",!
    set webName = "/csp/testApplication"
    set webProperties("NameSpace") = nsName
    set webProperties("Enabled") = $$$YES
    set webProperties("IsNameSpaceDefault") = $$$YES
    set webProperties("CSPZENEnabled") = $$$YES
    set webProperties("DeepSeeEnabled") = $$$YES
    set webProperties("AutheEnabled") = $$$AutheCache
    set status = ##class(Security.Applications).Create(webName, .webProperties)
    write:'status $system.Status.DisplayError(status)
    write "Web application """webName""" was created!",!

    zn currentNS

4 3
4 1,053

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

0 3
0 115

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

0 2
1 199
Question
Oliver Wilms · Aug 13, 2019
Dashboard - Line Graph

Hello,

I want to create a dashboard with a line graph that shows system availability over time. I used this code to create a Dashboard:

            Set tItem = ##class(%DeepSee.UserLibrary.Link).%New()
                Set tItem.fullName = "Availability"
                Set tPage = "Availability.UI.CSVImport.zen"
                Set tItem.href = $system.CSP.GetPortalApp($namespace,tPage)_tPage
                Set tItem.title = "Availability"
                Set tSC = tItem.%Save()
0 7
0 237

A SOLID Design in Cache Object

In this session, we will discussing SOLID Principle of Programming and will implement in a example.
I have used Cache Object Programming Language for examples.
We will go step by step to understand the requirement, then what common mistakes we use to do while designing, understanding each principles and then complete design with its implementation via Cache Objects.

3 7
2 396
Question
Daniel Buxton · Aug 1, 2019
DeepSee security issue

Hey Guys,

Have enabled DeepSee on my cache db via

Do EnableDeepSee^%SYS.cspServer(0)

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

0 3
0 187

​​​​​​We have Full time or Part Time Cache\ENSEMBLE\IRIS programmer positions available with our UK and US/North American teams.

For details on what we do and our products please see our web site intsoftsol.com

Interested persons should email reply to admin@intsoftsol.com

0 0
0 470

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.

1 1
0 226