RFE 73333-Copy visible members from a cube view

Suggest and discuss enhancements for TM1
Post Reply
User avatar
gtonkin
MVP
Posts: 511
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

RFE 73333-Copy visible members from a cube view

Post by gtonkin » Fri Jun 26, 2015 5:28 am

When working with cube views, whether in perspectives, TM1 web or CAFE, often a cube view is reduced by selecting the relevant elements from each dimension to yield an informative view.
Often the members returned are then required for some further analysis but cannot be selected form that view.

A user is viewing a cube with expense information by cost center. The view is zero suppressed and returns the training spend for a particular month showing only those cost centers with a spend.
For arguments sake, there are 5,000 cost centers with 30 that have a spend. There is no way for the user to right click the dimension and copy only visible members to the clipboard.
For that matter, there is no way to create a subset from the visible members (only possible through an MDX with a cube referenced filter-not practical for many users)

Users who need to re-use members from a view normally need to try and slice the view to Excel so that they can copy the members being shown in the cube view.
Once copied they inevitably return to the cube environment to use the list in further analysis.
The current workaround is time consuming, error-prone and very inefficient. A copy visible members would really go a long way to making users work smarter.

RFE 73333 can be found here - please vote as I am sure everyone of you reading this could benefit!

This post refers to the same need - sorry only found after loading this. I could not however see the RFE link or find on the RFE on IBM's site so now it is loaded there.
Last edited by gtonkin on Wed Aug 19, 2015 8:11 pm, edited 1 time in total.

lotsaram
MVP
Posts: 2998
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

Re: RFE73333-Copy visible members from a cube view

Post by lotsaram » Fri Jun 26, 2015 6:51 am

IBMwebsite.jpg
IBMwebsite.jpg (43.78 KiB) Viewed 2873 times
Good idea, I would vote for it, ...
But ... IBM website, what more is there to say?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

User avatar
gtonkin
MVP
Posts: 511
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: RFE73333-Copy visible members from a cube view

Post by gtonkin » Fri Jun 26, 2015 7:12 am

Aaah yes - I waited almost a month to log but contacted IBM who said to delete my cookies.
I am using Firefox so went to Tools, Options, Privacy, Remove individual cookies and removed the IBM.COM cookie, went back to the site, logged in and could start submitting and reviewing again.
Good luck and thanks for making the effort.

Wim Gielis
MVP
Posts: 1538
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: RFE73333-Copy visible members from a cube view

Post by Wim Gielis » Tue Jul 07, 2015 9:42 am

gtonkin wrote:This post refers to the same need - sorry only found after loading this. I could not however see the RFE link or find on the RFE on IBM's site so now it is loaded there.
Indeed, I remember posting this. Thanks for going to IBM, I did not do that.
I just voted on the IBM site.
Let's hope it will be implemented soon because this is so timeconsuming.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

User avatar
gtonkin
MVP
Posts: 511
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: RFE73333-Copy visible members from a cube view

Post by gtonkin » Tue Jul 07, 2015 10:11 am

Thanks Wim, holding thumbs too.

User avatar
Alan Kirk
Site Admin
Posts: 5719
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: RFE73333-Copy visible members from a cube view

Post by Alan Kirk » Wed Jul 29, 2015 11:14 pm

I just voted for this as well.

One thing about the "Internal Server Error", though... it's not just down to cookies. You'll also get that displayed if you click on the link but are not logged in to DeveloperWorks. So you click the Sign In link at the top right, and... you still get an Internal Server Error. BUT! If you now return to the thread and click on the very same link again, then you will be taken to it.

Like Lotsa said, "IBM website, what more is there to say". Clearly as much effort has been invested in error handling for their websites as they invested in error handling for the classic API.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
gtonkin
MVP
Posts: 511
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: RFE73333-Copy visible members from a cube view

Post by gtonkin » Thu Jul 30, 2015 4:56 am

Thanks for voting Alan.

User avatar
gtonkin
MVP
Posts: 511
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: RFE 73333-Copy visible members from a cube view

Post by gtonkin » Mon Nov 09, 2015 6:04 pm

We are up to 12 votes on this one! Thanks to all those who voted and see the value of having this functionality added.

Post Reply