Search found 12 matches

by lax9
Wed Oct 03, 2018 6:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements from dimension
Replies: 8
Views: 918

Re: Deleting elements from dimension

I don't have one. That's the reason looking for sample code.
by lax9
Wed Oct 03, 2018 3:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements from dimension
Replies: 8
Views: 918

Re: Deleting elements from dimension

Can you get me a sample code?
by lax9
Wed Oct 03, 2018 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements from dimension
Replies: 8
Views: 918

Deleting elements from dimension

Hi All, Can we delete some elements from a dimension using TI? or any other way? Below is my scenerio: We have some test invoices in the dimension which needs clean up. They want to delete invoices based on the time period(example: delete all invoices before this date??) Can we delete these test inv...
by lax9
Tue Jul 17, 2018 4:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset
Replies: 5
Views: 914

Dynamic Subset

Hi All, Getting the below error while running TI: Error: Epilog procedure line (412): Could not create dynamic subset: expression: {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {[Account PCR].[DLR_REC_NACD2 DEALER RECEIVABLES - NACD (Cat Sales Inc) on LM Books] }, ALL, RECURSIVE ) },0 )} Please let me kno...
by lax9
Fri Jul 13, 2018 2:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension subset editor in TM1 Perspectives
Replies: 9
Views: 990

Re: Dimension subset editor in TM1 Perspectives

Thank you all for the replies.

Based on your thoughts and recommendation I did check the subNM formulaes and noticed that they are pointing to another server , I set it to the correct server. Thank you All..
by lax9
Thu Jun 07, 2018 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension subset editor in TM1 Perspectives
Replies: 9
Views: 990

Re: Dimension subset editor in TM1 Perspectives

no , it's not related to the monitor.

I believe the issue is within the excel sheet subnm formula (TM1 perspectives).
Able to open the same report and nable to access dimension subset editor from another instance on the same server.
by lax9
Thu Jun 07, 2018 2:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension subset editor in TM1 Perspectives
Replies: 9
Views: 990

Dimension subset editor in TM1 Perspectives

Hi All,

In TM1 Perspective Report I tried to open up the dimension subset editor, but not able to. (no error msg though )

what may be the reason that i am not able to go into the subset editor?

Please share your thoughts if you have idea on this. Thank you!
by lax9
Tue Jun 05, 2018 9:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Same rules within the cube
Replies: 1
Views: 356

Same rules within the cube

Hi All, Can anyone help me out with the below issue: We have a below rule (working) in the rule file. Old rule ['xxx'] = N: - ['ALL', 'Ending Balance'] + ['ALL', 'Opening Balance'] + ['old account']; New rule ['xxx'] = N: - ['ALL', 'Ending Balance'] + ['ALL', 'Opening Balance'] + ['updated account']...
by lax9
Wed May 02, 2018 7:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to generating a text file using Control cube?
Replies: 6
Views: 1185

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

Hello, Is this a recurring task ? I would advise to create an Active form, with clients and groups in the rows, zero-suppressed. This will give you the list, which can be "saved as" with a text file format if needed. A TI process is also possible. Yes this is recurring task. we need to generate a C...
by lax9
Mon Apr 16, 2018 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to generating a text file using Control cube?
Replies: 6
Views: 1185

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 lax9
Mon Apr 16, 2018 4:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to generating a text file using Control cube?
Replies: 6
Views: 1185

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

Wim Gielis wrote:
Fri Apr 13, 2018 2:32 pm
Hello,

Is this a recurring task ?
I would advise to create an Active form, with clients and groups in the rows, zero-suppressed.
This will give you the list, which can be "saved as" with a text file format if needed.

A TI process is also possible.
Thanks Wim.
by lax9
Fri Apr 13, 2018 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to generating a text file using Control cube?
Replies: 6
Views: 1185

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