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?

 

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

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

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

How can we customize the Excel content exported from the Analyzer/Dashboard ?

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.

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

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

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!

views

rating

Cell width in Deepsee

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

 

 

views

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

views

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.

views

rating