MDX


Subscribe to MDX content with RSS Syndicate content or email

How to calculate the number of rows in DeepSee?

Hi!

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

 

39

views

0

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?

44

views

0

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.

169

views

+ 5

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.

56

views

0

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.

93

views

0

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).

56

views

0

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.

101

views

+ 4

rating

MDX Calculated measure help in DeepSee

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

46

views

0

rating

MDX QUERY

Hi All,

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


My source table is like this format

96

views

0

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.

71

views

0

rating

How to calculate the percentage of higher level

 

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!

89

views

+ 1

rating

Cell width in Deepsee

Is there anything in deepsee where i can increase the cell width?

 

 

66

views

0

rating

How to use a calculated measure in a compound cube ?

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).

72

views

0

rating

Running total without %CELL

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)

118

views

0

rating

How to get the total sum of accounts until a certain date?

In DeepSee, having a customer account cube. The cube includes a time dimension AccountCreationDate.

104

views

+ 1

rating