Is it possible to hide totals in OLAP Views?

0

Hello!

I created OLAP views for a project that I am working on using Mondrian Schema, JasperETL, and JasperServer.

Everything works great so far, but I want to be able to hide totals when I expand a dimension.

What I want to do is something like this:

Let's say I have something like this in my OLAP View:

Dimenssions Dimension1
+ All Dimension 1
Dimension 2
Dimension 3 Dimension 4 + All Dimension 2
+ All Dimension 3 + All Dimension 4  73

 

If for example I expand dimenssion 3 the view will be like this:

 

Dimensions Dimension1
+ All Dimension 1
Dimension 2
Dimension 3 Level Name Dimension 4 + All Dimension 2
- All Dimension 3 + All Dimension 4  73
 
All Dimension 3 Level 1 + All Dimension 4 42
Level 2 + All Dimension 4 31

 

 

What I want below column to be hidden:

 

- All Dimension 3 + All Dimension 4  73

Is that possible?

Thanks in advanced

facualvez's picture
Joined: Oct 29 2011 - 2:34pm
Last seen: 3 years 7 months ago

0 Answers:

No answers yet
Feedback