Search found 22 matches

by CellPutN
Tue May 07, 2019 5:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 8802

Re: TI - Add new element in alphabetical order under consolidation

I never had a model with feeders file of about 10GB each.
I agree with you,

Code: Select all

CubeSaveData('}DimensionProperties');
is better than

Code: Select all

SaveDataAll;
by CellPutN
Tue May 07, 2019 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 8802

Re: TI - Add new element in alphabetical order under consolidation

Hi Wim, I never had perfomance issue with SaveDataAll but I think it can be a CubeSaveData. To be honest, I have no idea why we have to save on the server but that's what it said in the DimensionSortOrder documentation: This function sets a sort type and sense for dimension elements and for componen...
by CellPutN
Tue May 07, 2019 3:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 8802

Re: TI - Add new element in alphabetical order under consolidation

Create a TI with a dimension parameter and copy the following code in the prolog. It will solve all your problems ! ################################################### # # This TI sort order for the dimension entered as parameter. # All dimension elements are sorted in ascending by level, # and any ...
by CellPutN
Mon May 06, 2019 6:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 6978

Re: Cognos Analytics 11.0.13

kavitha2002 wrote: Fri May 03, 2019 1:12 pm Hi Everyone,

I would like to install the CA 11.0.13. Is there any step by step
installation guide for this version or later.

Thanks in advance.

Use the wizard.
by CellPutN
Fri Apr 12, 2019 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: calculating WTD, YTD and QTD with rules
Replies: 5
Views: 4431

Re: calculating WTD, YTD and QTD with rules

Hi,

I suggest you to take a look at this white paper.

https://static1.squarespace.com/static/ ... Design.pdf

There's an entire section on how to structure time dimensions.

Cheers,
Max
by CellPutN
Wed Apr 10, 2019 8:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics
Replies: 2
Views: 2300

Re: Planning Analytics

Hi,

You should take a look at the Cubewise blog.

https://cubewise.com/blog/

Cheers,
Dilan
by CellPutN
Wed Apr 03, 2019 1:22 pm
Forum: OLAP Jobs
Topic: TM1 Developer Job in Montreal, Canada
Replies: 0
Views: 44681

TM1 Developer Job in Montreal, Canada

Hello, You are good with TM1 and want to work in Montreal, Canada ? We are a consulting firm based in Montréal and actively looking for TM1/PA consultants ! Reasons to move to Montreal: Lower Rents. World-Class Culture. Beer in the Corner Stores. Tons of Festivals. Cheaper Public Transit. Bicycle Fr...
by CellPutN
Mon Apr 01, 2019 12:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to schedule chore job monthly
Replies: 8
Views: 11347

Re: How to schedule chore job monthly

Thanks macsir but i'm not sure to understand how tm1runti can solve this problem ?

Peter
by CellPutN
Fri Mar 29, 2019 4:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to schedule chore job monthly
Replies: 8
Views: 11347

Re: How to schedule chore job monthly

Thanks Alan, The following process is executed every day and it works just fine to execute my Month-End process. #================================================== # Variable Declaration #================================================== sTomorrow = DATE(NOW + 1); #================================...
by CellPutN
Wed Mar 13, 2019 6:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: List of all rules
Replies: 2
Views: 2191

List of all rules

Hello everyone,

I know we can easily get a list of all dimensions or cubes using the control objects, but is there a way to get a list of all other types of TM1 object ?

There's no such dimension as }Rules or }Views.

Thanks and have a nice day !
Tim
by CellPutN
Tue Feb 26, 2019 1:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 web report issue
Replies: 3
Views: 2566

Re: Tm1 web report issue

Can you please provide more detail such as TM1 version or Report type (Slice or Active form ) ?
by CellPutN
Wed Feb 20, 2019 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to rename a cube
Replies: 1
Views: 2201

How to rename a cube

Hello, I know changing a cube name is pretty straight forward. 1- stop server 2- change cube name in data folder 3- reboot server But what happen if I just want to change a capital letter ? I had change the "a" for an "A" but it didn't change the cube name in Architect when I reb...
by CellPutN
Wed Feb 13, 2019 1:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is vcsch.log ?
Replies: 2
Views: 2316

Re: What is vcsch.log ?

Yes we have Pulse installed!

Thanks a lot Lotsaram, always helpful !!
by CellPutN
Wed Feb 13, 2019 2:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is vcsch.log ?
Replies: 2
Views: 2316

What is vcsch.log ?

Hello,

What is vcsch.log in the log folder ?


Thanks,
Pete
by CellPutN
Mon Feb 11, 2019 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get top parent of an element ?
Replies: 12
Views: 9649

Re: How to get top parent of an element ?

Thanks Lotsaram !

And it was for a very specific task for one of my customer ;)
by CellPutN
Sun Feb 10, 2019 2:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get top parent of an element ?
Replies: 12
Views: 9649

How to get top parent of an element ?

Hello all, I wonder if there's a more efficient way to retrieve the top parent (by top parent I mean the 'highest' consolidated element) of an element. In other word, for all leaf-level elements in a source dimension, I want to retrieve the top parent/ancestor and recreate it in a target dimension. ...
by CellPutN
Sat Jan 19, 2019 5:59 pm
Forum: Commercial and Events
Topic: TM1 coding extension for VSCode
Replies: 13
Views: 39014

Re: TM1 coding extension for VSCode

Well done !! Much better and PAW or TI Helper from Cubewise. But I have a question. IMPORTANT: IBM Planning Analytics/Cognos TM1 does not allow for direct editing of the .RUX and .PRO files. All editing must be done by copying the appropriate text from the standard TM1 interfaces and pasted into VSC...
by CellPutN
Tue Jan 15, 2019 12:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old TM1 version
Replies: 7
Views: 5501

Re: Old TM1 version

Wow thanks guys !

Nice to see how TM1 / PAW has improved over years !