Visual Totals

by Admin21. November 2012 00:06

We are often asked "How to display totals by all levels?" or "how to display totals by the values in the table?". Let us see some examples.

Example 1: "physical" total

 

Australia has 4 states. If we hide one of them

we will get this:

The values aren't changed, as if nothing happened. This is because by default the table shows physical totals which are in the cube.

Example 2: "Visual" total

Let us switch visual totals:

And see what changed:

The values for Australia changed, and now it takes into account the selection made by user.

Deprecated Functionality

BAT has one more functionality for displaying totals:

This is a deprecated functionality which finds just the sum, no matter what kind the measure is. It does it on a client machine, instead of doing it on the server.

If you want to have your totals calculated FINE (taking into account aggregation type, but not just sums), you need to do this:

And choose what you need to look – visual totals, or physical totals. And if you do this, you will have CORRECT totals on every level.

And please, FORGET ABOUT "Show Summary Rows/Columns" FUNCTIONALITY – IT IS AND OLD STUFF WHICH WILL SOMETIMES BE THROWN AWAY.

Why do we still keep this old functionality? Cause people are asking not to remove it. We would do it long ago.

Conslusions

Use member selector to show necessary levels and use visual totals if necessary.

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

About company

BIT Impulse - a software development company, a vendor of a proprietary BI system called "Business Analysis Tool".

Web site: www.bitimpulse.com

Calendar

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar