If You Could ask the TM1 Development Team a Question.......

Suggest and discuss enhancements for TM1
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: If You Could ask the TM1 Development Team a Question....

Post by iansdigby »

Alan Kirk wrote: Or, you could use WordPad if you want to be able to actually see the text and punctuation (such as the comma that looks like a period, but isn't or vice versa) on a high resolution screen because the code, in its unchangeable and small font, is reduced to microdots.
Heartily agree.It is also frustrating that the TI query window cannot be made larger, making all but the simplest SQL hard to write.
"the earth is but one country, and mankind its citizens" - Baha'u'llah
User avatar
jim wood
Site Admin
Posts: 3951
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: If You Could ask the TM1 Development Team a Question....

Post by jim wood »

One of the things that gets on my nerves is the inability to easily save a TI script to overwrtie another one, say overwrite a production process with a fully tested development version.

You have to delete the old one and manually enter the name when saving as.
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
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: If You Could ask the TM1 Development Team a Question....

Post by lotsaram »

http://www.tm1forum.com/viewtopic.php?p=29383#p29382
lotsaram wrote:BUT why for the love of <insert deity of choice> cant we have a TI function that returns a numeric value of the server build? Every other software on the planet has a function to do this and it would be EXTREMELY useful to have such a function in TI to allow for code branching to handle running the same TI under different TM1 versions where newer functions may or may not be supported. Quite a few come to mind beyond this new CellIncrementN function; GetProcessName, CubeClearData, ViewExists, SubsetExists, BatchUpdate, LockOn .....
MSidat
Community Contributor
Posts: 110
Joined: Thu Aug 26, 2010 7:41 am
OLAP Product: TM1, PA
Version: PAL 2.0.8
Excel Version: 2016
Location: North West England

Re: If You Could ask the TM1 Development Team a Question....

Post by MSidat »

1, In Perspectives, when in cube viewer with zero supression on you are able to slice/snapshot the view out into excel to copy the non zero suppressed elements of a dimension to start your next view. This is sometimes needed when you are working your way down a number of consolidated elements to fix an issue.

However not all of us use perspectives all the time especially when you want multiple instances open so could a similiar facility exists in Architect where in a cube view there is the facility to copy the display elements of a selected dimension into the clipboard.

2, Can we have a function that enables you to add an element into a consolidation in a particular position and to go alongside this a function that returns the position of an element in a given consolidation.
Always Open to Opportunities
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

Re: If You Could ask the TM1 Development Team a Question....

Post by winsonlee »

When i right click on the cube it gives me the option to Unload Cube. But there isnt any option to Reload Cube or Refresh cube.
very often i copy the cube from production to development server and to refresh the cube, I have to restart the IBM Cognos Analytic Server which takes a long time.
User avatar
Alan Kirk
Site Admin
Posts: 6606
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: If You Could ask the TM1 Development Team a Question....

Post by Alan Kirk »

winsonlee wrote:When i right click on the cube it gives me the option to Unload Cube. But there isnt any option to Reload Cube or Refresh cube.
That's because it's not necessary; simply querying the cube (browsing it, etc) reloads the cube into memory.
winsonlee wrote:very often i copy the cube from production to development server and to refresh the cube, I have to restart the IBM Cognos Analytic Server which takes a long time.
Yes, that's really an issue of hot promotion (or the lack thereof) which has come up before in this thread.
"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.
jstrygner
MVP
Posts: 195
Joined: Wed Jul 22, 2009 10:35 pm
OLAP Product: TM1
Version: 9.5.2 FP3
Excel Version: 2010

Re: If You Could ask the TM1 Development Team a Question....

Post by jstrygner »

Alan Kirk wrote:
winsonlee wrote:When i right click on the cube it gives me the option to Unload Cube. But there isnt any option to Reload Cube or Refresh cube.
That's because it's not necessary; simply querying the cube (browsing it, etc) reloads the cube into memory.
If there are any other cubes that feed your unloaded cube you also need to reprocess feeders from those cubes to have all feed flags in the reloaded cube set again.
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: If You Could ask the TM1 Development Team a Question....

Post by sachin »

It would be great if TI processes are made visible in Cognos Connection.

Currently we use Event Studio and schedule lot of our planning macros. On similar lines if we had capability to schedule TM1 processes via Cognos Connection. We could then run a TI process, then run a BI report (buiit off of it) and burst the report to recipients e-mail. Right now there is a disconnect between TI completing a process and us running/bursting our reports.
Check out my blog for some good information on TM1, SPSS
Sebastian Paulussen
Posts: 12
Joined: Mon Feb 20, 2012 1:02 pm
OLAP Product: TM1
Version: 9.5+
Excel Version: 2010
Location: Rhine-Neckar-Area, Germany

Re: If You Could ask the TM1 Development Team a Question....

Post by Sebastian Paulussen »

sachin wrote:It would be great if TI processes are made visible in Cognos Connection.

Currently we use Event Studio and schedule lot of our planning macros. On similar lines if we had capability to schedule TM1 processes via Cognos Connection. We could then run a TI process, then run a BI report (buiit off of it) and burst the report to recipients e-mail. Right now there is a disconnect between TI completing a process and us running/bursting our reports.
You can easily achieve that with a small enhancement to your Cognos BI Server. We did do that with a cvs.
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: If You Could ask the TM1 Development Team a Question....

Post by sachin »

Sebastian Paulussen wrote:
You can easily achieve that with a small enhancement to your Cognos BI Server. We did do that with a cvs.
Sebastian, can you give little more detail on how you achieved this? I am interested in knowing your idea. It will be fantastic if we can accomplish it in our environment. Thank you so much!
Check out my blog for some good information on TM1, SPSS
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: If You Could ask the TM1 Development Team a Question....

Post by iansdigby »

"Have you ever tried to persuade the IBM customer support web site development team to socialise with real humans more often? That way we might get a web experience that approaches user-friendliness."

Ian
"the earth is but one country, and mankind its citizens" - Baha'u'llah
User avatar
sachin
Posts: 92
Joined: Fri Jan 15, 2010 9:54 pm
OLAP Product: Transformer,SSAS, EP, TM1
Version: 7.3 2005 10.1 10.1.1
Excel Version: 2013
Contact:

Re: If You Could ask the TM1 Development Team a Question....

Post by sachin »

*bump*

Sebastian, can you explain more on how you achieved it? Thanks.

One more feature that we'd like to see is AsciiOutput support append functionality to a file, instead of creating a new one each time.
Check out my blog for some good information on TM1, SPSS
Markus_L
Posts: 1
Joined: Wed May 16, 2012 8:35 am
OLAP Product: TM1
Version: TM1 9.5.x TM1 10.1
Excel Version: XL 2003 2007 XL 2010

Re: If You Could ask the TM1 Development Team a Question....

Post by Markus_L »

Well here's one from my side:

When will we get a performant, easy to use SAP Connector?

Best Regards
mhackTM1
Posts: 3
Joined: Fri Jun 22, 2012 6:41 am
OLAP Product: IBM Cognos TM1
Version: 9.5.2
Excel Version: 12

Re: If You Could ask the TM1 Development Team a Question....

Post by mhackTM1 »

Do they have the plan to put color coding in TI? like blue/green for a TI function and red for an error.
iansdigby
Community Contributor
Posts: 109
Joined: Thu Feb 26, 2009 8:44 am
OLAP Product: TM1
Version: 9 + 10 + Plan An
Excel Version: All
Location: Isle of Wight, UK

Re: If You Could ask the TM1 Development Team a Question....

Post by iansdigby »

I would say dedicate a full release to UI enhancements/corrections. For example:

1. Fix the copying and pasting behaviour in the Advanced Rules Editor and the TI editor (and doubtless elsewhere) to match the Windows standards.
2. Fix drop-downs (e.g. TI Variable type, Pick Lists and doubtless in other places I have missed), so they display the WHOLE text of the listed items.
3. Increase the size of, and enhance, the query field in the TI Data Source area, so it is easier to write SQL.
4. Fix the Rules tracer so that it does not occasionally hide itself in a minimised state on opening.
5. Fix the Security dialog box so that Group columns do not misalign when scroling to the right.
6. Introduce colour- and conditional-formatting of cells within the Cube Viewer.

If IBM adopted an attitude to UI integrity closer to that of Microsoft, it would reflect very well on the TM1 product. Some UI elements within TM1 fall on the side of shoddiness.

Otherwise, what a fantastic product TM1 is!
"the earth is but one country, and mankind its citizens" - Baha'u'llah
nick_leeson
Posts: 98
Joined: Sat Feb 11, 2012 11:13 am
OLAP Product: TM1 9x, BPC, Hyperion, HANA
Version: TM1 10
Excel Version: Excel 2003 - 2010

Re: If You Could ask the TM1 Development Team a Question....

Post by nick_leeson »

Fix the issues in TM1 Cognos Insight , its an embarrassing product again cannot compete with QlikView or Tableau.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: If You Could ask the TM1 Development Team a Question....

Post by lotsaram »

nick_leeson wrote:Fix the issues in TM1 Cognos Insight , its an embarrassing product again cannot compete with QlikView or Tableau.
Can you clarify exactly what features
- don't work?
- should work better?
- aren't there but need to be?
As it stands there isn't anything constructive in your gripe.
nick_leeson
Posts: 98
Joined: Sat Feb 11, 2012 11:13 am
OLAP Product: TM1 9x, BPC, Hyperion, HANA
Version: TM1 10
Excel Version: Excel 2003 - 2010

Re: If You Could ask the TM1 Development Team a Question....

Post by nick_leeson »

Here is my 2 cents worth and I have got out from the wrong side of the bed so ...

We had a demo of TM1 Insight with an established user of QlikView last week and frankly these are some of the conclusions we came

1) Visualization , lack of quality charting, the charting is best described as average compared to QlikView or Tableau.
2) TAB's are nice but I would like to have security based on TAB's in the CDD Files. I guess TM1 security will apply.
3) TI's take approx 3 times the time they take via Architect or Perspectives.
4) Performance i.e. took 15 seconds to move between tabs. This could be subjective so I would like members opinion on this.
5) Pass CDD's around , Why can't we store them in Traditional Applications folder ?
6) Promotion from Dev to Prod, I know there are "workarounds" but that's simply not good enough.
7) Printing, You can't print these reports ! Can't export them to PDF.
8) Spreading , if its a contribution tool then that's a must.
9) How is user going to refersh the Tab's apart from logging off and logging back on ? Have I missed a point here ?
10) Why is only one CDD file allowed to published via TM1 Applications ?
11) In Connected mode the performance even by IBM admission is not recommended.


The standard reply we got from IBM was "but it's a good Pre Sales tool" .. We ain't taking it to anybody ever again.

Cheerio
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: If You Could ask the TM1 Development Team a Question....

Post by Steve Rowe »

Allow us to modify the ReturnViewHandle statement in drill TIs so they can be generalised with variables.
Technical Director
www.infocat.co.uk
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: If You Could ask the TM1 Development Team a Question....

Post by lotsaram »

Steve Rowe wrote:Allow us to modify the ReturnViewHandle statement in drill TIs so they can be generalised with variables.
Yes please :D

As Wim recently pointed out
IF( 1=0 );
code
ENDIF;
... is so yesterday.
and to make cube to cube drill through really useful and dynamic there is no current alternative.
Post Reply