Search found 3484 matches

by Alan Kirk
Fri Jan 12, 2018 8:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running a new blank unsaved TI... it executes a different TI
Replies: 9
Views: 279

Re: Running a new blank unsaved TI... it executes a different TI

In addition to George's question, where are you creating the process? Perspectives / Architect, or Performance Muddler?
by Alan Kirk
Thu Jan 11, 2018 11:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 343

Re: Poll : Which version of Excel is used in your business

I addressed this on my YouTube channel last week. I'd love to watch your shows/webisodes/whatever they're called. Not just to learn more about this topic but also to see if you really do look just like Mark Harmon. FaceToCamera2.jpg I did briefly consider doing a data management riff on Roberto Tar...
by Alan Kirk
Tue Jan 09, 2018 8:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 343

Re: Poll : Which version of Excel is used in your business

jim wood wrote:
Tue Jan 09, 2018 8:45 pm
Just to through a spanner in the works I use Office 2011 on my mac :oops:
Yes, but that's because the gods hate you and have decided to give you an early taste of Hell.

(So how well does Perspectives work on that? ;) )
by Alan Kirk
Tue Jan 09, 2018 8:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 343

Re: Poll : Which version of Excel is used in your business

I suppose it had to happen eventually since 2010 is now 8 years in the past, though it's still arguably the most stable and predictable version out there. 2013 AND ITS ALL CAPS, ALL YELLING TABS was gone before anyone really knew that it was here; I never did use it operationally and I doubt that mu...
by Alan Kirk
Thu Dec 21, 2017 12:33 am
Forum: Useful code, tips and tricks
Topic: Indirect variables in TI.
Replies: 12
Views: 6729

Re: Indirect variables in TI.

This works. I really don't understand the Expand statement, but I followed the example and it did exactly what I wanted. I turned two pages of code into about 10 rows. At the next TM1 Hall of Fame Induction Ceremony this guy should be featured. It's Steve, he was inducted years ago. Expand really i...
by Alan Kirk
Fri Dec 15, 2017 6:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Cube/Dimension security etc cube A to new cube B
Replies: 1
Views: 198

Re: Copy Cube/Dimension security etc cube A to new cube B

Hello every body. Enyone, can a help me, How can I duplicate a Cube 'A' to new Cube 'B', step by step. Thanks a lot cmardi The easiest way is: (a) Download the Bedrock TM1 library; (b) Put the Bedrock processes in your data directory and restart your server; (c) Write a process that executes the Be...
by Alan Kirk
Sat Dec 09, 2017 3:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: converting to date for comparing dates
Replies: 3
Views: 264

Re: converting to date for comparing dates

i know scan will help to get the '/ 'position, but is there a way to get the first and second slash position too. Yes i know we can come up with logic, but you dont think its too much calculation , if length is 10 then the date otherwise , check if length is 8 or length is 9 . I do. Which is why I ...
by Alan Kirk
Tue Nov 21, 2017 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cells not calculating unless edited
Replies: 7
Views: 385

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Installing 32bit TM1 Perspectives on 64 bit windows 7
Replies: 3
Views: 323

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 15
Views: 960

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Date Display Using Attribute Format
Replies: 7
Views: 467

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Date Display Using Attribute Format
Replies: 7
Views: 467

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Date Display Using Attribute Format
Replies: 7
Views: 467

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset create by element type(N,S orC)
Replies: 2
Views: 227

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI cutting off dimension elements
Replies: 4
Views: 260

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel VBA API Crashing on TM1ObjectListCountGet
Replies: 6
Views: 360

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Forms using multiple cubes
Replies: 5
Views: 322

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old data pops up in a cube even after performing a deletion in a cubeview.
Replies: 4
Views: 281

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel VBA API Crashing on TM1ObjectListCountGet
Replies: 6
Views: 360

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 7
Views: 1688

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