MDX

Subscribe to MDX content with RSS Syndicate content or email

How to get the measure for the last day in a month in DeepSee

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:

views

rating

How to store json data in session which returns from background method?

Based on user request in zenpage, i am running the method ConvertMDXtoJSON in background and loading the status in progressbar.

views

rating

Best practices for filtering widgets from different cubes in InterSystems DeepSee

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.

views

rating

How to resolve a key from CURRENTMEMBER.Property("prop") in MDX

Hi,

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

views

rating

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

views

rating

How to calculate the number of rows in DeepSee?

Hi!

How can I show a number of rows in a given DeepSee pivot?

 

views

rating

How to calculate percentage of all for a member in DeepSee?

Hi, All!

What is the calculated measure expression for the percentage of a member?

views

rating

DeepSee - Period to date vs same period last year

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.

views

rating

How to compare two dimension values in a filter

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.

views

rating

Newbie Question for creating a this period/same period last year comparison

Hello. I'm just getting started in DeepSee, and am also a newbie in MDX.

views

rating

Accessing Deepsee plugin 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).

views

rating

Building and using Plugins in DeepSee

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.

views

rating

MDX Calculated measure help in DeepSee

I currently have an MDX query/calculated measure as per the below:

views

rating

MDX QUERY

Hi All,

I need some help to create mdx for the following scenario.


My source table is like this format

views

rating

Creating Trend line (scorecard) from data rather than counts

I need to create a KPI similar to the  DeepSee.Model.KPIs.DemoTrendLines kpi in Samples.  This kpi supports a scorecard widget with a trend line.

views

rating