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

<<  March 2024  >>
MoTuWeThFrSaSu
26272829123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar