Search found 3530 matches

by Alan Kirk
Thu Oct 25, 2018 10:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element Security Override
Replies: 4
Views: 159

Re: Element Security Override

In my humble the easiest way of doing this is to use a clone of the dimension in the other cubes. There are processes in the Bedrock library which can handle the cloning (including attributes) and which can be scheduled as chores.
by Alan Kirk
Sat Oct 20, 2018 8:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0 - TM1Web reboot
Replies: 5
Views: 234

Re: PA 2.0 - TM1Web reboot

Everything back online! (paw was not harmed during the production of this drama) Primarily because of PA misconception #1. The "classic" TM1 interfaces (Perspectives, Architect... and Web) can be installed in PA2 without going through the ridiculous blood pressure-elevating train wreck of a mess th...
by Alan Kirk
Fri Oct 19, 2018 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0 - TM1Web reboot
Replies: 5
Views: 234

Re: PA 2.0 - TM1Web reboot

Hi, This is probably a dumb question but does anyone know (on PAL) how to restart TM1Web? I've been looking all over documentations and web searches and can't seem to find it anywhere. Thanks The same way that you do it in 10.2.2; the easiest way is through Cognos Configuration via the oh-so-intuit...
by Alan Kirk
Sun Oct 07, 2018 10:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Pax Reports shows #WERT!
Replies: 3
Views: 261

Re: Tm1 Pax Reports shows #WERT!

Hi @Alan Kirk, Thanks for your reply. Actually I have installed Tm1 2.0.5 version recently .The reports which was working in older version of TM1 Perspectives is giving #value? in Tm1 Pax for some reports. Not having had the questionable pleasure of using PAx hands on I cannot say for certain, but ...
by Alan Kirk
Sun Oct 07, 2018 9:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives or TM1 pax
Replies: 1
Views: 109

Re: TM1 Perspectives or TM1 pax

Hi, I want to use either Tm1 perspectives or Tm1 pax in my application. Its depends on the End user which Tm1 client they have chosen. But by default IBM palnning analytics menu is coming in Excel, so how to disable the menu When user has chosen TM1 perspectives . Should I write a code in vb.net to...
by Alan Kirk
Sun Oct 07, 2018 1:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: When is a "hierarchy" not a hierarchy
Replies: 10
Views: 396

Re: When is a "hierarchy" not a hierarchy

Sigh, I'm still trying to get my users to stop saying "subsets" when they mean"consolidations" and vice versa... To that end, I much prefer the term "consolidation" to "rollup". Why? Because for the foreseeable future there will continue to be a little button named "Rollup" which has a distinctly di...
by Alan Kirk
Sat Oct 06, 2018 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Pax Reports shows #WERT!
Replies: 3
Views: 261

Re: Tm1 Pax Reports shows #WERT!

When I open the reports, its show data in some cells and some cell has #WERT? What could be the problem. Connection is alive with Tm1 Server. Any help is much appreciated. Thanks As they say in the classics : #WERT! ist Excels Art des Mitteilens "Irgendetwas stimmt nicht mit der eingegebenen Formel...
by Alan Kirk
Thu Oct 04, 2018 11:12 pm
Forum: Useful code, tips and tricks
Topic: Using Dates And Times In TM1
Replies: 18
Views: 50680

Re: Using Dates And Times In TM1

I'm going to lock this thread. It was intended to be a quick reference about dates and times (hence its presence in "Useful Code, Tips and Tricks", not the main forum). However it seems to have started to attract "any question related to using dates and times in my own environment", which was not th...
by Alan Kirk
Wed Oct 03, 2018 12:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Service Strange Behaviour
Replies: 5
Views: 189

Re: Service Strange Behaviour

I don't really get what you mean. When an instance starts the }chores, }cubes, }dimensions, }processes (& }applicationentries) dimensions are all updated based on the file contents of the data directory. So when you say When the service starts no processes are being loaded in to memory yet the }pro...
by Alan Kirk
Wed Sep 26, 2018 6:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get children count of consolidated element?
Replies: 2
Views: 388

Re: How to get children count of consolidated element?

Ashleigh W wrote:
Wed Sep 26, 2018 6:00 am
Is there a formula to get children count of consolidated element within excel/tm1 perspective function?
ElCompN, assuming that you are talking about children and not descendants.
by Alan Kirk
Tue Sep 25, 2018 1:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Recalculation Speed Issue
Replies: 3
Views: 506

