Search found 253 matches

by Paul Segal
Mon Jul 04, 2016 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help with SUBDEFINE. Could not find anything that was solved. Please help.
Replies: 5
Views: 977

Re: Need help with SUBDEFINE. Could not find anything that was solved. Please help.

Try replacing "A1:A10" with

Code: Select all

Worksheets("Worksheetname").Range("A1:A10")
The whole thing should read

Code: Select all

 x = Application.Run("SUBDEFINE", "dev1.dev.boa.com:HeadCount", "testVBss", Worksheets("Worksheetname".Range("A1:10"))
Obviously, replace Worksheetname with the name of your worksheet.
by Paul Segal
Mon Mar 14, 2016 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.3 - IBM Planning Analytics
Replies: 40
Views: 17668

Re: TM1 10.3 - IBM Planning Analytics

I heard Q3 is the current target for on premise release. Of course, that might slip ;)
by Paul Segal
Mon Mar 14, 2016 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Send encrypted email out of TI
Replies: 4
Views: 928

Re: Send encrypted email out of TI

One solution would be to write the email to text on the TM1 Server and have some VBA in an Outlook instance which looped round any text files in the directory and used the text to send the email. The advantage here is that you are just using VBA and Outlook's built-in encryption. The disadvantage is...
by Paul Segal
Tue Nov 24, 2015 9:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Authentication/security Tm1 applications W/O BI
Replies: 19
Views: 4656

Re: Authentication/security Tm1 applications W/O BI

Hi David,

All of BI, or just the admin bit as lotsaram suggests? I mean, just to be clear ;)
by Paul Segal
Tue Nov 03, 2015 9:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insight 2015
Replies: 12
Views: 3099

Re: Insight 2015

Convert to values is good... but bulk paste would be better.
According to what I saw at the London Cubewise conference I think they have the bulk paste sorted as well.
by Paul Segal
Mon Nov 02, 2015 4:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User reporting Unable to open the saved private views.
Replies: 13
Views: 1454

Re: User reporting Unable to open the saved private views.

So, what happens when you create that view, make it public, and the user tries to open the public version?
by Paul Segal
Mon Nov 02, 2015 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User reporting Unable to open the saved private views.
Replies: 13
Views: 1454

Re: User reporting Unable to open the saved private views.

As Wim said. it doesn't matter how much memory the user has on his PC, it's the memory on the server (where the calc is being done) that matters. To echo Wim: either change the MaximumViewSize or educate the user not to attempt to pull down such a large view or figure out why that view is causing pr...
by Paul Segal
Tue Oct 20, 2015 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Renaming a TM1 Service
Replies: 3
Views: 807

Re: Renaming a TM1 Service

I think you're making life too complicated for yourself (and, in the future, others). It's not like it's overly difficult or time consuming to delete the Planning Service service and put a new one up.
by Paul Segal
Tue Oct 13, 2015 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI that finds parent of parent of parent of parent and moves it
Replies: 5
Views: 785

Re: TI that finds parent of parent of parent of parent and moves it

Well, Bedrock is a) free and would b) give you some clues as to how to do what you want to do, even if you don't use the Bedrock code.
by Paul Segal
Thu Oct 08, 2015 8:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Data Server services Down suddenly - Dont know why
Replies: 2
Views: 677

Re: TM1 Data Server services Down suddenly - Dont know why

What does the end of your tm1server.log file say? Is there sufficient disk space for the save? Have you checked the Windows event logs?
by Paul Segal
Tue Oct 06, 2015 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best practice for versioning
Replies: 13
Views: 4512

Re: Best practice for versioning

Interesting, Kamil. Could you expand? What would you do with, say, a dimension that you can't create from another system?
by Paul Segal
Tue Oct 06, 2015 9:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deploying Updated TI files
Replies: 2
Views: 557

Re: Deploying Updated TI files

If you amend or write a new TI process on your dev server, and then copy it to your production server, then you need to restart the production server for it to recognise the amended or new TI process. If there weren't many changes, it is in theory possible to cut and paste the amended process from d...
by Paul Segal
Fri Oct 02, 2015 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly Poll 201510_201511 - Do you plan to use CAFE as a replacement or supplement for Client and Why?
Replies: 7
Views: 2290

Re: Monthly Poll 201510 - Do you plan to use CAFE as a replacement or supplement for Client and Why?

I agree with George, but from a slightly different angle. I can see running some Clients, but I'd love for CAFE to have the same (or mostly similar) functionality as Perspectives. I could then dump the Citrix overhead/complication and the headache that can be with IT. I guess what I want (and have a...
by Paul Segal
Thu Oct 01, 2015 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules to pull data from one cube to another when dimensions do not match
Replies: 5
Views: 1133

Re: Rules to pull data from one cube to another when dimensions do not match

If you already have a TI working that identifies which sales person is responsible for which client, then (assuming there is a one to many relationship sales person->clients) would it not be worth considering making the whole thing a TI? Then you have each client as an element of the relevant sales ...
by Paul Segal
Wed Sep 30, 2015 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pulse for TM1 webclient
Replies: 5
Views: 1220

Re: Pulse for TM1 webclient

Have you tried a full domain name = e.g. servername.yourdomain.com:8099/? Otherwise, are you not in maintenance with Cubewise, as they should be able to troubleshoot?
by Paul Segal
Tue Sep 29, 2015 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Architect - 2 different servers, same name of tm1 instances
Replies: 1
Views: 390

Re: Architect - 2 different servers, same name of tm1 instances

Hi, Architect will pick up the instance from the first named admin server and use that if two servers have the same name, so A and B will be from the dev server, C from the prod server, and then D from the dev server again. I don't believe you can do what you're trying to do, as this would result in...
by Paul Segal
Tue Sep 29, 2015 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: cool TI Editor - where to buy?
Replies: 5
Views: 1540

Re: cool TI Editor - where to buy?

Hi Robert,

I don't believe Vizier is on sale any more, but the company that sold it, and have other products (like Pulse) that might be helpful is Cubewise
by Paul Segal
Wed Aug 19, 2015 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to connect TM1 Perspective from client to the Server
Replies: 8
Views: 2069

Re: How to connect TM1 Perspective from client to the Server

OK, so the normal way to do this is to install TM1 Perspectives as an add-in on each client (user) PC, which is then loaded in Excel, rather than access the add-in from a server. Is there a particular reason you want to load the add-in from the server?
by Paul Segal
Wed Aug 19, 2015 7:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to connect TM1 Perspective from client to the Server
Replies: 8
Views: 2069

Re: How to connect TM1 Perspective from client to the Server

Are your users all connecting to the Server via RDP or something similar?
by Paul Segal
Tue Aug 11, 2015 8:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Instances Crash
Replies: 7
Views: 1821

Re: TM1 Instances Crash

Also, is there a pagefile set up on the server? If so, it may well report this as part of the 1TB RAM, and I've seen servers crash when memory usage gets so high as to start paging.