Subset Editor Filter By View Extract Survey
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Subset Editor Filter By View Extract Survey
In the course of creating my latest cinematic extravaganza I was explaining the role of the Filter By View Extract button in Subset Editor when I realised that:
(a) I had never gotten it to work in the way that I considered to be "right" and
(b) I have never found a practical use for it, especially after MDX appeared.
Which set me to wondering. What I was wondering is in the survey above.
I thought that it might be of curiosity value if nothing else.
Votes can be changed until the poll closes if you have second thoughts.
(a) I had never gotten it to work in the way that I considered to be "right" and
(b) I have never found a practical use for it, especially after MDX appeared.
Which set me to wondering. What I was wondering is in the survey above.
I thought that it might be of curiosity value if nothing else.
Votes can be changed until the poll closes if you have second thoughts.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- jim wood
- Site Admin
- Posts: 3953
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Subset Editor Filter By View Extract Survey
The only time I've ever used it is when doing user training. As far as I'm aware that's the last time any of the students used it as well.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Subset Editor Filter By View Extract Survey
Would be useful if they actually linked it with the MDX ability to filter by cube values so that you could record the expression as a way of explaining to new users/developers how the MDX filter function works. But you can't and it doesn't - so completely useless when the MDX option is available as an alternative.
Declan Rodger
-
- Regular Participant
- Posts: 152
- Joined: Sat May 25, 2013 10:32 am
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2
- Excel Version: 2007
Re: Subset Editor Filter By View Extract Survey
I have just went through during self-learning.
Never used in real time, but will like to implement and know what exactly the use of it.
Never used in real time, but will like to implement and know what exactly the use of it.
-
- MVP
- Posts: 3667
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Subset Editor Filter By View Extract Survey
Whenever I'm teaching TM1 to users I always make the point in the subset editor section "don't worry about this button, you will never use it."
It is a completely useless feature as it has context only when the subset editor is launched from a view and is restricted to hardcoded values. Its an anachronism to a time when TM1 didn't support MDX, the cube viewer was a whiz-bang modern user interface and the business PC of choice was an IBM 386.
You can do so much more, and better, with MDX that there is no reason to ever use it.
It is a completely useless feature as it has context only when the subset editor is launched from a view and is restricted to hardcoded values. Its an anachronism to a time when TM1 didn't support MDX, the cube viewer was a whiz-bang modern user interface and the business PC of choice was an IBM 386.
You can do so much more, and better, with MDX that there is no reason to ever use it.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: Subset Editor Filter By View Extract Survey
That's what I do too.lotsaram wrote:Whenever I'm teaching TM1 to users I always make the point in the subset editor section "don't worry about this button, you will never use it."
Michel
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Subset Editor Filter By View Extract Survey
A cruel but fair assessment, I think.lotsaram wrote:It is a completely useless feature as it has context only when the subset editor is launched from a view and is restricted to hardcoded values. Its an anachronism to a time when TM1 didn't support MDX, the cube viewer was a whiz-bang modern user interface and the business PC of choice was an IBM 386.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Regular Participant
- Posts: 152
- Joined: Sat May 25, 2013 10:32 am
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2
- Excel Version: 2007
Re: Subset Editor Filter By View Extract Survey
Hi All,You can do so much more, and better, with MDX that there is no reason to ever use it.
I have just seen few times a MDX expression, but never worked in real time scenario.
Can someone please share a link where it has good number of examples for learning on MDX?
Thanks in advance
![Smile :)](./images/smilies/icon_e_smile.gif)
Regards,
Deepak Jain
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Subset Editor Filter By View Extract Survey
If you search this forum for MDX you will find plenty of examples, you will also see that almost every other MDX related post points users towards the "MDX Primer". So searching the forum or googling TM1 MDX Primer will be a strong position to start.deepakjain2020 wrote:Hi All,You can do so much more, and better, with MDX that there is no reason to ever use it.
I have just seen few times a MDX expression, but never worked in real time scenario.
Can someone please share a link where it has good number of examples for learning on MDX?
Thanks in advance
Regards,
Deepak Jain
Declan Rodger
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Subset Editor Filter By View Extract Survey
This is an interesting coincidence. Yesterday's "My Notifications" feed had someone raising this PM:
All this, and a server crash too.PI26187: TM1 SERVER CRASH AFTER RUN SUBSET OPTION "FILTER BY VIEW EXTRACT"
Customer TM1 server crash after run subset option "Filter by View Extract"
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Subset Editor Filter By View Extract Survey
They were probably reading this forum and thought they'd try out the functionality...Alan Kirk wrote:This is an interesting coincidence.
![Laughing :lol:](./images/smilies/icon_lol.gif)
Robin Mackenzie
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Subset Editor Filter By View Extract Survey
Actually that thought had crossed my mind. It'd be a heck of a coincidence otherwise.rmackenzie wrote:They were probably reading this forum and thought they'd try out the functionality...Alan Kirk wrote:This is an interesting coincidence.
"Hmm, that's interesting. So what does that function do, exactly?"
BOOOOOOM!
"Ooooh, s!!!!!!!!!!!t!"
Gee, sorry about that fellow forumer. I hope that wasn't your Production system there...
![Embarrassed :oops:](./images/smilies/icon_redface.gif)
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Subset Editor Filter By View Extract Survey
Somewhere in 9.5.2 there was a bug in the View Extract piece that caused an insta-crash. It was fixed in one of the FP releases. Perhaps they ran into that bug?
Robin Mackenzie