Search found 102 matches

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

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

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

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

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

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

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

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

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

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

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

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...
by Bakkone
Tue Jul 02, 2019 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service holding open ODBC?
Replies: 7
Views: 483

Re: TM1 service holding open ODBC?

Try to add some validations and other checks that also triggers a close. Otherwise you risk having the connection stay open because of an error.

Or if you know that the DBAs are running backups at night. Add a process with ODBC close in your own nightly backup routine.
by Bakkone
Tue Jul 02, 2019 3:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Day of Week in TI
Replies: 13
Views: 3798

Re: Day of Week in TI

Are you an admin person of that TM1 model, or what is your role with respect to TM1 ? Yes I'm an admin/developer. I was working on some sort of "ultimate period/time dimension creator". But to calculate some things I needed to know where the tm1s.cfg file was located. Since I need to know if the mo...
by Bakkone
Tue Jul 02, 2019 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Day of Week in TI
Replies: 13
Views: 3798

Re: Day of Week in TI

Right at the moment I'm testing out issues relating to the new Excel Dates server config parameter and plan to whack the whole thing with a complete overhaul. I got stuck on trying to figure out the location of the tm1s.cfg. Also how general thing should be to work with both windows and linux machi...
by Bakkone
Mon Jul 01, 2019 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service holding open ODBC?
Replies: 7
Views: 483

Re: TM1 service holding open ODBC?

Then you have to add one.
by Bakkone
Tue Jun 25, 2019 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow Login in Architect
Replies: 21
Views: 1111

Re: Slow Login in Architect

1.Yes, UseSSL=T but CAM is not using SSL, means it is HTTP rather than HTTPS 2.Yes 3.Yes but seems not to be relevant 4.Good point, I will try next time. Thanks. 1, Are you using custom certificates? 2a, Are you using IIS as a webserver for your CAM-installation? 2b, Is the database server for the ...
by Bakkone
Tue Jun 25, 2019 2:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading metdata changes via MDS to TM1
Replies: 4
Views: 916

Re: Loading metdata changes via MDS to TM1

Yes, if its Microsoft MDS you are talking about its all in the manual: https://docs.microsoft.com/en-us/sql/master-data-services/master-data-services-overview-mds?view=sql-server-2017 Which method to use will depend totally upon your architecture in your DW. You can probably find a guide on some SQL...
by Bakkone
Mon Jun 24, 2019 5:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow Login in Architect
Replies: 21
Views: 1111

Re: Slow Login in Architect

Do you use SSL? If so, between which components?

Is BI and TM1 installed on the same server? Is TM1 installed on one or multiple servers?

Do you have any anti-virus on the servers?

Would it be possible for you to test with native login once to see if you still if its still slow?
by Bakkone
Tue May 21, 2019 9:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Docker & McAfee on Windows Server
Replies: 14
Views: 678

Re: Docker & McAfee on Windows Server

Couldn't you just run the CE edition? Do you really need the EE edition?

Also new editions of Windows Server will actually have a little Linux core in them. Its going to be interesting to see how this affects deployment. I want to think it will allow for a best of both worlds.
by Bakkone
Fri Apr 26, 2019 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 3016

Re: RunProcess and threads

Thx for the info. Turns out I wasnt on 06 at the server I was thinking about. Guess a few more months went by faster than I thought.