Page 1 of 1

How to generating a text file using Control cube?

Posted: Fri Apr 13, 2018 1:43 pm
by lax9
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

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

Posted: Fri Apr 13, 2018 2:32 pm
by Wim Gielis
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.

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

Posted: Fri Apr 13, 2018 2:37 pm
by tomok
Nobody is going to write your code for you. Basically you create a TI process and select Cube as the data source and then you select default as the view. Then in the data tab you use the TI function ASCIIOUTPUT to write what is in the Value field from the view to a text file. It's pretty simple. An even simpler option is to just right click on the }ClientGroups cube and choose Export as Text Data, then Export.

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

Posted: Fri Apr 13, 2018 2:41 pm
by lotsaram
lax9 wrote: Fri Apr 13, 2018 1:43 pm 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 do realize this is just the tip of the iceberg don't you?
A list of members per group doesn't really tell you much. If this is needed for an audit you also need to know what rights the groups confer on the users, and then whether the conferred rights are as per the specifications.

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

Posted: Mon Apr 16, 2018 4:42 pm
by lax9
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.

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

Posted: Mon Apr 16, 2018 4:46 pm
by lax9
lotsaram wrote: Fri Apr 13, 2018 2:41 pm
lax9 wrote: Fri Apr 13, 2018 1:43 pm 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 do realize this is just the tip of the iceberg don't you?
A list of members per group doesn't really tell you much. If this is needed for an audit you also need to know what rights the groups confer on the users, and then whether the conferred rights are as per the specifications.
Yeah, i do know that it is a tip of iceburg. I am in the process of learning the TM1 code and looking for some help. '
Thanks for your suggestion.

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

Posted: Wed May 02, 2018 7:04 pm
by lax9
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.
Yes this is recurring task. we need to generate a CSV file with all TM1 accounts(clients) periodically using a TI process.
Can you suggest which method is recommended ? Active form or TI? Please do let me know. Thank you!