Search found 3477 matches

by Alan Kirk
Tue Nov 21, 2017 8:21 pm
Forum: Cognos TM1
Topic: Cells not calculating unless edited
Replies: 7
Views: 179

Re: Cells not calculating unless edited

They seems to work as normal after edit/enter. It was only 4 cells that were affected on the sheet. I guess I was hoping to find out the cause to avoid having this happen in future. I know that I grouped tabs together to do a bulk edit, and maybe this triggered a bug. It's possible this was an exce...
by Alan Kirk
Wed Nov 15, 2017 9:49 pm
Forum: Cognos TM1
Topic: Installing 32bit TM1 Perspectives on 64 bit windows 7
Replies: 3
Views: 217

Re: Installing 32bit TM1 Perspectives on 64 bit windows 7

Morning All, Just a quick one. IT have rolled out 64 bit windows 7 machines and excel 32 bit has been baked into this VM. Since you need 32 bit Perspective to work with 32bit Excel does the same rule apply to the operating system? i.e will installing 32 bit Perspectives on 64 bit windows environmen...
by Alan Kirk
Sat Oct 28, 2017 12:59 am
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 15
Views: 626

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

I've just been updated to version 1709 (build 8528.2139); the problem seems to have gone away (and DBRWs, active forms etc are still working).

Is anyone else still seeing it?
by Alan Kirk
Tue Oct 17, 2017 10:42 pm
Forum: Cognos TM1
Topic: TM1 Date Display Using Attribute Format
Replies: 7
Views: 338

Re: TM1 Date Display Using Attribute Format

Wow. Ok, so thanks for that Alan. So if I am going to use date formatted cells, then so I can make the model work correctly it sounds like I should force the use of dates to use 1-Jan-1900. That way everything will be consistent. Would you agree? I think in the long term it'll make life easier, tho...
by Alan Kirk
Mon Oct 16, 2017 7:55 pm
Forum: Cognos TM1
Topic: TM1 Date Display Using Attribute Format
Replies: 7
Views: 338

Re: TM1 Date Display Using Attribute Format

There is something that I hadn't updated in the Dates And Times document, which applies to PA only; look for the "UseExcelSerialDate=T" config parameter in the Installation Guide. (I've added a cross-reference to this thread to the guide as an interim solution.) If you look in your server config fi...
by Alan Kirk
Mon Oct 16, 2017 8:19 am
Forum: Cognos TM1
Topic: TM1 Date Display Using Attribute Format
Replies: 7
Views: 338

Re: TM1 Date Display Using Attribute Format

There is something that I hadn't updated in the Dates And Times document, which applies to PA only; look for the "UseExcelSerialDate=T" config parameter in the Installation Guide. (I've added a cross-reference to this thread to the guide as an interim solution.) If you look in your server config fil...
by Alan Kirk
Wed Oct 11, 2017 10:41 am
Forum: Cognos TM1
Topic: Subset create by element type(N,S orC)
Replies: 2
Views: 164

Re: Subset create by element type(N,S orC)

i would like to create subset based on the element type, mean i need to create subset only with numeric elements or string elements. Kindly provide the solution.... And did you have any specific method of creating this subset in mind? GUI, MDX, TI, etc, etc... Have you looked at the various element...
by Alan Kirk
Fri Oct 06, 2017 10:54 am
Forum: Cognos TM1
Topic: TI cutting off dimension elements
Replies: 4
Views: 166

Re: TI cutting off dimension elements

Hello, I've got a dimension that needs to be cloned and the VPPT_* and PT_* elements need to be deleted. The remaining structure above should stay the same and the consolidated MPPT_* elements should be changed to leaf elements (see attachment Dim_Tarif_Plan.PNG). Is there a possibility to get it d...
by Alan Kirk
Thu Sep 28, 2017 7:32 pm
Forum: Cognos TM1
Topic: Excel VBA API Crashing on TM1ObjectListCountGet
Replies: 6
Views: 270

Re: Excel VBA API Crashing on TM1ObjectListCountGet

Thanks to you both for your responses. [snip]... the API is something to be called only as a last resort. With the overwhelming majority of things you are far better off using macro and worksheet function calls. In addition to which, that API, along with all of the legacy APIs, will be going away. ...
by Alan Kirk
Thu Sep 28, 2017 5:41 pm
Forum: Cognos TM1
Topic: Active Forms using multiple cubes
Replies: 5
Views: 257

Re: Active Forms using multiple cubes

New member here. :? Has anyone created zero-suppressed Active-Form reports sourced from multiple cubes? If so, how? Thanks! 1/ It has to be on a separate row from the existing Active Form. 2/ Create and save a view to serve as a basis for the new Active Form in the cube that you want to base it on ...
by Alan Kirk
Thu Sep 28, 2017 8:29 am
Forum: Cognos TM1
Topic: Old data pops up in a cube even after performing a deletion in a cubeview.
Replies: 4
Views: 216

Re: Old data pops up in a cube even after performing a deletion in a cubeview.

Hi everyone, It would be really helpful if anyone could guide me through this error I'm facing. I create a cubeview , then i perform a VIEWZEROOUT in order to delete the data of that specific view. If I crosscheck with the cube , I can see that the data has been zeroed out. (I delete the cubeview &...
by Alan Kirk
Thu Sep 28, 2017 4:17 am
Forum: Cognos TM1
Topic: Excel VBA API Crashing on TM1ObjectListCountGet
Replies: 6
Views: 270

Re: Excel VBA API Crashing on TM1ObjectListCountGet

I've begun delving into TM1's API and am using the sample code provided by TM1 to get started. So far so good, but the following code continues to crash Excel and I don't know why. The advice that you will get here from pretty much anyone who knows what they are doing (certainly every admin and MVP...
by Alan Kirk
Wed Sep 27, 2017 1:52 am
Forum: Cognos TM1
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 6
Views: 1313

Re: Fix Pack Releases: PA2 / V11 Series

Hi all, I just saw that PA 2.0.3 has been released. Anyone know where to download it from? https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rdm.2.0.0.doc/c_rel_notes_planning_analytics_2_0_3.html Cheers, A They may have published the release notes but that doesn...
by Alan Kirk
Mon Sep 25, 2017 10:55 pm
Forum: Cognos TM1
Topic: Elements of dimension on perspectives
Replies: 2
Views: 196

Re: Elements of dimension on perspectives

Hi all, I would like to list all elements of the dimension of control }Cubes of my model on perspecitves. Does anyone know how to do this? I tried the DBRW, but this case it is different because is not the cube. Sorry, but that last sentence doesn't make any sense. What do you mean by "is not the c...
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: 15
Views: 626

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: 15
Views: 626

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: 15
Views: 626

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: 15
Views: 626

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: 15
Views: 626

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: 184

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 ...