Zero Supression

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Dave

Master

Posts: 37

Date of registration: Dec 8th 2005

Tuesday, February 21st 2006, 11:06am

Zero Supression

Firstly I would like to say how much I like the RCP and congratualte you for all the work.

I didn't where to post this since it's a wish, but I guess this folder will be more actively monitored by your colleagues at Tensgerity

Basically it would cool if there was an option for the rows, columns in the cube browser to supress data where all the values in the row or column are zero / null.
I realise this would probably mean fetching all the values from the server and then filtering on the client so that the rows/columns aren't dispalyed.
This would be a really useful feature for ad-hoc cube browsing, especially in very large sparse cubes, since it can be a real pain trying to find data in some cubes.

Go to the top of the page

Stepan

Intermediate

Posts: 14

Date of registration: Feb 13th 2006

Location: Cologne/Germany

Tuesday, February 21st 2006, 12:43pm

RE: Zero Supression

Hi Dave,

thanks for your positive feedback about our initial code drop.

definately cube-browsing as currently implemented in the eclipse client has a lot of usability issues.

Anumber of things come into my mind right away ...

- Search/Find of max/min and particular values
- Preserving the cube browsing as a querry
- More highlighting using colors
- A short bar of the value beneath the value.
- Automatic hiding of columns/rows based on criteria like an all-zero column/row
(your good suggestion)
- Many other things ...

I believe actually this could easily be done from a technical point of view, but I am not so whether it might not add confusion to the average user.

Also unhiding the column/row right now has to be done by clicking on the dimension in the row or column region and switching the colum/row back on. A lot of clicks indeed, but i don't know a quicker solution of-hand.

Thanks for trying out the eclipse client. Please note the rather extensive online documentation included in it, some features are rather hidden.

Thanks,

Stepan

Stepan Rutz, Tensegrity-Software

Go to the top of the page

Dave

Master

Posts: 37

Date of registration: Dec 8th 2005

Tuesday, February 21st 2006, 1:24pm

>> - Search/Find of max/min and particular values

Yes, and filtering eg Top / Bottom x Values and Top / Bottom x Percentages

>> - Preserving the cube browsing as a querry

Maybe preserving the last views before the application is closed.
Saving views

>> - More highlighting using colors

Conditional Formating - use symbols such as up / down arrows would be handy to display things like KPIs

>> - A short bar of the value beneath the value.

Good idea

>> - Automatic hiding of columns/rows based on criteria like an all-zero >> column/row
>> (your good suggestion)

>> - Many other things ...

Ability to define a SQL query or equivalent of MSAS actions.
Eg SQL for relational drill through to transactions (perhaps the statement could be stored as an attribute in PALO). Or define a URL so you click on a cell and goto a web page etc..

Ability to add attributes to elements in GUI

Analysis Tool - Display grid showing dimensions and which cubes they are / aren't used in.

Batch print / email option - Ability to email / print report(s) perhaps by cycling through specified dimensions and emailing to users defined in attribute fields.

ability to drill down on elements by double clicing on them ie not having to select the child elements from the slicer.

Ability to display attributes instead of element names.

Workflow - Ability to create a workflow, I let the users enter data, but have it held somewhere until it confirmed / rejected by a manager at which point it would be commited to the cube. (Maybe using open source Enhydra code http://www.enhydra.org/workflow/index.html)

This post has been edited 1 times, last edit by "Dave" (Feb 21st 2006, 1:45pm)

Go to the top of the page

Stepan

Intermediate

Posts: 14

Date of registration: Feb 13th 2006

Location: Cologne/Germany

Tuesday, February 21st 2006, 1:50pm

Dave, thank you for your suggestions. This is very valuable input. I cannot however tell you right now what exact future plans we have for the eclipse client. This will need to be discussed at our team first.

Please feel free to post your suggestions anyhow. It is very important for us to get this kind of input

Thanks,
Stepan

Stepan Rutz, Tensegrity-Software

Go to the top of the page

Aranian

Intermediate

Posts: 12

Date of registration: Nov 7th 2006

Wednesday, February 7th 2007, 2:05pm

is the client still in developement? the features mentioned here would be really helpful with my work, so i would be glad to see them added.

Go to the top of the page

Michael

Master

Posts: 44

Date of registration: Feb 9th 2006

Wednesday, February 7th 2007, 2:34pm

yes, it still is and will be. A new Beta Version will be published next week. From the ideas below the following functions are already or will be available with the next version:

- Zero Suppression
- dimension queries (subsets)
- Add attributes to elements for usage within views for element display and selection within dimension queries (subsets)
- Analysis tools to display usage of dimensions and subsets
- Saving and loading views.

Other ideas from the list are waiting to be developed in the future. We will continue to provide new versions with new functionality. Especially manipulating views (traffic lighting, sorting etc.) will be in the focus for the next version.

Michael

Go to the top of the page

Aranian

Intermediate

Posts: 12

Date of registration: Nov 7th 2006

Wednesday, February 7th 2007, 3:04pm

i'm still working with the 1.0 server, so i didn't test the 1.5 beta yet. but this is great news.

thanks for the quick answer and the great tool you make!

Go to the top of the page

Axel

Professional

Posts: 29

Date of registration: Oct 3rd 2006

Wednesday, February 7th 2007, 3:54pm

RE: Zero Supression

>>>Basically it would cool if there was an option for the rows, columns in the cube browser to supress data where all the values in the row or column are zero / null.

BTW, that filtering of real/absent values is rather easy to implement using data export feature, and that will not slow down the app, but will make it faster. I almost sure that Tensegrity guys are going that way - or even passed that way already...

Go to the top of the page