TM1 Forum

I don't have one. That's the reason looking for sample code.

Can you get me a sample code?

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...

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...

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..

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.

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!

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']...

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 ge...

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 ...

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.

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