How do we return a member from a set?  For example if I want a calculated measure to return the NAME of the date with the max transactions, to get the set ordered I might do something like:

ORDER([TransactionDate].[YearMonthDate].[Date].MEMBERS, [Measures].[TransactionCount], DESC)

But how do I access the first member in the set as a member so that I can get to the properties such as the member NAME (what I want to return in this case)?

In some MDX implementations like Microsoft there are kind of backdoor functions for this like:

00
0 4 122

DeepSee measures define the aggregate values seen in individual cells when analyzing data. Measures are defined for a cube using Architect and can be based on properties of the source class as well as COS expressions.

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Cubes
00
0 0 0
Article
Community Manager · Oct 2, 2015
DeepSee MDX - Overview

MDX is the query language for cubes. DeepSee analyzer generates MDX queries that can be viewed and modified if needed. A DeepSee result set can be returned to your application via the %DeepSee API.

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

Viewing the results of a Drillthrough MDX query is different than viewing a DeepSee result set. Drillthrough returns a listing.

API InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)MDX
00
0 0 0
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

00
0 5 133

Hello Community, 
I hope you're going well.

I am programming a daily reporting that will send by e-mail when people will add a dashboard as favorite by clicking on the star :

 

I asked Intersystems WRC on how to automatically generate a report with some line coding, but I heard there is no way to do this without a headless Browser.

00
0 4 167

In addition to charts on a dashboard we have a request to have a crosstab which would be populated by some entries queried out of an error log.  It's basically a detail query with mostly text data.  I have tried making a pivot widget for this using both a cube and kpi source, and while succeeding with the KPI, it leaves a lot to be desired. 

00
0 3 96

Listings in DeepSee provide record level detail for the aggregate value in a cell in a pivot. Listings can be based on the source class or SQL. Geo Listings use Lattitude and Longitude to integrate to Google Maps but can only be viewed in a Dashboard

InterSystems IRIS Analytics (DeepSee) InterSystems IRIS Analytics (DeepSee)Cubes InterSystems IRIS Analytics (DeepSee)Listings
00
0 0 0

MDX queries can have up to 7 axes. An aggregate value in a cell is the aggregate of the intersection of the axes. Specifing dimensions and measures in an MDX query defines the axes and aggregates.

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

The DeepSee API allows access to DeepSee queries in your application. Define an MDX query, prepare and execute it in order to provide your application with a DeepSee result set.

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

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:

00
0 3 388

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.

00
0 3 291

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.

 

00
0 5 275