Search found 3463 matches

by Alan Kirk
Fri Sep 22, 2017 12:11 pm
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 11
Views: 165

Re: Undo after save in Excel 2016 with TM1 add in

Hi, Just wanted to note that we have not been able to reproduce. Excel 2016 MSO(16.0.8326.2076) Version 1707 which I think is the version being reporting but on an ordinary Office install, so not Office 365. Yes, but I did say that that was the difference. Retail Office 2016 is not updated continuo...
by Alan Kirk
Fri Sep 22, 2017 12:06 am
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 11
Views: 165

Re: Undo after save in Excel 2016 with TM1 add in

I haven't yet been able to test it on the broken notebook and unfortunately I have a project that I need to get done today before I can. Although as it turned out, it took less time than I thought. I can confirm that it is not happening on Excel 2016 version 1706, build 8229.2086 with the TM1 (10.2...
by Alan Kirk
Thu Sep 21, 2017 11:20 pm
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 11
Views: 165

Re: Undo after save in Excel 2016 with TM1 add in

OK, i stronzi piccoli hanno fatto gli aggiornamenti. (Hey, if Salvo Montalbano can say it (and often does), so can I. Although I notice that the English sub-titlers at SBS (the network that broadcasts the series here) often, shall we say... "moderate" Salvo's language at times. ) I'm now on version ...
by Alan Kirk
Thu Sep 21, 2017 7:41 pm
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 11
Views: 165

Re: Undo after save in Excel 2016 with TM1 add in

But no, the Microsoft Office Development team, being the inept, useless, customer-hating pack of pillocks that it is, naturally took a good idea and turned it into a freaking abomination. Hmm, this is an interesting coincidence... right after I posted that I got a pop-up balloon in the system tray;...
by Alan Kirk
Thu Sep 21, 2017 7:20 pm
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 11
Views: 165

Re: Undo after save in Excel 2016 with TM1 add in

No, you're right, there's definitely a problem here. I was going to raise a post asking whether anyone else had experienced it as well but I wanted to see if I could isolate exactly when it occurs. It sounds like you may have, though I was encountering this without (intentionally) saving. I've succe...
by Alan Kirk
Thu Sep 21, 2017 5:19 am
Forum: Cognos TM1
Topic: Unable to launch TM1 Perspective
Replies: 4
Views: 85

Re: Unable to launch TM1 Perspective

I recently have installed TM1 v 10.1.1 on my machine, but while opening the perspective, I am getting below message. Can someone please help? "Method 'OnAction' of object '_CommandBarButton' failed" can come from a number of places. Frankly I get pretty sick of Excel files getting corrupted; I see ...
by Alan Kirk
Wed Sep 20, 2017 6:40 pm
Forum: Cognos TM1
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 2
Views: 701

Re: Fix Pack Releases: PA2 / V11 Series

IMPORTANT: There has been a change in the data structure in PA 2.0.2 IF4. The effect is that if you apply that interim fix or higher you can no longer downgrade to an earlier version. Details can be found here.
by Alan Kirk
Wed Sep 20, 2017 6:37 pm
Forum: Cognos TM1
Topic: Fix Pack Releases: 10.2 Series
Replies: 44
Views: 15926

Re: Fix Pack Releases: 10.2 Series

IMPORTANT: There has been a change in the data structure in 10.2.2 FP7 IF5. The effect is that if you apply that interim fix or higher you can no longer downgrade to an earlier version. Details can be found here.
by Alan Kirk
Wed Sep 20, 2017 3:14 am
Forum: Cognos TM1
Topic: What is an Element really? And, why the heck is an Element Type not an Element Type?
Replies: 4
Views: 256

Re: What is an Element really? And, why the heck is an Element Type not an Element Type?

By the way, ... One thing to clean up to not confuse others following with a similar question: Elements are not data. They are meta data. They describe data. They tell you where the data lives within a cube. They tell you what the data represents. They are not, themselves, data. Some of this is not...
by Alan Kirk
Sun Sep 17, 2017 9:54 pm
Forum: Cognos TM1
Topic: What is an Element really? And, why the heck is an Element Type not an Element Type?
Replies: 4
Views: 256

Re: What is an Element really? And, why the heck is an Element Type not an Element Type?

Given that, here are where my TM1 questions come in.... 1). Why isn't Element Type associated with the Element 's data type? I know that Lotsa isn't out at Jungfraujoch at the moment because if he was then the scream would be echoing off the mountains loudly enough to be heard from here. He explain...
by Alan Kirk
Fri Sep 15, 2017 10:30 pm
Forum: Cognos TM1
Topic: Monthly Poll 201709_10
Replies: 2
Views: 140

