Hi, DeepSee experts!
I need to call a listing programmatically other than the default.
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
Hi, DeepSee experts!
I need to call a listing programmatically other than the default.
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?
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:
I have a query text that I need to execute and return results as xml.
Based on user request in zenpage, i am running the method ConvertMDXtoJSON in background and loading the status in progressbar.
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.
Hi,
suppose a part of my mdx query is [DIMENSION].[H1].[LEVEL1].CURRENTMEMBER.Property("PROP1").
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
Hi!
How can I show a number of rows in a given DeepSee pivot?
Hi, All!
What is the calculated measure expression for the percentage of a member?
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.
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.
Hello. I'm just getting started in DeepSee, and am also a newbie in MDX.
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).
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:
Hi All,
I need some help to create mdx for the following scenario.
My source table is like this format
I need to create a KPI similar to the
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!
Is there anything in deepsee where i can increase the cell width?
|
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).
In DeepSee, having a customer account cube. The cube includes a time dimension AccountCreationDate.
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:
Hi all,
I have a dashboard which shows the growth of the months compared with the month from the last year.
To leave a comment or answer to post please log in
Please log in