Hello,

is there any API available that would return an MDX query string for a given saved pivot name? I could not find anything except for pivots with manual MDX. But that's not my case, I need to get MDX for any pivot.

TIA!

Dan

Hello there Intersystems Developer Community,

This year while at the Global Summit, I came to learn of a component that Stephen Morrison of Intersystems had written that was capable of infusing SVG content into a PDF document.  Apparently Stephen was approached about this and was amenable to sharing the code with us as we have recently encountered a similar need.  I'm hoping this post will lead to the sharing of this utility code, so that we can determine if it will indeed suit our need.

It is my impression that this code is maybe that being used to perform the print operation on a given widget

I am wish to use the mapping widget provided with DeepSee with my own Google license.  What is the best way to make this happen?

(I apologize if this is a duplicate.  My first attempt did not seem to get posted) 

Hi all,

I have a dashboard which shows the growth of the months compared with the month from the last year.

The way I found to develop that, it was with a kpi. So, I overrode the %OnLoadKPI method with two mdx:

SELECT NON EMPTY [DataD].[H1].[MothYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2016]

SELECT NON EMPTY [DataD].[H1].[MonthYear].Members ON ROWS, [Measures].[CountVisits] ON COLUMNS FROM SubjectAtendimento %FILTER [DataD].[H1].[Year].&[2015]

And then, I set the %..data variable with the percent growth of the months for each

You may experience errors executing Java programs that rely on the JAVA_HOME environment.

For example when Create PDF from this pivot in DeepSee or in this case, outputting a Zen Report as PDF.

You can verify the PDF generation configuration by clicking on the Verify Now button on the Management Portal System > Configuration > Zen Report Settings page:

Outputting a Zen Report as PDF causes an error, for example ZENApp.MyReport.cls in the SAMPLES namespace:

Using the URI Query Parameter $LOG=1:

Solution

Remove the quotes around the path defined in the JAVA_HOME environment variable and

Learn the fundamentals of how and when to use the DeepSee Analyzer. 

Presenter: Joe Gallant
Task: Create a good analytical data model
Approach: Discuss what makes a good analytical data model. Provide examples of using DeepSee’s APIs for building custom dimensions, measures, and KPIs
 

Data models are the foundation of effective analytics. This session focuses on the factors that make good analytics data models. 

Content related to this session, including slides, video and additional learning content can be found here.

Presenter: Barry Cooper
Task: Enable users to perform analytics within an application and take actions based on those analytics
Approach: Provide examples of embedding DeepSee within applications
 

Analytics is more than just using data to provide insight. Analytics is about taking action on that insight. See examples of how you can embed DeepSee in your applications, allowing you to take action.

Content related to this session, including slides, video and additional learning content can be found here.

Presenter: André Cerri
Task: Use third-party visualization tools to present your DeepSee data
Approach: Use DeepSee REST services to access DeepSee data from third-party tools
 

Come see examples of how you can use popular 3rd party data visualization tools to access your DeepSee data.

Content related to this session, including slides, video and additional learning content can be found here.

Learn about tools available in DeepSee; including dashboards, the Analyzer and the Artchitect.

The DeepSee Shell Best Practices Series - Example of using the MDX subquery flag in the DeepSee Shell

We have different flags for DeepSee advisors to look into the execution details and the methods DeepSee is using to do calculations.

flag [flagname] [on|off] – Turn a diagnostic on or off.

flag cmbr on|off – Show current member processing.

flag compound on|off – Show rewrite of compound queries.

flag crossjoin on|off – Show crossjoin processing.

flag relations on|off – Show relationship processing.

flag rewrite on|off – Show rewrite of query.

flag subquery on|off – Show subquery processing.

CLEAR –

The DeepSee Shell Best Practices Series - Get your MDX query plan, MDX Query Trace and more from the DeepSee Shell

To process a query, DeepSee performs the following steps:

1. Preparation, which occurs in process (that is, this step is not launched as a background process). In this phase:

• DeepSee parses the query and converts it to an object representation, the parse tree. In the parse tree, each axis of the query is represented separately. One axis represents the overall filtering of the query.
• DeepSee converts the parse tree to a normalized version of the query text.

The DeepSee Shell best Practices Series - Execute an MDX query in the DeepSee Shell with/without  results cache

This cache is different from cache reset. Cache reset clears everything in the namespace but “cache off” only clears the cache in ^DeepSee.Cache.Results and ^DeepSee.Cache.Axis global node for the corresponding cube. The difference is quite smaller in the case as below, but in some cases it can be a big difference.

^DeepSee.Cache.Results, which contains values for each query previously executed for a given cube.

The DeepSee Shell Best Practices Series - Reset your DeepSee cache in the DeepSee Shell

This method is provided as a convenience for developers for use on development or test systems. You should not use this method on production systems as it will have immediate effect on the performance of end user operations.

• Stops all DeepSee background agents
• Clears any pending tasks
• Clears the result cache for the current namespace.
• If you use “reset 1”, then the cell cache for the current namespace is also cleared.  

>>reset 0

** Stops all DeepSee background agents, clears any pending tasks, and clears the

The DeepSee Shell Best Practices Series - Get your MDX query performance stats from the DeepSee Shell 

DeepSee Shell can show MDX query stats and result set stats.

3 0 to 29->20 to 29 80 56 68.

What is the best way to deploy DeepSee Termlists?

A customer needs to add lines in the Excel sheet before the MDX resultset content.

Is there a more elegant/convenient way than modifying %DeepSee.UI.MDXExcel methods ?

Thanks in advance.

Sylvain

Hi,

Given a log file with these records representing, hypotethically, the ‘movements’ or changes in residential city, for citizens, like this: 

 ID           CitizenRef           RelocationDate                 City                        Surname
...
 48          1000                       2015-04-01                          Boston                  Smith
 49          1000                       2015-07-01                          Seattle                  Smith
 50          1000                       2015-10-01                          Boston                  Smith
 51          1000

Hi,

Has anyone implemented the 'DeepSee Visual Reporting' tool in realtion to TrakCare?  If so, has anyone used it to customise Zen reports for TrakCare questionnaire preview/printing?

Thanks, Dan

Hello,

is there any mechanism available in DeepSee to keep values of AGE dimension up-to-date without rebuidling cube? Can age be determined at the mdx query execution time?

Thank you!

Dan Kutac

Hi!
I am working on a project and I am facing a weird problem. I have created an MDX using Analyzer. This MDX executes very fast. I am trying to automate its execution with %DeepSee.ResultSet and the query never returns:

Set tSC = oMDX.%PrepareMDX(tMDX)
Quit:$System.Status.IsError(tSC)

Set tSC = oMDX.%Execute()
Quit:$System.Status.IsError(tSC)

What could be causing %Execute() to take so long to run while Analyzer is responding fast?

I can see that the process that is executing the %Execute() method is on HANGW state.I am assuming that it is waiting for another process.

Welcome to the DeepSee Group.

The Developer Communty has a lot of DeepSee content including all the DeepSee documentation and over 50 videos.

Please use the Developer Community to asks questions, share your experience, and learn more about DeepSee.

I look forward to your participaton in the DeepSee Group of the InterSystems Developer Community.

Joe Gallant

Senior Product Manager

Hello DeepSee'ers -

How hard is it to brand a dashboard to a login?

The situation is, I have a Partner that is looking to create common Dashboards in a SaaS model where the Partner's Clients would want to have their individual views of this common dashbaord be branded (logos, color, styles, etc.) to match the Client's branding. This my Partner's Client's End Users will see this common dashboard as the dashboard from the "Client" and not the "Partner" (and certainly not ISC branding)

ie.  ISC -> Partner -> Client -> End User