RFE 73333-Copy visible members from a cube view
Posted: 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.
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.