DeepSee

Syndicate content 49 

Those of you, who work with DeepSee, might have spotted, that when working with a date hierarchy, there are several functions, allowing you to select a time function for a given level. E.g. for extracting a year from a date/time property when building date hierarchy, you simply use Year function. similarly for month number, quarter and so on. Sometimes, you may wish to see the time - namely hour numbers. For this there is a HourNumber function available with DeepSee. Unfortunately, this function converts time into 12 hours format suffixed with AM/PM to indicate day part. This is not, however, much of use in certain parts of the world. You'd rather see hour numbers in 24 hour format.

Luckilly enough, the solution is easy, despite it requires some coding.

Let me guide you through the necessary steps in the following paragraphs

Last comment 22 November 2016
0 4
183

views

+ 2

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

comments

128

views

0

rating

Importance and Collection of Exact Version Information ($zv / $zversion)
 
The explanation of:
- why collecting $zv is important (The WHY),
- what the components of $zv mean (The WHAT),
- and how to collect $zv (The HOW). 
(The Ultimate $zv Guide to the ISC Galaxy in large, friendly letters)
Last comment 15 November 2016
0 7
706

views

+ 13

rating

The DeepSee TroubleShooting Guide helps you track down and fix problems occurring in your DeepSee project. A common problem is finding less records than expected in a DeepSee Cube or a related Subject Area. The DeepSee TroubleShooting Guide suggests starting your investigation by checking the following:

Check cube for build restrictions

Check if maxFacts is used

Check if Build Errors are occurring

0 2
0

comments

192

views

+ 2

rating

I tried using the DeepSee Troubleshooting guide but the suggestions weren't working.  Let's say that the source data we are using to build the cube on has a value out of range. This would cause the cube build/update to fail. How do I see the error log that explains which field has the value out of range? Please be detailed on exactly what command I should enter and where I should enter it in.

I assume that I go into a terminal session and to the correct namespace that we are building/updating the cube on, but the DeepSee Troubleshooting guide doesn't give that detail. I also tried the commands described in the Troubleshooting guide but I got syntax errors for almost every one. 

Last answer 7 November 2016 Last comment 10 November 2016
0 4
252

views

0

rating

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)

0 2
0

comments

249

views

+ 1

rating

Whether you are accessing DeepSee for the first time ever or you are configuring DeepSee on a new instance, there are two common issues that are encountered after clicking on the “DeepSee” option in the System Management Portal.

Issue #1: Architect/Analyzer is grayed out!

Issue #2: DeepSee must be enabled before use.

Issue #1: Architect/Analyzer is grayed out!

There are two common causes for this problem.

Cause 1 - License

Cause 2 - Security

The first common cause is that the license does not have these DeepSee options enabled. To confirm if these options are enabled, you can run the following code from terminal

Last comment 7 November 2016
0 5
747

views

+ 5

rating

Hi-

I was wondering if there was a DeepSee overview document available for a non-technical user.  Something short and concise describing what DeepSee is and its key features.

I've looked at the documentation and although there are parts of what I am looking for there it is much too technical for my needs.

Thanks

Last answer 27 October 2016
0 1
0

comments

133

views

0

rating

Hi - If you want to embed Ensemble's Workflow Inbox, (that offers workflow task items to workflow users) inside of your application - you can access the URL directly without necessarily giving users access to the Management Portal - but more importantly, you can strip away the Titlebar, Worklists and Borders that make up the page by default.

You do this by using the same URL parameters you would use, if embedding a regular DeepSee dashboard into your application.

For example, adding &EMBED=1 at the end of the URL as depicted below:

http://localhost:8973/csp/ensdemo/_DeepSee.UserPortal.Workflow.zen&EMBED=1 

 

removes all titles, borders and worklists from the resulting page.

For the full list of available URL parameters you could use, see this link from the documentation

0 2
0

comments

181

views

0

rating

I need to create a KPI similar to the  DeepSee.Model.KPIs.DemoTrendLines kpi in Samples.  This kpi supports a scorecard widget with a trend line.  It shows patient counts by city with a trend line of the count of patients over a decade.  What I want is to show the trend line based on the average allergy score ([Measures].[Avg Test Score]).  A pivot table query that shows the data I would want to base the trend line on is:

SELECT NON EMPTY [BirthD].[H1].[Decade].Members ON 0,
NON EMPTY [HomeD].[H1].[City].Members ON 1 
FROM [Patients] %FILTER [Measures].[Avg Test Score]

Has anyone done this?

Last comment 14 October 2016
0 4
0

answers

