Cube Viewer (CV)/Subset Editor (SE) Enhancements

Suggest and discuss enhancements for TM1
Post Reply
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Cube Viewer (CV)/Subset Editor (SE) Enhancements

Post by John Hammond »

Suggestions to make those day to day tasks easier please.

My starter for 2

1. Double click on element in row column dimension turns that element into a title element.
2. Zero Suppress has option to display subset editor with only elements that have values. ie on clicking on the SE bar you get the same display as you have in CV.
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Cube Viewer (CV)/Subset Editor (SE) Enhancements

Post by John Hammond »

Default color coding for dimension elements Black for consolidation, GreeN for N level - infact just adding color would make CV a lot more functional.
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Cube Viewer (CV)/Subset Editor (SE) Enhancements

Post by John Hammond »

Reg Expression search

Dont call it Regex when it is a DOS type wildcard search.

SE to have ability to find wildcard in displayed structure while not restricting display to only the thing you are searching for.

Drop down and repeat previous searches
Last edited by John Hammond on Wed Oct 05, 2011 6:38 pm, edited 1 time in total.
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Cube Viewer (CV)/Subset Editor (SE) Enhancements

Post by John Hammond »

CV to have ability to Cut and Paste Title/Row/Column dimension values directly without going into SE (this does not always get same dimension values when zero suppress is on)
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Cube Viewer (CV)/Subset Editor (SE) Enhancements

Post by John Hammond »

When the Subset Editor is invoked from a Column based dimension. Default behaviour should be to save all the dimension display NOT just the selected element.

A MILLION TIMES HAVE I ACCIDENTALLY SELECTED AN ELEMENT IN A LIST AND HAD TO GO BACK AFTER GETTING THE WRONG SELECTION. I ALWAYS CLICK IN THE RIGHT PANEL NOW JUST TO BE SAFE!

Actually thinking about it the selected element should be the beginning of the display for the row or column ie if we have 2008..2012 and 2010 is selected then the display of the column or row should be windowed to start at 2010 in the left or top.

This would make the columns, rows and titles compatible.
John Hammond
Community Contributor
Posts: 295
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Cube Viewer (CV)/Subset Editor (SE) Enhancements

Post by John Hammond »

When you make a selection in CV it should show the total on the status bar at the bottom like excel does. It might usefully also show the count but anything beyond that is overkill.

If anyone knows a neat way of determining the total without slicing the data to excel then I would be pleased to know.
Post Reply