Search found 111 matches

by Bakkone
Fri May 22, 2020 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 11
Views: 1214

Re: @= in active sheet formula

I recommend everyone to turn off the automatic formatting of URLs and email in their excel proofing settings. This is just one more reason to why.
by Bakkone
Thu Feb 20, 2020 7:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web White Blank Page
Replies: 10
Views: 1854

Re: TM1 Web White Blank Page

Dont know if it helps. But I couldn't find an engine.js in the 2.0.4 installation im currently at.
by Bakkone
Fri Feb 14, 2020 10:18 am
Forum: Useful code, tips and tricks
Topic: Going to the IBM Cloud
Replies: 4
Views: 849

Re: Going to the IBM Cloud

I want to recommend everyone to order 1-2 instances called temp, test or whatever and have turn them off as soon as you get access to the system. Its just very convenient to have them around. Also note that the cloud team will upgrade the Workspace part of your environment at their own discretion. I...
by Bakkone
Mon Dec 09, 2019 5:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving Data using Alternate Hierarchy
Replies: 6
Views: 2840

Re: Retrieving Data using Alternate Hierarchy

Hiearchies in Websheets has been in a few presentations lately. Don't know if it means its close... but heres hoping for H1 2020.
by Bakkone
Mon Dec 09, 2019 5:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 779

Re: Temporary views surviving their TI process

Any chance you could share some code?
by Bakkone
Mon Dec 02, 2019 6:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Devops in PA/TM1
Replies: 9
Views: 1857

Re: Devops in PA/TM1

Devops is not about tools. Devops is about processes.

Part of my development process is looking in log files. I use notepad++ for that.
by Bakkone
Mon Dec 02, 2019 5:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics Installation
Replies: 2
Views: 888

Re: Cognos Analytics Installation

My suggestion is that you use the included DB2 license.
by Bakkone
Tue Nov 26, 2019 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Devops in PA/TM1
Replies: 9
Views: 1857

Re: Devops in PA/TM1

Notepad++ is great... I also write my TI-processes in Architect.
by Bakkone
Tue Nov 26, 2019 11:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Licensing for PAW
Replies: 3
Views: 437

Re: Licensing for PAW

With that said... we also bought the PAW add-ons for every user. OUR license agreement was that only the data server was PVU based. So we put PAW on a separate server. We also put Cognos Analytics, TM1web etc on a separate server. This way all the PVU performance could go to the data-server. And we ...
by Bakkone
Tue Aug 27, 2019 7:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's coming up in the TM1 Server?
Replies: 11
Views: 13567

Re: What's coming up in the TM1 Server?

lotsaram wrote:
Mon Aug 26, 2019 9:04 pm

Then I guess you would be mistaken because I can assure you that this is not happening, and moreover is not something that is likelly to either.
Very quick to deny this are we not... ;)

Thanks for your thoughts and insights.
by Bakkone
Mon Aug 26, 2019 12:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's coming up in the TM1 Server?
Replies: 11
Views: 13567

Re: What's coming up in the TM1 Server?

Sounds interesting. Personally I think they should find something that actually CAN replace the TI part. Otherwise we will have three different "languages". But I always tend to think about things like Canvas and all these other things beeing developed on top of the api. As much as I love it. I alwa...
by Bakkone
Mon Aug 26, 2019 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make system appear "offline" - TM1Web login unavailable
Replies: 14
Views: 13971

Re: How to make system appear "offline" - TM1Web login unavailable

If you dont need TM1Web/Applicaiton Web to check your admin changes. It would be a possibility to just stop those services. Another solution I have used once was to close the firewall on the web-server so noone could access it. This way I could use the system since I was on the server. But noone els...
by Bakkone
Fri Aug 23, 2019 3:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's coming up in the TM1 Server?
Replies: 11
Views: 13567

Re: What's coming up in the TM1 Server?

Thx for sharing!

I'm very curious to hear more about that "scripting language" in the coming years. In a way I hope that its not a new language but just regular javascript or python or something.
by Bakkone
Tue Aug 20, 2019 5:39 pm
Forum: Commercial and Events
Topic: TM1 coding extension for VSCode
Replies: 13
Views: 23612

Re: TM1 coding extension for VSCode

Live editing should be doable via rest. But Im afraid I dont have the skills to make it happen.

But as far as I understood it thats how the TM1 add-in for sublime does it.
by Bakkone
Wed Aug 07, 2019 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 10
Views: 2947

Re: Dimension Order in an MDX cube view as datasource

So the MDX Views are not the magic I was hoping for to force my TI process to loop through the source in a way I want it to then. Thanks for the clarification.
by Bakkone
Wed Aug 07, 2019 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 10
Views: 2947

Re: Dimension Order in an MDX cube view as datasource

lotsaram wrote:
Wed Aug 07, 2019 1:23 pm
So I guess you (didn't) read the contents of the thread then?
I wish I could say I didn't. Maybe I read too much into it and that it doesn't matter at all, but that you want a predictable order of your variables.
by Bakkone
Wed Aug 07, 2019 9:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 10
Views: 2947

Re: Dimension Order in an MDX cube view as datasource

Hi, I haven't started with the MDX views yet as my MDX-skils are pretty crappy (Any tips on resources?). But does an MDX cube view differ in a "normal" cube view when used as a data source when it comes to dimension orders? Exporting using a "normal" cube view uses the cube dimension order. Is this ...
by Bakkone
Sun Jul 21, 2019 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why IBM should sell off TM1 by James Wakefield
Replies: 4
Views: 1581

Re: Why IBM should sell off TM1 by James Wakefield

Interesting read. But it really needs to be read as a text written by someone that worked with TM1, and now work with one of its main competitors, Anaplan. So as much as it is interesting, its aim is to deem TM1/PA as an inferior system. Now I haven't worked with Anaplan for a few years. But as far ...
by Bakkone
Mon Jul 08, 2019 7:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to configure TM1WEB to access from other network
Replies: 5
Views: 1593

Re: How to configure TM1WEB to access from other network

Did you check the firewall? Both the windows one and there is probably some azure security stuff as well.
by Bakkone
Wed Jul 03, 2019 8:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Day of Week in TI
Replies: 13
Views: 5502

Re: Day of Week in TI

And this one for more explanation on the UseExcelSerialDate parameter: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_useexcelserialdate.html It never even occured to me to derive the system used by checking the output. Now you made me feel li...