Relative functions in MDX allow you to move from a member of a level to its relatives. Relatives include, parent, child, cousing, ancestor

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
0 0
0 0
Question
Derrek Kegler · Mar 29, 2017
Dollar Ranges

How to setup dollar ranges to get the number of patient accounts. So, I want to capture the number of patient accounts based on the original balance of:
0 to 499
500 to 999
1000 to 2499
5000 to 9999
10000 to 24999
25000 to 49999
50000 to 74000
75000 to 99999

=100000

0 2
0 382

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 103

I need someone to help me set up Community version of IRIS on an Amazon virtual server so that I can develop some versions of a highly secure database for review by investors. Any help would be appreciated. Some initial investment funds are available but so far this is a small project with big dreams.

0 0
0 104

Joe Gallant, Product Manager for DeepSee, describes the new DeepSee dashboards available in 2013.1. Prerequisite: experience with DeepSee's earlier dashboards and dashboard editing tools.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Dashboards
0 0
0 0

Applying filters in the DeepSee Analyzer restricts the rows that are used for the pivot table. Simple and advanced filtering is supported using dimension levels as well as searchable measures.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Analyzer
0 0
0 0

DeepSee MDX navigation functions allow you to move to another member of a level based on the current member.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
0 0
0 0

I am trying to create a query that returns the best and worst performing products for a given customer, based on this year's net sales versus last year's net sales, weighted by the total net sales for all of the products sold to this customer in the last two years.

I have created Last Year Net Sales (up to the last month end): AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])

0 3
0 260

Hi,

suppose a part of my mdx query is [DIMENSION].[H1].[LEVEL1].CURRENTMEMBER.Property("PROP1").

If the source property of PROP1 is also used as a dimension level somehwere in the cube, this query will return a key  to the entry in the coresponding star table.

Does anybody know how I can follow that key and display the real value value?

 

 

0 1
0 837
Question
Chip Gore · Jul 24, 2018
Combo Chart scaling question...

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.

0 1
0 158

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 119

As the title mentions, I'm trying to determine how best to handle an issue with nested data.  Essentially I have a setting like the following:

Object A has a transient property with an array of Object B. I want to create a level with a list of Object B.  I also want this level to contain properties belonging to each object B. 

So I have a layout of something like

0 1
0 152

Unstructured data analysis is critical to decision-making processes. Benjamin De Boe, Product Specialist for iKnow, talks about the how to analyze unstructured data with DeepSee and iKnow.

Caché InterSystems IRIS Analytics (DeepSee) Unstructured Data iKnow
0 0
0 0

DeepSee dashboards are the way end users interact with analytics. While pivot tables are the most common, analytics can also be in the form of scorecards and meters. Dashboards can be accessed directly from your application via a url.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Dashboards
0 0
0 0

DeepSee MDX limiting functions restrict the number of elements in the pivot. Functions include, IIF, FILTER, DISTINCT, TOPCOUNT and more.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
0 0
0 0