Monthly Poll 201709_10

We haven't had a poll for a while so I thought I'd indulge myself to answer a question that I've been flip-flopping on. A new version of the TM1Tools add-in is in the pipeline. Maybe not as fast as many would like, but I'm not getting paid for this, so... It will include 64 bit support plus a few ne...
by Alan Kirk
Fri Sep 15, 2017 5:02 am
Forum: Cognos TM1
Topic: Creating Cube Generates "Cell type is string" error
Replies: 9
Views: 236

Re: Creating Cube Generates "Cell type is string" error

First thanks for taking the time to respond. Much appreciated! And, great info. You are correct. I only have 5 dimensions: Version, Year, Period, Center, Account. I don’t have any other dimensions or measures defined (I couldn't figure out how to create or define a measure - see more about that bel...
by Alan Kirk
Fri Sep 15, 2017 2:24 am
Forum: Cognos TM1
Topic: IBM PA Local Documentation PDF format - Where to find?
Replies: 1
Views: 67

Re: IBM PA Local Documentation PDF format - Where to find?

I found the online PA local documentation. https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/kc_gen/com.ibm.swg.ba.cognos.ipa.doc_getting_started_toc-gen2.html Does anyone know where to find the same documentation in PDF format? Have you looked in the FAQ post ? ( IBM Support Links topic,...
by Alan Kirk
Fri Sep 15, 2017 1:33 am
Forum: Cognos TM1
Topic: Creating Cube Generates "Cell type is string" error
Replies: 9
Views: 236

Re: Creating Cube Generates "Cell type is string" error

Just started learning and am creating my first cube. When running my TI process to create the cube I'm getting a "Cell type is string" error on every row from by data source. I'm not sure what you will need to help, so forgive me if this is long. My data source is from a SQL Server ODBC connection ...
by Alan Kirk
Wed Sep 13, 2017 10:47 pm
Forum: Cognos TM1
Topic: Fix Pack Releases: 10.2 Series
Replies: 44
Views: 15926

Re: Fix Pack Releases: 10.2 Series

End Of Life on both 10.2.0 and 10.2.2 For those who missed it, two announcements came out yesterday. 10.2.0 ends its life on 30 September 2018 . 10.2.2 ends its life one year later on 30 September 2019 . Editorialising I know that 30 September 2019 sounds a long way off, a smidge over 2 years away,...
by Alan Kirk
Wed Sep 13, 2017 10:36 pm
Forum: Cognos TM1
Topic: Fix Pack Releases: 10.2 Series
Replies: 44
Views: 15926

Re: Fix Pack Releases: 10.2 Series

@Alan Kirk can you provide a Fispack List for Planing Analytics also ? There is a Fix Pack Releases thread for every version; you will find it in the FAQ under the heading Hotfix Threads, Containing Details of Hotfix / Fixpack Releases . Only ones which have new information (within the last 30 to 6...
by Alan Kirk
Mon Aug 28, 2017 1:45 am
Forum: Cognos TM1
Topic: TM1 super user
Replies: 2
Views: 163

Re: TM1 super user

We are thinking about creating a new TM1 role called "Super"that has access to all our 90k+ cost centres but not utilizing the admin licences. Is there a quicker way to give write access to all 0 level element in the cost centres dimension then just copy and paste "write" to all? I tried and my com...
by Alan Kirk
Thu Aug 24, 2017 8:49 am
Forum: Cognos TM1
Topic: Export Dimension along with attribute data into excel
Replies: 5
Views: 222

Re: Export Dimension along with attribute data into excel

If you want a human readable form of viewing dimension structure (like subset editor) then you should look at the TM1 Tools add-in. It has a nice feature for exporting dimension structure to Excel and using standard Excel features like grouping to expand and collapse rows. I hear from some semi-rel...
by Alan Kirk
Thu Aug 24, 2017 12:10 am
Forum: Cognos TM1
Topic: Export Dimension along with attribute data into excel
Replies: 5
Views: 222

Re: Export Dimension along with attribute data into excel

Hi, I have a requirement of exporting complete dimension structure along with the attribute values for each element into an excel file. Can anyone please suggest how this can be achieved by using TI process.I have searched many sites but could only find details for exporting just dimension structur...
by Alan Kirk
Wed Aug 23, 2017 12:20 am
Forum: Cognos TM1
Topic: TI process commit
Replies: 1
Views: 123

Re: TI process commit

Hi All, Is there a way to find out when TI process completely done (commit is done)? It takes about 1 hour to commit and after that I need to kick off another process. Thanks! Honestly I don't think I'd bother with that. It would be far easier and more reliable to just queue the processes up to run...