Re: Excel Recalculation Speed Issue

I am having a similar recalculation issue. No you aren't. The thread that this post has been split from was about write-back issues, not calculation times. When I open a DBRW linked file, sometimes the formulas will calculate instantaneously and pull from the cube, but often times, Excel just hangs...
by Alan Kirk
Sat Sep 22, 2018 10:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Java TM1 API : need help
Replies: 7
Views: 543

Re: Java TM1 API : need help

Probably better that I respond before an admin shuts it down ;) . Try looking on the forum first before submitting a question. http://www.tm1forum.com/viewtopic.php?t=1981 You're confusing us with the jackbooted, mother's cellar-dwelling keyboard thugs that pass for moderators on Stack Overflow. He...
by Alan Kirk
Mon Sep 17, 2018 8:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Recalculation Issue (DBRW)
Replies: 3
Views: 241

Re: Excel Recalculation Issue (DBRW)

You may also want to make sure that the users with problems don't have consolidations selected.
by Alan Kirk
Wed Aug 29, 2018 10:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 9
Views: 3327

Re: Fix Pack Releases: PA2 / V11 Series

George Tonkin brought to my attention the fact that I hadn't updated this for the release of PA 2.0.5. I thought I had, but clearly not. Thanks, George.

The Release notes can be found here.

The various headings for the What's New information can be found here.
by Alan Kirk
Tue Aug 21, 2018 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuration Directoy
Replies: 4
Views: 216

Re: Configuration Directoy

Mind to share what you have because I did spend an hour to research here and Google and the results are not helpful. The closest I got was: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_locationofthetm1s.cfgfile_n15038e.html This is not somet...
by Alan Kirk
Mon Aug 20, 2018 4:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot connect to TM1 Admin server from perspectives
Replies: 3
Views: 185

Re: Cannot connect to TM1 Admin server from perspectives

I am unable to connect to TM1 server from perspectives as a non-admin user. It is showing error as cannot connect to Tm1 admin server. i was able to connect to TM1 server when i logged in as admin user. The admin server has nothing at all to do with whether a person is an admin user or not. The adm...
by Alan Kirk
Fri Aug 17, 2018 9:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Text File TI reads is retained in memory...?
Replies: 3
Views: 210

Re: Text File TI reads is retained in memory...?

Your profile shows both 10.2.2.7 and PA2, but you haven't indicated which one this is in. Unless it's PA2 and the server team has done something funky relating to this in PA2 (which I doubt), I don't think that what you suspect is in fact happening. You need to disregard the preview window. It will ...
by Alan Kirk
Fri Aug 03, 2018 10:47 pm
Forum: Bugs
Topic: Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash
Replies: 1
Views: 480

Dimension Open, Excel 365 (2016) 64 bit and 10.2.2 Automation Error Crash

I haven't submitted this at this point because I need to check whether this is just a "my machine" thing or something that applies to everyone. Environment: Windows 10 professional 64 bit. TM1 10.2.2 FP 7 Excel 2016 ( 64 bit ) from Office 365. Note particularly the "64 bit" part which is where I sus...
by Alan Kirk
Sun Jul 08, 2018 4:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem getting PAW to run properly
Replies: 3
Views: 367

Re: Problem getting PAW to run properly

dr.nybble wrote:
Wed Jul 04, 2018 12:44 pm
Try to run the scripts/launch.ps1 script to see if you can access PAW directly against the container IP address.
"Error: No such object: pa-gateway"

But you do get a nice instance of Chrome out of it.

I am so sick of banging my head against Docker that I cannot even speak of it.
by Alan Kirk
Thu Jun 28, 2018 7:18 pm
Forum: Commercial and Events
Topic: TM1 Bytes And Nybbles Series on The TM1 Channel
Replies: 7
Views: 1332

Re: TM1 Bytes And Nybbles Series on The TM1 Channel

I plead ignorance, but what is "Farm Manager?" Empirically? A piece of software whose videos attract ratings 30 to 40 times better than videos on TM1 do. In practice? A clickfest where the numbers are so randomised that they make any sort of meaningful analysis / strategic planning pointless, which...