Dashboards

Syndicate content 14 

I am building a cube based on a source class, which I  will call,  Family.Dad 

In the class definition for Family.Dad, there is a relationship, offspring  As Child  [ Cardinality = children, Inverse =  father]

In the class definition for Child, there is a relationship called father As Dad  [ Cardinality = parent, Inverse =  offspring]

In the actual data, a dad can have many children, but a child can only have 1 dad.

Using DeepSee, I am trying to analyze to answer questions such as how many dads have children called Joseph ( Ex dad.offspring.GetAt(x).Name) etc .

Last answer 4 days ago Last comment 3 days ago
0   0 1
27

views

0

rating

  Hi community,

   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. 

Thanks in advance.

  Regards,

 Jaqueline Krieger

Last answer 11 February 2019 Last comment 6 March 2019
0   0 1
65

views

0

rating

Hey Developer Community,

I wanted to reach out and ask the group who is still using the Polymetric Dashboard? You can read about it in this older Community article.

It was created as a sample that is designed to be customized by you, so it is a community supported tool vs. an official InterSystems supported tool.  I've noticed that it hasn't been updated in a while and some of the dependencies have some potential security vulnerabilities.  If you are using the tool internally, it isn't an issue, but was wondering if anybody who is using it has already updated their code with newer dependencies, etc?

So, is there interest from the community in updating it?  Or testing it with IRIS?

- Doug

0   0 2
0

answers

0

comments

95

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 answer 3 September 2018 Last comment 16 January 2019
+ 1   0 5
0

comments

197

views

+ 1

rating

Can someone tell me if /deepsee-sysmon-dashboards is developed for a specific version of Ensemble? Looks like it could be useful to my group but we aren't upgrading till later this year and we are on 2015.2.2.

Thanks

Scott

Last answer 7 January 2019
0   2 1
0

comments

72

views

0

rating

In looking at the Production monitor within Ensemble, I was wondering if there is a way we could customize it for our use. I notice it is basically a dashboard.

For example I would only like to truly display those Services, Processes, and Operations that are truly in dire need of attention. The Monitor out of the box just seems too busy, and I would like to simplify it.

I was trying to find a sample how a Monitor Dashboard would be setup, but I am not seeing anything in ENSDEMO, or SAMPLES. Has anyone created a Custom Dashboard/Monitor for their purposes? Would you be willing to share an example with me?

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

Last comment 3 December 2018
0   2 4
0

answers

185

views

0

rating

Hi -

 

I need an example of what I need to "map" to have a common dashboard defined so it will visible/usable in multiple namespaces.

 

I have created a dashboard in "SAMPLES" (namespace and database) and I would like to have this dashboard be accessable/useable from a 2nd namespace, but I'm not having any success in doing mappings (global/package/routine/data) to be able to get DeepSee to be able to see/display the dashboard.

What is the minimum that I need to map?

Last answer 20 August 2018 Last comment 25 November 2015
0   0 4
168

views

0

rating

Hi -

I'm trying to get my Combo Chart to dynamically scale the Y axis, but it's not doing what I would like. The 1st Y series, if the MAX value is set to null, scales the chart and the series fine, but then the subsequent Y axis are not to that same scale. Each "null" Max'ed series is setting it's own scale based only on it's own ranges and not in sync with anything else.

Is there a way to force all of the "null" scaled columns to be in the SAME scale as each other AND be dynamic.

If I set a "Maximum" value so they are all the drawing at the same scale, they stay in sync, but if I do this and then run-time/display-time apply a filter that goes from say "200" to "5", then the scale stays at the hard coded scale and the "5" is so flat that it's barely detectable. 

0   0 1
0

answers

0

comments

59

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);
  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   0 3
102

views

0

rating

Hi Everyone!

Enjoy a new session recording from Global Summit 2017 on DC YouTube Channel:

Tell Your Story With Dashboards

 

0   0 1
0

comments

108

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

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   0 4
165

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.

And every time(!) when you update a listing you need to rearrange that access level in a Role (either grant new or revoke not used anymore) to the tables.

How do you manage that? Manually? Or you have a magic shortcut script or recipes in hands? Would you please share? 

Last answer 28 September 2017 Last comment 28 September 2017
+ 1   0 1
155

views

+ 1

rating

I have a main page in .NET where I call a Dashboard created in DeepSee like this:

<iframe src="../..zen?DASHBOARD=NameofDashboardKpi1.dashboard&EMBED=1&CacheUserName=&CachePassword=" 

to display the Dashboard in the .NEt page.

 

My problem is that connection to every Dashboard takes a while, so performance is low.

Any suggestion?

