Slow GUIs: Why?
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Slow GUIs: Why?
I don't use the GUIs a lot but when i do it is almost always to add either a security group or attribute to a dimension. In the attribute GUI especially, why is it so horribly slow to produce the initial view? On a dimension with only 33k elements (plenty of those consolidations) it is taking over 10 minutes to produce the GUI when all i want to do is add a new attribute. I know i can easily write a TI to add one and it'll be lightning quick, but honestly why produce a GUI to make that kind of maintenance "easy" when it is so slow? A cube view of the same data is near instant, so what is the GUI doing that the cube viewer isn't?
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
-
- Community Contributor
- Posts: 300
- 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: Slow GUIs: Why?
As you observe when you use the }Element_Atttributes~.cub to do the same thing editing the attributes is pretty much instant.
I think the application is just badly written and there's no pressure for them to fix it.
I think the application is just badly written and there's no pressure for them to fix it.
-
- MVP
- Posts: 352
- Joined: Wed May 14, 2008 1:37 pm
- OLAP Product: TM1
- Version: 2.5 to PA
- Excel Version: Lots
- Location: Sydney
- Contact:
Re: Slow GUIs: Why?
A process to create an attribute is one of the utility processes that live in my template directory for new servers.
My understanding is that the Edit Element Attributes dialog takes so long because it is loading the whole cube into the grid before displaying anything, whereas Cube Viewer only loads a couple of pages of data, then shows that data. When you page down/scroll down in cube viewer you will see a couple of pages instantly, but if you page fast enough you should see a slight pause or empty cells if you are scrolling whilst it goes away and gets more data.
Also the EEA dialog allows you to cancel your input (i.e. it is storing your changes until you hit OK rather than applying them immediately as per cube viewer), and does extra stuff like the checking and red highlighting on duplicate aliases.
Having said all that, I generally use the }ElementAttributes cubes...
My understanding is that the Edit Element Attributes dialog takes so long because it is loading the whole cube into the grid before displaying anything, whereas Cube Viewer only loads a couple of pages of data, then shows that data. When you page down/scroll down in cube viewer you will see a couple of pages instantly, but if you page fast enough you should see a slight pause or empty cells if you are scrolling whilst it goes away and gets more data.
Also the EEA dialog allows you to cancel your input (i.e. it is storing your changes until you hit OK rather than applying them immediately as per cube viewer), and does extra stuff like the checking and red highlighting on duplicate aliases.
Having said all that, I generally use the }ElementAttributes cubes...
Andy Key