Skip to Content
0
Former Member
Mar 27, 2014 at 05:45 PM

Row Calculation (Navigation Ragged Dimension)

22 Views

Hello,

I have a row calculation/navigation question with the Olap Analysis product in 4.1 compare to 3.1. Currently we are in BOE3.1 but want to go BI4.1.

We use SSAS 2008 as the main source for OLAP. In 3.1 when we don't want to see a member (in this case central), we de-select it from

the members list, the total remain the same. In 4.1 we cannot do that anymore. If we de-select central from the members list,

the total re-calculate as depicted by the example below. Basically the row column become a filter. Is there a option for this so the data doesn't recalculate. We want the same behavior as 3.1

On a related note. The navigation on the slice and dice in analysis is more cumbersome in 4.1, you always have to go the the layout

to change filter. Is there a way to make it more similar to 3.1. Less clicking

Region

Total Count

Total sales

All Region

6

60

East

1

10

Central

2

20

West

3

30

In Voyager

Region

Total Count

Total sales

All Region

6

60

East

1

10

West

3

30

Olap Analysis

Region

Total Count

Total sales

All Region

4

40

East

1

10

West

3

30

Thanks

rs