Last answer 2 September 2017 Last comment 25 September 2017
0   0 2
172

views

0

rating

Hello, I've completed this tutorial: https://community.intersystems.com/post/deepsee-period-date-vs-same-peri...
I've used the "year" level instead of a pivot variable.
I want to calculate something like the following variation: 100 * ([DateOfSale].[PTD] - [DateOfSale].[LYPTD]) / [DateOfSale].[LYPTD]
I create a new calculated member, under the same dimmension with the above expression.
I put the new calculated member under the Count measure and it tells me that "Two measures cannot be crossjoined"
What am I doing wrong?
Can you redirect me to some explanations and maybe a solution?
Thanks!

Last comment 31 August 2017
0   0 3
0

answers

173

views

0

rating

Hi!

Sometimes I need to filter the widget on a dashboard from a different cube. And I face the following problem:

Widget A refers to a query from Cube A and I want to filter Widget B from Widget B.

Widget's B pivot refers to Cube B, and which has different dimensions for the same data.

E.g. cube A has the dimension Author and the Cube B has the dimension Member for the same data. So  there is no way to filter such a widget B from the widget A.

Actually, once we filter a given widget B with another widget A, we add the Filter Expression to the MDX query which looks like member's expression from Cube A, like:

[Outlet].[H1].[Region].&[Asia]

Is there any way to alter the filter expression for Widget B, just changing the value of the last part (Asia in this case) of the filter expression?

Last answer 9 April 2017
0   0 0
0

comments

133

views

0

rating

Hi!

There are DeepSee dashboards,  which make sense only when filtered.

Usually, they are used as Drill Target or New_window control with SETTINGS=Widget;FILTER=filtervalue.

Is there a way to hide such dashboard from the Catalog or/and request the filter value once it is opened by User?

 

Last answer 15 March 2017 Last comment 12 February 2017
0   0 3
138

views

0

rating

Hi!

There is a 'New_window' control in DeepSee Widget which opens the page in a new tab in a browser with a given URL.

With the help of this control you can open another dashboard and supply some parameters in SETTINGS clause.

Consider  I can setup in Dash1 the URL like: 

_DeepSee.UserPortal.DashboardViewer.zen?DASHBOARD=Postings.dashboard&SETTINGS=TARGET:W1;FILTER: [Author].[H1].[Author].%26[$$$VALUELIST]

to filter the widget W1 in Postings dashboard with filter [Author].[H1].[Author].%26[$$$VALUELIST], where $$$VALUELIST is some value from the listing in a widget in Dash1.

How can I spread the filter for two or more widgets?

Last answer 13 March 2017 Last comment 14 March 2017
0   0 1
104

views

0

rating

How are we doing THIS year versus the same period LAST year? 
This is a common need in Business Intelligence. In fact, many design specifications for reports make use of a comparison between a selected period (year, quarter, etc) up to a certain date (for example November 15th, 2016) and a summary of the same information for the previous year (i.e. up to November 15th, 2015). 
This post shows how to implement this in DeepSee.

Last comment 9 January 2017
+ 5   0 0
662

views

+ 5

rating

When creating a filter located on a dashboard that targets all, is there a way to narrow that filter down?

For example, in our data we have some dates that are well out of range due to data quality issues, but they still appear in the drop downs. Is there a way to say, only make available the below dates in the filter?

Another example, If we want to only look at Emergency data, it still provides all the wards for inpatient activity and activity in other hospitals, meaning, to get to just the Emergency wards you have to scroll through everything?

Hope that makes sense.

Also, to follow this up, is there a way to order the drop downs? as for dates the oldest dates generally appear to be at the top where as we would prefer it to start with the most recent dates.

Last answer 23 November 2016 Last comment 23 November 2016
0   0 4
172

views

0

rating

In DeepSee we have a field that is numeric but is used as a dimension. In DeepSee it sorts this field in the following order. 10, 11, 15, 2, 3, 5, 6, 8, 990. Is there a way to have DeepSee sort it numerically instead of treating it like a character field? We would want to see it show up in the dimension as 2,3,5,6,7,10,11,15,990.

 

Last answer 17 November 2016
0   0 1
0

comments

131

views

0

rating

I've asked a lot of questions leading up to this, so I wanted to share some of my progress.

The blue line represents the number of messages processed.  The background color represents the average response time.  You can see ticks for each hour (and bigger ticks for each day).   Hovering over any point in the graph will show you the numbers for that period in time.

This is super useful for "at a glance" performance monitoring as well as establishing patterns in our utilization.

Here is the query used

Last comment 4 November 2016
+ 5   0 0
263

views

+ 5

rating