Hi, DeepSee experts!
I need to call a listing programmatically other than the default.
Last answer 31 March 2018 Last comment 2 April 2018
MDX
About this tag
Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system. Much like SQL, it is a query language for OLAP cubes
Subscribe to MDX content with RSS 
or email
or email Hi, Community!
I’m sure you are using Developer Community analytics built with InterSystems Analytics technology DeepSee:
You can find DC analytics n InterSystems->Analytics menu.
DC Analytics shows interactive dashboards on key figures of DC entities: Posts, Comments, and Members.
Since the last week, this analytics project is available for everyone with source code and data on DC Github!
Hi, Community!
This is the 3rd part of DeepSee Web story - Angular base UI for DeepSee Dashboards, see the beginning here.
By design, DSW provides an implementation for every widget in DeepSee library. But there are some extra features in DSW which make solutions built with DSW dashboards more functional. This article describes it.
Hi, folks!
Suppose you called an MDX which takes a really long period of time.
Is there any way to cancel its execution programmatically?
Last answer 22 October 2017 Last comment 22 October 2017
Hi, Community!
How can I manage to show in MDX query months where every month shows the value of the last month?
Say, in HoleFoods the query:
Last answer 5 April 2017 Last comment 8 October 2017
I have a query text that I need to execute and return results as xml.
Last answer 14 July 2017 Last comment 14 July 2017
Based on user request in zenpage, i am running the method ConvertMDXtoJSON in background and loading the status in progressbar.
Last answer 7 April 2017 Last comment 10 April 2017
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.
Last answer 9 April 2017
Hi,
suppose a part of my mdx query is [DIMENSION].[H1].[LEVEL1].CURRENTMEMBER.Property("PROP1").
Last answer 3 April 2017
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
Last answer 30 March 2017
Hi!
How can I show a number of rows in a given DeepSee pivot?
Last answer 14 February 2017 Last comment 14 February 2017
Hi, All!
What is the calculated measure expression for the percentage of a member?
Last answer 25 January 2017 Last comment 25 January 2017
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
Hi-
I am trying to figure out how to compare two dimension values in a MDX query such that records where two dimension values are the same will be filtered out.
Last answer 7 December 2016 Last comment 7 December 2016
Hello. I'm just getting started in DeepSee, and am also a newbie in MDX.
Last answer 6 December 2016 Last comment 9 November 2016
Dear All,
From my web page, i am passing filter values to mdx query.
when mdx executes, i am getting Error #5001: Invalid member expression: empty name(2).
Last answer 30 November 2016 Last comment 1 December 2016
Introduction
A calculated measure is a powerful feature in DeepSee and can help to enrich your analyzes. In the case of complex or long running computations plugins can be useful. This article shows with a simple example how you can build and use a plugin in DeepSee.
I currently have an MDX query/calculated measure as per the below:
Last answer 21 November 2016 Last comment 22 November 2016
Hi All,
I need some help to create mdx for the following scenario.
My source table is like this format
Last answer 4 November 2016 Last comment 7 November 2016
I need to create a KPI similar to the
Last comment 14 October 2016
I'm trying to calculate the percentage of the top level with the SUM function.
But I don't understand the PARENT behavior.
It does not work in any way!
Last answer 12 July 2016 Last comment 13 July 2016
Is there anything in deepsee where i can increase the cell width?
|
Last answer 12 July 2016 Last comment 12 July 2016
Hi,
Using cube CubeA and cube CubeB that contains calculated measure TotalClients.
I would like to use TotalClient calculated measure from a compound cube CubeC (CubeA,CubeB).
Last answer 14 June 2016 Last comment 15 June 2016
In DeepSee, having a customer account cube. The cube includes a time dimension AccountCreationDate.
Last answer 8 June 2016 Last comment 8 June 2016
Hi!
There is an example in Samples which shows how to implement 'running total' measure: "Pareto Chart for Category" dashboard.
To calculate running total this pivot uses calculated measure with %Cell expression:
Measures.[Revenue as Percent of Total] + %CELL(0,-1)
Last answer 31 March 2016 Last comment 8 June 2016
Hi all,
I have a dashboard which shows the growth of the months compared with the month from the last year.
Last answer 13 May 2016 Last comment 16 May 2016
The DeepSee Shell Best Practices Series - Example of using the MDX subquery flag in the DeepSee Shell
The DeepSee Shell Best Practices Series - Get your MDX query plan, MDX Query Trace and more from the DeepSee Shell
The DeepSee Shell best Practices Series - Execute an MDX query in the DeepSee Shell with/without results cache
The DeepSee Shell Best Practices Series - Reset your DeepSee cache in the DeepSee Shell