Search found 2405 matches

by tomok
Wed Apr 18, 2018 8:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Function ViewMDXGet Not Working
Replies: 5
Views: 269

Re: TI Function ViewMDXGet Not Working

The link you pasted is for the the documentation from PA2.0. I've never used that function so I'm pretty sure it's not available in 10.2.2, unless it's in one of the last fix packs.
by tomok
Fri Apr 13, 2018 2:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to generating a text file using Control cube?
Replies: 5
Views: 357

Re: How to generating a text file using Control cube?

Nobody is going to write your code for you. Basically you create a TI process and select Cube as the data source and then you select default as the view. Then in the data tab you use the TI function ASCIIOUTPUT to write what is in the Value field from the view to a text file. It's pretty simple. An ...
by tomok
Thu Apr 12, 2018 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 516

Re: Exporting data from view to file consuming memory

"Garbage" memory isn't really garbage. It can and will be consumed by TM1 as long as the service is up. The only thing it can't be used for is other apps on the box and you shouldn't be housing more then TM1 on one box in the first place.
by tomok
Wed Apr 11, 2018 4:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"
Replies: 6
Views: 209

Re: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"

ok, will this fix also my issue how application is calling tm1web? I don't know what you are talking about. and is it possible to set the same DNS twice for MyNewName.MyCompany.com:9510/tm1web/ and MyNewName.MyCompany.com:9510/pmpsvc/ Setting a DNS entry just serves as a substitute for the IP addre...
by tomok
Wed Apr 11, 2018 3:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: export an Application via Script (TM1 Api)
Replies: 3
Views: 358

Re: export an Application via Script (TM1 Api)

Nitrel wrote:
Wed Apr 11, 2018 1:24 pm
@MariusWirtz

Thanks a lot for this very nice answer
You do realize that all this is going to do is give you the Excel file, with whatever contents were in it when it was published. Correct? If that's all you want why not just grab it from the }Externals folder in the data directory?
by tomok
Wed Apr 11, 2018 3:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"
Replies: 6
Views: 209

Re: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"

but when I open an application, then this looks my tm1web again with the hostname and not with the entry of a hosts or a DNS. Or did I misunderstand you? Chris No, it will not. If you have a DNS entry like MyNewName.MyCompany.com, instead of TM1ServerName and open TM1Web with MyNewName.MyCompany.co...
by tomok
Wed Apr 11, 2018 2:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"
Replies: 6
Views: 209

Re: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"

Why not just create a DNS entry for your server and use that instead in all your links? That should hide the machine name as long as your DNS entry has the name you want to use. I see this all the time.
by tomok
Tue Apr 10, 2018 4:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise
Replies: 15
Views: 338

Re: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise

Mark RMBC wrote:
Tue Apr 10, 2018 1:47 pm
it's just that the information you were giving us was "fake news"
This seems slightly harsh given fake news is the deliberate attempt to fool the gullible/stupid.
You do realize it was humor, right?
by tomok
Tue Apr 10, 2018 1:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise
Replies: 15
Views: 338

Re: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise

What was I doing wrong? You didn't do anything "wrong", it's just that the information you were giving us was "fake news". Sorry, couldn't help it. Those DIMENSIONSORT functions have absolutely NOTHING to do with how children roll up to a parent. All they control is the order of how the elements ap...
by tomok
Tue Apr 10, 2018 11:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise
Replies: 15
Views: 338

Re: DIMENSIONELEMENTCOMPONENTADD - Not working as expected - Please advise

It's in the }DimensionProperties cube but you can also set it via TI. Please consult the TI functions help.
by tomok
Mon Apr 09, 2018 4:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: BatchUpdateStart and BatchUpdateFinishWait in master process
Replies: 12
Views: 2057

Re: BatchUpdateStart and BatchUpdateFinishWait in master process

Correct me if I'm wrong but it could be still useful in a TI that loads data within a cube where the source view has lot of rule calc'd cells...at least as long as the new feature of invalidating only a slice of a cube's cache is under development Yes batchupdate could be useful in that scenario as...
by tomok
Fri Apr 06, 2018 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running PA objects in 10.2
Replies: 4
Views: 257

Re: Running PA objects in 10.2

I think as long as you have not used any of the new features of PA then the answer would be yes. Have you tried? I would do that before I would take anyone's word for it.
by tomok
Thu Apr 05, 2018 12:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: With which version of Java is TM1 10.2 web developed?
Replies: 7
Views: 1148

Re: With which version of Java is TM1 10.2 web developed?

Interesting, I've just tried out to test it the same way you've done, me neither didn't find JRE folder, but in my case running version prompt was successful. That's the very thing I can't understand with Java at all: everything works fine by the book, but when you actually trying to do that, it ap...
by tomok
Wed Apr 04, 2018 4:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add new dimension to existing cube
Replies: 5
Views: 344

Re: Add new dimension to existing cube

I forgot to mention reports. None of them are going to work without modifying to account for the new dimension.
by tomok
Wed Apr 04, 2018 3:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add new dimension to existing cube
Replies: 5
Views: 344

Re: Add new dimension to existing cube

You can't add a new dimension to an existing cube. Performance Modeler can do it but it is an afterthought type thing and I would never trust that it can do it right. If the cube is linked to other cubes via rules and processes then I can almost guarantee that PM can not do it completely. You are go...
by tomok
Tue Mar 27, 2018 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting TM1 data in multiple sheet of workbook
Replies: 2
Views: 362

Re: Exporting TM1 data in multiple sheet of workbook

I think before anyone can give you an answer we need to know what exactly it is you are trying to accomplish. If you are trying to export from a cube, like just dump cube contents into a tab in Excel you are out of luck for the most part. Using ODBC inside a TI process to export from a cube to an Ex...
by tomok
Mon Mar 26, 2018 8:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension is not available in TM1Web
Replies: 2
Views: 432

Re: Dimension is not available in TM1Web

so it looks like the issue only applies to the existing active forms that previously pointed to an old cube that did not have this dimension. What steps did you perform to update the active form to use the newly created cube with an extra dimension? If the new dimension is on the rows did you creat...
by tomok
Mon Mar 26, 2018 3:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Where to learn the business concepts of the budet and planning
Replies: 4
Views: 476

Re: Where to learn the business concepts of the budet and planning

Sorry, but there are no shortcuts for learning about planning and forecasting from a business perspective. A college degree in Accounting wouldn't hurt but there is no substitute for experience. Have you tried searching for online learning around planning and forecasting?
by tomok
Mon Mar 26, 2018 1:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Do you want to update dimension worksheet?
Replies: 1
Views: 248

Do you want to update dimension worksheet?

Does anyone know where TM1 stores the information that tells it when an XDI worksheet exists? Does it query the contents of your Database Directory in Perspectives, or is it somewhere else? I've always been curious, just too lazy to pursue. I looked in all the system cubes I could think of and could...
by tomok
Sun Mar 25, 2018 12:23 pm
Forum: Useful code, tips and tricks
Topic: Using old clients with new planning analytics server
Replies: 10
Views: 971

Re: Using old clients with new planning analytics server

We have a PAL 2.0.4 server and our users are using a multitude of Perspective/Architect versions, going back as far as version 9.5.1. Here are the things that need to be done: 1) set the TM1 Admin server to support pre-TLS v1.2 clients via Cognos Configuration 2) add in tm1s.cfg: SupportPreTLSv12Cl...