Old TM1 version

Post Reply
CellPutN
Posts: 4
Joined: Mon Oct 01, 2018 1:50 pm
OLAP Product: TM1
Version: 10.2.20500.75
Excel Version: 2016
Location: Montreal, Canada

Old TM1 version

Post by CellPutN » Thu Jan 10, 2019 4:12 pm

Hello,
I'm using tm1 since 2016 and I always wonder what older TM1 (Sinper TM/1, Applix TM1) looks like ? Did Sinper and Applix have always used architect ? Did anyone have screenshot of older version ?

Thanks !

User avatar
jim wood
Site Admin
Posts: 3627
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Old TM1 version

Post by jim wood » Thu Jan 10, 2019 4:31 pm

Architect only came with version 7. Before that it was very different. Everything was built in to Excel. Even loading data as there was no TI either.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Alan Kirk
Site Admin
Posts: 5853
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Old TM1 version

Post by Alan Kirk » Thu Jan 10, 2019 6:44 pm

jim wood wrote:
Thu Jan 10, 2019 4:31 pm
CellPutN wrote:
Thu Jan 10, 2019 4:12 pm
Hello,
I'm using tm1 since 2016 and I always wonder what older TM1 (Sinper TM/1, Applix TM1) looks like ? Did Sinper and Applix have always used architect ? Did anyone have screenshot of older version ?

Thanks !
Architect only came with version 7. Before that it was very different. Everything was built in to Excel. Even loading data as there was no TI either.
Or built into Lotus 1-2-3. There was a time when Excel support was New! And! Exciting!

From the Perspectives 2.6 manual, this is what the ancestor of Cube Viewer looked like:
CubeViewer.jpg
CubeViewer.jpg (114.79 KiB) Viewed 208 times
And this is what Subset Editor looked like. Unsurprisingly there were no alias buttons at that time, because the concept of an alias had yet to exist:
SubsetEditor.jpg
SubsetEditor.jpg (132.08 KiB) Viewed 208 times
jim wood wrote:
Thu Jan 10, 2019 4:31 pm
Even loading data as there was no TI either.
That functionality is still there in the form of the "Example" and "Process" buttons on the ribbon tab, though I'd lay odds that 95% of TM1 users have never looked at those or know what they mean. There was a VBA based tool (once Excel support came along) which sat over that which you could use to schedule the imports. It was about as reliable as a first generation steam train (as in, Stephenson's Rocket, but less robust) and although I used to use the thing daily I cannot for the life of me remember its name now. My then-boss later-assistant used to loathe it with a passion. (At least it was less finnicky than PAW.)

But who could forget the ability to import / export similarly formatted spreadsheets?
ImportSpreadsheets.jpg
ImportSpreadsheets.jpg (115.8 KiB) Viewed 208 times
{Pauses... stands up, looks over shoulder in the general direction of 1999, looks at 2019 calendar on the wall....} What the hell just happened?
"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.

bgregs
Posts: 56
Joined: Wed Sep 12, 2018 11:19 am
OLAP Product: TM1 / Planning Analytics
Version: 2.0
Excel Version: 2016

Re: Old TM1 version

Post by bgregs » Thu Jan 10, 2019 8:53 pm

@Alan Kirk,

My god that explains the random macros that I stumbled across!! These are still hanging around as of PA 2.0 under the name "IMPEXP_WORKS" and can still be mapped into the Quick Access Ribbon by looking under the "Macros" drop-down. ;)
Attachments
impexp_works.PNG
impexp_works.PNG (18.74 KiB) Viewed 199 times

User avatar
Alan Kirk
Site Admin
Posts: 5853
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Old TM1 version

Post by Alan Kirk » Thu Jan 10, 2019 9:41 pm

Alan Kirk wrote:
Thu Jan 10, 2019 6:44 pm
There was a VBA based tool (once Excel support came along) which sat over that which you could use to schedule the imports. It was about as reliable as a first generation steam train (as in, Stephenson's Rocket, but less robust) and although I used to use the thing daily I cannot for the life of me remember its name now. My then-boss later-assistant used to loathe it with a passion. (At least it was less finnicky than PAW.)
Ah, now I remember. It was called "Data Control". Clearly a suppressed memory.
bgregs wrote:
Thu Jan 10, 2019 8:53 pm
@Alan Kirk,

My god that explains the random macros that I stumbled across!! These are still hanging around as of PA 2.0 under the name "IMPEXP_WORKS" and can still be mapped into the Quick Access Ribbon by looking under the "Macros" drop-down. ;)
That's not surprising; I don't think that the Perspectives add-in has been cleaned out in a very, very long time. Whether the functionality still works equally in 32 bit and 64 bit is a different matter given the issue with something as basic as the xdi dimension open function. The intention was that PAx would be the cleanout, but, hey... PAW and the curse of Docker. So the legacy code lives on.
"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
Michel Zijlema
Site Admin
Posts: 703
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: Old TM1 version

Post by Michel Zijlema » Fri Jan 11, 2019 7:22 am

And if we go even further back in time :ugeek: ... there was this interface:
TM1_4.0.png
TM1_4.0.png (77.96 KiB) Viewed 169 times

User avatar
jim wood
Site Admin
Posts: 3627
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Old TM1 version

Post by jim wood » Fri Jan 11, 2019 12:25 pm

Alan Kirk wrote:
Thu Jan 10, 2019 6:44 pm
Or built into Lotus 1-2-3. There was a time when Excel support was New! And! Exciting!
I forgot all about Lotus. I used to love Lotus. With the power keys you could do everything without touching a mouse it was awesome!!
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

CellPutN
Posts: 4
Joined: Mon Oct 01, 2018 1:50 pm
OLAP Product: TM1
Version: 10.2.20500.75
Excel Version: 2016
Location: Montreal, Canada

Re: Old TM1 version

Post by CellPutN » Tue Jan 15, 2019 12:54 pm

Wow thanks guys !

Nice to see how TM1 / PAW has improved over years !

Post Reply