Analyzer

Subscribe to Analyzer content with RSS Syndicate content or email

Localization of DeepSee Pivots

How can I localize arbitrary column name in DeepSee pivot?

If a column name is a dimension or a measure I can localize using architect following this guide.

But what about some random string?

I have tried setting:

  • Value
  • $$$Value
  • $$$Value/MYDOMAIN

as a Caption, but every option simply displays as is.

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 Range

I am building a pivot table and need help creating a calculated field for a dollar range. For instance, I am trying to create a calculated field to show account balance greater than $5k and less than $10k.

views

rating

DeepSee Tips & Tricks: Auto-execute

By default, Analyzer executes queries as components are added. Often, there are times where you may know exactly what you are looking to do, and you do not want Analyzer to execute 5 queries as you drag and drop items onto rows/columns and select your filters. This is where toggling Auto-execute off can help.

views

rating

Grand Total

How can I create a calculated field that will give me the grand total of a column? For instance, if I have a row that has 200, 300, 500, 600, how do I get the Grand Total?

views

rating

Calculated Fields

  1. How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day.

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

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

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

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.

views

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)

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