Search found 2962 matches

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

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...
by lotsaram
Tue Apr 03, 2018 8:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Get all SQL from TI processes
Replies: 4
Views: 521

Re: Get all SQL from TI processes

It shouldn't be too difficult to do via offline script as the .pro files are plain text. The properties you need to inspect are 562: DatasourceType 566: DatasourceQuery It is important to include a filter to only include processes where datasource type = "ODBC". (Due to the way TM1 handles memory an...
by lotsaram
Thu Mar 29, 2018 3:58 pm
Forum: Enhancements
Topic: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube
Replies: 6
Views: 1204

Re: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube

Hey Pete,
quid pro quo I have voted for your RFE. My favorite RFE is this one for temporary objects to be accessible by other TI processes that are part of the same transaction as the TI that creates them and not exclusively by the creating TI.
by lotsaram
Mon Mar 26, 2018 1:06 pm
Forum: Enhancements
Topic: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube
Replies: 6
Views: 1204

Re: RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube

Although this would be a great feature I'm certainly also sympathetic to IBM's position as to put it bluntly making data copy much easier will attract more fools but making such a process foolproof will be impossible. For example what should happen if the destination version is either wholly or part...
by lotsaram
Tue Mar 20, 2018 4:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: BatchUpdateStart and BatchUpdateFinishWait in master process
Replies: 12
Views: 2446

Re: BatchUpdateStart and BatchUpdateFinishWait in master process

You say you need BatchUpdate but do you really?

BatchUpdate more or less went the way of the dinosaurs when Parallel Interaction was introduced. So why do you think you need it?
by lotsaram
Sun Mar 18, 2018 7:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to add validation error message for users?
Replies: 3
Views: 446

Re: How to add validation error message for users?

Hello, I have 2 dimensions which are used in different cubes to build model, let's name them A & B. The elements of these dimensions are selected through TM1 web when users are doing planning. I have to implement a logic in such a way that while selecting the elements, one element of dimension B ca...
by lotsaram
Thu Mar 08, 2018 12:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics - number of elements in a dimension
Replies: 4
Views: 677

Re: Planning Analytics - number of elements in a dimension

Hey Wim, Just reading quickly your code it seems to be doing more than it needs to be doing if you just want to count the element in each hierarchy. You can get a count of element in any hierarchy just with regular old DimSiz function DimSiz('dim':'hierarchy'). In PAL if alternate hierarchies are de...
by lotsaram
Thu Mar 01, 2018 1:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 1409

Re: Parallel run vs. ICX

All object names need to be unique. For parallel processing from/to the same cube it is important that all views and all subsets be uniquely named. Even if all views are using the same subset for products, measures etc? It's not the same cube, I'm just exporting the data from the cube to the text f...
by lotsaram
Thu Mar 01, 2018 6:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 1409

Re: Parallel run vs. ICX

All object names need to be unique. For parallel processing from/to the same cube it is important that all views and all subsets be uniquely named.
by lotsaram
Wed Feb 14, 2018 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI and number of cores/threads
Replies: 9
Views: 1094

Re: TM1RunTI and number of cores/threads

tm1runti is quite picky about text vs numeric parameter values. In my experience it quite likes or requires the process name and all string parameters to be in double quotes. Depending on how picky it is feeling it might also like the user and pwd in quotes as well. If using CAM it can also be picky...
by lotsaram
Wed Feb 14, 2018 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1server.log not getting updated
Replies: 3
Views: 365

Re: tm1server.log not getting updated

the technote is a little short on detail but this is your issue
http://www-01.ibm.com/support/docview.w ... wg22002669
by lotsaram
Wed Feb 14, 2018 7:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Subtotals at the top of Active Form
Replies: 12
Views: 948

Re: Excel Subtotals at the top of Active Form

If you have TI at your disposal and can pass in parameters to identify the location of the cell with the MDX string then obviously the answer is yes. I guess you want this to work without TI?
by lotsaram
Wed Feb 14, 2018 7:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI and number of cores/threads
Replies: 9
Views: 1094

Re: TM1RunTI and number of cores/threads

You should have 2 text files a bat file calling hustle.exe with 2 params being the location of the file containing the runti execution list and how many threads to use a txt file specifying on each line the location of tm1runti.exe the process to run and any necessary parameters If you can post an e...
by lotsaram
Wed Feb 07, 2018 9:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI and number of cores/threads
Replies: 9
Views: 1094

Re: TM1RunTI and number of cores/threads

try https://github.com/cubewise-code/hustle it is a free utility which manages command line queues. All you need to do is tell the program how many threads to run at once and it will do the rest.
by lotsaram
Wed Feb 07, 2018 3:34 pm
Forum: Bugs
Topic: HierarchySubset functions don't work
Replies: 2
Views: 1018

Re: HierarchySubset functions don't work

Steve Rowe wrote:
Wed Feb 07, 2018 12:02 pm
Did you try the old version of the function but using dimname:hiername for the dimension argument?
Yes. But this isn't accepted and throws a dimension doesn't exist error.
by lotsaram
Tue Feb 06, 2018 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Subtotals at the top of Active Form
Replies: 12
Views: 948

Re: Excel Subtotals at the top of Active Form

Try this alternative then: =SUM(INDEX(TM1RPTDATARNG1,,COLUMN())) Assuming the formula will be in the column it is summing, otherwise change accordingly. Damn it, it still works perfect in Excel but not in TM1Web, it includes only the First Row of ACtive Form in the Totals, so I guess eventhough we ...
by lotsaram
Tue Feb 06, 2018 12:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot right click to create dimension, cube, ..etc
Replies: 6
Views: 477

Re: Cannot right click to create dimension, cube, ..etc

This is a peculiar quirk of our much beloved or unbeloved development interface. For reasons be-known only to the original UI developer the "Create New Cube" option is universally available when right-clicking ANY cube. However, for all other object types the create new contect menu option is only a...
by lotsaram
Tue Feb 06, 2018 6:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 ZeroOut View TI Process Code Help
Replies: 4
Views: 477

Re: TM1 ZeroOut View TI Process Code Help

2 questions
1/ why not do it with MDX rather than the loop?
2/ is "1090-1000" the principal name or an alias? DimNm will always return the string of the principal name so if the principal name is actually 10901000 then that would explain it ...
by lotsaram
Thu Feb 01, 2018 6:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button - Using a cell reference for the Tm1 Server
Replies: 9
Views: 3481

Re: Action Button - Using a cell reference for the Tm1 Server

Bumping this to see if anyone has additional light to shed. We have the problem. However, the action buttons ALWAYS work in our dev environment. In our QA and PROD environments, the migrated web sheets are hit or miss on whether the action button will use the server reference or not. Just to get by...