Analyzer


Subscribe to Analyzer 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

Weighted Sales Performance Metric

I am trying to create a query that returns the best and worst performing products for a given customer, based on this year's net sales versus last year's net sales, weighted by the total net sales for all of the p

48

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

Sorting Numeric Dimensions

In DeepSee we have a field that is numeric but is used as a dimension. In DeepSee it sorts this field in the following order. 10, 11, 15, 2, 3, 5, 6, 8, 990.

48

views

0

rating

Fixing errors found when attempting to view a DeepSee listing

This post provides further detail on the suggestions from the DeepSee Troubleshooting Guide about what to do if a user is not able to view a listing in a DeepSee cube, but instead sees errors like this:

ERROR #5540: SQLCODE: -99 Message: User <username> is not privileged for the operation [zfindStatement+118^%SQL.DynamicStatement.1:<namespace>] (8)

45

views

+ 1

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

How to do a TOP 15 Payers and Percent of Total Paid

I'm stuck on how to show the top 15 payers and then also show the percentage of the total amount paid for each one.  The total amount is what was paid by all the payers not just the top 15. 

99

views

0

rating

Defining pivot variables

Is it possible to populate a pivot variable with a defined runtime variable from the settings page?

If so, what is the syntax?

60

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

API to retrieve MDX from a save pivot?

Hello,

165

views

+ 3

rating