DeepSee

Subscribe to DeepSee content with RSS Syndicate content or email

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

Mandatory or queried filters for the dashboards

Hi!

There are DeepSee dashboards,  which make sense only when filtered.

Usually, they are used as Drill Target or New_window control with SETTINGS=Widget;FILTER=filtervalue.

views

rating

How to filter two widgets in DeepSee New_Window command?

Hi!

There is a 'New_window' control in DeepSee Widget which opens the page in a new tab in a browser with a given URL.

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

Named filters to work with MEASURES?

The >/</= etc. operands in named filters are great... except they won't work with measures ('native' or calculated - and what a boon it would be if  they could work with both). 

 

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

Named filter in DeepSee

Hi!

There is an option to introduce Named filters in Analyser and save it with the pivot.

How can I make the Named filter available in a dashboard?

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 Troubleshooting Guide

The goal of this “DeepSee Troubleshooting Guide” is to help you track down and fix problems in your DeepSee project.

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 find dependencies of Dimension or Measure to the pivots?

Hi!

I want to optimize the cube and delete the measure. Is there any easy way to find pivots which use it?

Does anyone have any snippet regarding this?

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

Is it possible to build cube(source class:DataConnector) during source table updating?

 Hello,

I have a question regarding Data Connector cube.

views

rating