DeepSee

Syndicate content 49 

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 then CANNOT edit the properties of the Widget, I click the ">" again and every Widget I create is "new (Closed)"...
  I do the exact same thing in namespace "ENSDEMO" and they all have their ">" to edit them and their properties.
  Hopefully there is just something remarkably simple I have missed in following the DeepSee tutorials / usage etc to allow other namespaces to create useful Dashboards... ??

Last answer 16 July 2018 Last comment 19 July 2018
0 3
98

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?
    2) failing full-automation; is there a way to get the manual Print Control (when clicked) to print and save to file in one step and not open the PDF to a new tab first to be manually saved?
    3) secondary failing full-auto option; is it feasible that one could write a method to open each pivot from the dashboard's definition and do an .exportPDF from each and put these each to a generated filename?

Last answer 16 July 2018 Last comment 18 July 2018
0 3
147

views

0

rating

Hi community,

I’m working in a project for a Chile Police and I need to know if it’s possible to build a hierarchy in Deepsee like Zone- Prefecture – Comisaria – Destacamentos (there are 4 levels of police units) , but these information are only in one table that has the code, the father ,description and UnitType. (it’s recursive) . Example:

Last answer 31 May 2018 Last comment 18 July 2018
0 3
147

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) 

Now I have data sets like

Last answer 16 July 2018
0 2
0

comments

127

views

0

rating

Hi everyone.

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.

Is that possible? I mean, calling /Info/FilterMembers/:datasource/:filterSpec with an array of filters on filterSpec parameter?

Thank you.

Last answer 6 July 2018 Last comment 6 July 2018
1 3
80

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.

Thus, filtering on CubeA dimension which depends on records from TableB is affected.

Currently, I'm workarounding that using ##class(%DeepSee.Utils).%SetDSTimeIndex() method in callbacks and triggers on TableB, forcing synchronization on CubeA.
Would DeepSee have some kind of automation in handling such situation?

Thank you

Last answer 29 June 2018 Last comment 29 June 2018
1 2
66

views

0

rating

I was approached recently by and end use who wanted to perform analysis of their databases and see how they could save some space by picking data good for deletion without harming the application. As part of investigation, they wanted to know sizes of globals within datasets. This can be achieved by various means but all of them provide data in text form only.

I thought I might be a good tool for database administrators in general - to see global sizes in a graphical way.

Last comment 14 June 2018
0 3
132

views

+ 2

rating

I have a server with rusw locale but in my cube the time dimension shows dates such as "JAN-2018". Is there a way to either localize that (preferably) or just output numbers  like "01-2018"?

Architect:

Analyzer:

Also in architect, in level settings there is a "Time Format" property, what's that? Tried setting it to 3 but it didn't help.

 

Last answer 9 June 2018 Last comment 9 June 2018
0 1
87

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 answer 3 April 2018 Last comment 19 March 2018
0 2
145

views

0

rating

Hi, DeepSee experts!

I need to call a listing programmatically other than the default. 

I can do that with %LISTING keyword. E.g. in Samples:

SAMPLES>d $SYSTEM.DeepSee.Shell()
DeepSee Command Line Shell
----------------------------------------------------
Enter q to quit, ? for help.
>>DRILLTHROUGH SELECT FROM [HOLEFOODS] %LISTING [Listing]

   #  ID   Date City Chan Prod Unit Reve Disc Comm
   1: 475  01/1 Madr Reta Life 1    0.92 20%
   2: 843  01/1 Manc Onli Frui 1    4.95 0%
   3: 808  01/1 Osak Onli Bund 4    79.8 0%

But how can I call custom listings in MDX? E.g. there are 3 custom listings available in SAMPLES HoleFoods Cube:

Last answer 31 March 2018 Last comment 2 April 2018
0 3
154

views

0

rating

Hi Evgency,

Effectively I have widjet with pivot which include dates in from different cubes/dimensions, but exists the relation between the two cubes.

I'm showing below the MDX query from one pivot that uses the date "Fecha Creacion" that comes from cube "EVENTOSPOLICIALES" 

