Search found 2941 matches

by lotsaram
Tue May 22, 2018 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error on view creation
Replies: 7
Views: 111

Re: Error on view creation

I think there's something you're not telling us. Because your explanations do not really sound plausible.
by lotsaram
Tue May 22, 2018 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA: Multiple web instance
Replies: 1
Views: 29

Re: PA: Multiple web instance

Good question. Especially when it comes to load balancing or failover of larger applications. No doubt it is "easy" if you happen to be a websphere expert. But then most of us aren't!
by lotsaram
Fri May 18, 2018 7:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transfer data within cubes for a particular month and future set of months in a year
Replies: 12
Views: 515

Re: Transfer data within cubes for a particular month and future set of months in a year

Why would you be using Bedrock.Cube.Data.ZeroOut ? As far as I know that process hasn't been in the bedrock library for many many years and is superseded by Bedrock.Cube.Data.Clear which you can get here. But still the principle holds true if you feed a bedrock process bad parameters (like a non-exi...
by lotsaram
Fri May 18, 2018 5:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder for C level calculation
Replies: 2
Views: 214

Re: Feeder for C level calculation

And if you were to write a feeder then what exactly do you think you would feed or need to feed? Feeders are an exclusively LEAF LEVEL concept. They exist for one purpose only: to enable consolidation of rule calculated leaf cells. Where no consolidation is required ergo no feeding is required. C l...
by lotsaram
Wed May 16, 2018 6:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 171

Re: Security Access Flag not being Deployed

Whether a process runs with security access for non-admin users is stored in the TI process .pro file as property 1217

http://www.tm1forum.com/viewtopic.php?t=11770
by lotsaram
Thu May 03, 2018 6:17 am
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 19832

Re: Copying Data from 1 Element to Another via TI

I have a question, If I select a data source manually from a cube then I want to fetch data from another cube Is this okay? Yes you can and this is no problem as long as the other cubes being set dynamically at runtinme have the same or less dimensions than the cube which was used for the data sour...
by lotsaram
Thu May 03, 2018 6:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation help
Replies: 17
Views: 1664

Re: PAW installation help

I am having problems getting it to work. I have WIndows 2012 Server with 8GB RAM. I have cut the size of the VM down to 1012MB, 1 CPU and 2000 MB Disk. I found that you need to do this in two places Start.bat and \scripts\WinStart.sh. I am not sure if that is too much of a reduction but I don't eve...
by lotsaram
Thu May 03, 2018 6:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1
Replies: 14
Views: 432

Re: tm1

venureddy wrote:
Thu May 03, 2018 4:38 am
How can i become strong in Scripting part
Same as anything. Practice.
by lotsaram
Tue May 01, 2018 8:31 pm
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 19832

Re: Copying Data from 1 Element to Another via TI

Go back and RTM. Epilog code is executed once and once only after the data source connection is closed. Any CellPutN here would update only one cell. For the data source you of course want to select a view of the source cube that you will be processing. The manually selected view serves one purpose ...
by lotsaram
Tue May 01, 2018 1:03 pm
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 19832

Re: Copying Data from 1 Element to Another via TI

You are building a view sure. But I see no DatasourceType=‘VIEW’ or DatasourceNameForServer=sCube in your Prolog code. If you have set up the variables using a text data source then as Alan already suggested the NValue variable will be undefined. Code only does what you tell it. Also when using a vi...
by lotsaram
Mon Apr 30, 2018 4:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add attributes to control dimension
Replies: 9
Views: 369

Re: Add attributes to control dimension

Thanks Wim Gielis. I want to create a pick list on a control dimension from values in a dimension. Sorry. I should have been clear. I tried things like below and both don't seem to work. dimension:dimension_name subset:dimension_name:subset_name Thanks, Paul. There is a big difference between creat...
by lotsaram
Tue Apr 24, 2018 5:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 6
Views: 586

Re: Server Locked after save data process and save data is running for a long time .

Your issue is real. On PA instances I have also seen a lot of sf_DeleteFile and sf_SafeDelete errors, always to do with sub and/or vue files. It doesn't always occur on SaveData, sometimes it happens during TI process execution where a process that should execute in less than a second can drag on fo...
by lotsaram
Fri Apr 20, 2018 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Return codes and error messages
Replies: 2
Views: 209

Re: Return codes and error messages

The error codes which that documentation is referring to are the error codes for tm1runti.exe which should not be confused with the exit code for the TurboIntegrator process itself ("process return codes"). If you want to validate the internal integer value of the process return codes this is quite ...
by lotsaram
Fri Apr 13, 2018 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to generating a text file using Control cube?
Replies: 6
Views: 508

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

Hi All, Can anyone help me is writing a TI code which generates a text file using }ClientGroups Control cube as a source. Basically we are looking to generate a text file that should contain the usernames(40 character length) and roles(40 character length) to provide for the Audit team. Thanks You ...
by lotsaram
Thu Apr 12, 2018 5:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 19
Views: 904

Re: Exporting data from view to file consuming memory

Hi guys, is there any difference when exporting data to files and importing it back to the target cube and moving data between cubes using CellPutN in regards of memory consumption? I'm exporting quite a huge amount of data to files but it consumes a lot of RAM and after the export is finished it''...
by lotsaram
Mon Apr 09, 2018 6:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: BatchUpdateStart and BatchUpdateFinishWait in master process
Replies: 12
Views: 2193

Re: BatchUpdateStart and BatchUpdateFinishWait in master process

tomok wrote:
Mon Apr 09, 2018 4:23 pm
Interesting. Does that mean the the function CellIncrementN would not work in a BatchUpdate process?
Been a long while since I used it but pretty sure the answer is yes, exactly this problem.
by lotsaram
Mon Apr 09, 2018 3:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: BatchUpdateStart and BatchUpdateFinishWait in master process
Replies: 12
Views: 2193

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 lotsaram
Mon Apr 09, 2018 6:52 am
Forum: Commercial and Events
Topic: TM1 Bytes And Nybbles Series on The TM1 Channel
Replies: 4
Views: 491

Re: TM1 Bytes And Nybbles Series on The TM1 Channel

You aren't going to reconsider having a separate channel for the TM1 content verusus your gaming reviews?
by lotsaram
Fri Apr 06, 2018 2:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running PA objects in 10.2
Replies: 4
Views: 316

Re: Running PA objects in 10.2

Answer is no unless it is the latest version of 10.2.2 FP7 plus fix packs. There was a recent IF to 10.2.2 FP7 which correlated to a IF of PA 2.0.2 or 2.0.3 which introduced a change to format of cube files. If you try and load a .cub file saved in a version since this update in an older version you...
by lotsaram
Thu Apr 05, 2018 8:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it possible to pass parameters to a powershell (.ps1) file?
Replies: 14
Views: 981

Re: Is it possible to pass parameters to a powershell (.ps1) file?

@Wim Gielis I didn't read it anywhere, tried many trial and errors. Moreover executecommand doesn't accept parameters. If you have any other thoughts or ideas to it. Please share it here, I would be glad to hear it. :) I don't really know what I am reading here, you have me scratching my head to be...