165

views

0

rating

Hi!

Sometimes you see that call to DeepSee cube building method:

w ##class(%DeepSee.Utils).%BuildCube("CubeName")

does nothing.

Here are my 2 cents on possible reasons.

1. Run DeepSee Reset method in certain Namespace:

NAMESPACE> w ##class(%DeepSee.Utils).%Reset()

and try again.

2. Make sure, that all the indices in your base class for the cube are rebuilt, rebuild them and run it again:

w ##class(%DeepSee.Utils).%BuildCube("CubeName")

Hope this will save some time for you, and will be helpful as was to me.

 

 

Last comment 4 October 2016
0 2
192

views

+ 1

rating

I know per documentation (pasted below) to set the DSTIME parameters for the base class of a cube.  If that base class has a property that is another class, do I have to add the DSTIME parameters to that secondary class? 

Documentation says the following in a section titled "Enabling Cube Synchronization:"

Before you can synchronize a cube, you must enable the cube synchronization feature for that cube. To do so:

1.   Make sure that cube synchronization is possible in your scenario. See “When Cube Synchronization Is Possible,” earlier in this chapter.

2.   Add the DSTIME parameter to the base class used by that cube...

Last answer 15 September 2016 Last comment 23 September 2016
0 2
240

views

0

rating

Hi, Community!

You know, that when we build hierarchies in DeepSee dimension all the members of lower level should be the part of one member of the higher level.

If not you'll get some empty results in MDX queries with this hierarchy.

With Time dimensions the obvious valid hierarchy is Year->Month->Day, cause every Month consists of one Year and every day consists of one month. 

But be aware of using Year->Month->Week->Day hierarchy. In this case, there are some weeks in the year (most of them), which consist of two months. As a result, you can get unpredicatable empty results in your MDX queries with such a dimension.

Last comment 28 July 2016
0 2
233

views

+ 2

rating

I installed MDX2JSON and DeepSeeWeb 1.4.46b on this version of Caché (actually HealthShare) 

Cache for Windows (x86-64) 2016.1 (Build 656U) Fri Mar 11 2016 17:42:42 EST

I works well for the most part but my buttons contain characters that should not be there. Here is a screen shot. Does anyone recognize what the issue might be?

 

Last answer 18 July 2016 Last comment 19 July 2016
0 1
167

views

+ 1

rating

I  have a DeepSee KPI defined based on %DeepSee.KPI following the documentation http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=....  I've then enabled the KPI on a dashboard by adding a Widget where the data source is the KPI.  Currently the ability to show a Detail Listing is implemented by the call back %OnGetListingSQL.  This method documents the parameter

pListingName is the name of the listing to display. This is reserved for future use.

 

According to this and from what I can tell there is no way to provide support for a secondary listing. 

Last answer 14 July 2016 Last comment 14 July 2016
0 1
144

views

+ 1

rating

Today my customer ask me a question about how to write the MDX with a summary row however this row with different aggregate functions for each column.

We know in DeepSee analyzer has pivot table option "Summary",  user can select sum, avg ... aggregate functions to get the summary row/column. However we can not specify different aggregate function for each measure column.

Here show the example to use All level and IIF function achieve that. see the example (Holefood cube in Sample namespace) below

 

WITH MEMBER measures.[with avg summary info] AS

                              'IIF(Product.CurrentMember.Properties("LEVEL_NUMBER") = 1,

                                 AVG(Product.[Product Category].Members, measures.[amount sold]),

                                 SUM(Product.[Product Category].Members, measures.[amount sold]))'

               MEMBER measures.[total count] AS 'SUM(Product.[Product Category].Members)

Last comment 12 July 2016
0 2
629

views

+ 2

rating

I am trying to calculate a dimension percentage for WFRole on a child cube named MbMRouteHistoryInitiatorObj joined to a parent cube named MbmQaSObj by using a calculated member dimension within MbmQaSObj. 

If I use the calculated member dimension value expression of [WFRole].[H1].[WFRole].CurrentMember/ [WFRole].[All WFRole].%ALL in the child cube MbMRouteHistoryInitiatorObj, the percentages work correctly.

I am not able to calculate the same percentage using the value expression [MbmRouteHistoryInitiatorObj].[WFRole].[H1].[WFRole].CurrentMember/ [MbmRouteHistoryInitiatorObj].[WFRole].[All WFRole].%ALLin the parent cube MbmQaSObj.  The %ALL gives an error.  Any ideas on how to make this work?

 

Last comment 22 June 2016
0 2
0

answers

261

views

0

rating