SELECT %LABEL([Measures].[%COUNT],"Cantidad de Encargos","") ON 0,
       NON EMPTY {[TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Arma],
                [TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Especies],
                [TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Personas],
                [TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Vehículos]} ON 1
FROM [EVENTOSPOLICIALES]

Here, I'm showing the other MDX query that uses the date "Fecha Parte" like a filter that comes from the Cube "PARTEPOLICIAL", bit the others fields come from "EVENTOSPOLICIALES

Last answer 19 March 2018 Last comment 19 March 2018
0 2
118

views

0

rating

Hi Community, I have a dashboard with 4 widjets, two of them use the same filter date and the others two another filter date. I want to know if it's possible that when I selected a date in one widjet affected also the other widjet with the same date. I saw that the filter can affect all of the widjets or only one, the owner of the filter. The other thing that the client ask me, if exists the possibility to create a generic date and when the user choose the range of date, will affect all of the widjets, independent that are different dates. If it's possibly, the only way , i think, it's trough KPI Thanks for your help
Last answer 9 March 2018 Last comment 15 March 2018
0 4
162

views

0

rating

Hi, Community!

I'm using Git with DeepSee and when I need to do a commit to the git repo I'm exporting ALL the pivots and dashboards from the namespace. But I can forget to do that) And it can take time for a large system.

What is the way to manage automatical export of DeepSee artefacts which we are editing in UI (Cubes, Pivots, Dashboards, Pivot Variables, Term lists, Shared Measures) into files every time when I push Save button?

Last answer 7 March 2018 Last comment 7 March 2018
0 2
128

views

0

rating

Hi, Community! 

This is the 3rd part of DeepSee Web story - Angular base UI for DeepSee Dashboards, see the beginning here.

By design, DSW provides an implementation for every widget in DeepSee library. But there are some extra features in DSW which make solutions built with DSW dashboards more functional.  This article describes it.

1 1
0

comments

246

views

+ 2

rating

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.

Last answer 11 February 2018
0 2
0

comments

84

views

0

rating

In part 1part 2, and part 3 parts of this series we set up three user types. In part 4 we saw how to secure model elements and DeepSee items. In this last part of the tutorial we conclude with some remarks on DeepSee security and troubleshooting tips. In particular, we see how pivot tables in User Portal can be "hidden".

0 1
0

comments

128

views

+ 1

rating

Apart from the database server itself, the standard bundle of the Caché DBMS includes DeepSee, a real-time business intelligence tool. DeepSee is the quickest and the simplest way of adding OLAP functionality to your Caché application.

Another standard component is an Audit subsystem with a web interface, which has the options for expanding with your own event types and an API for using in an application code.

Below is a small example of the joint use of these subsystems that answers the following questions: who did what and when in an information system?

Last comment 4 January 2018
1 4
306

views

+ 1

rating

Hi, Community! 

Please welcome a new session recording from Global Summit 2017:

Data Visualization: The Choice is Yours

 

Last comment 21 December 2017
0 2
128

views

+ 2

rating

Hi, Community! 

 Check a new session recording from Global Summit 2017:

Can It Be Measured?

 

0 1
0

comments

81

views

0

rating

Hi, Community!

In the second part about DeepSee Web, I’ll describe what customization options you have with DSW.  

There are two types of customizations: widget customization and dashboard panel customization.

Example of dashboard customization on Developer Community analytics.

Last comment 4 December 2017
0 3
282

views

+ 2

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:

Is there any way to export those calculated dimensions so that I can used them else where? 

 

Last answer 1 November 2017 Last comment 2 November 2017
0 2
190

views

0

rating

Hi,

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

Say I built a cube built to analyse data  from this persistent class.  With a simple date dimension, and SensoRName filter, I can show the default COUNT of readings for a given month/year:

Jan-2015             94
Feb-2015             54
Mar-2015             78

Last answer 22 October 2017 Last comment 25 October 2017
0 4
191

views

0

rating