TM1 Forum

Hi,

I want to export 100 existing customer data only from cube.

Can anyone help me with the coding how to achieve this task?

Thanks in advance.

Hi,

There are many ways to do this.
1. Create a view with 100 customers. Use Architect "Export as text data" function
2. in PAW or TM1web, use "export to excel" function
3. Use Bedrock: https://github.com/cubewise-code/bedroc ... ata.export
4. Write your own process, using ASCIIOutput or TextOutput

Hi Elessar,

Thanks for your quick response. Actually i want to delete all old customer data in all cube how to achieve through TI process only, Because if i export data through PAW or TM1 web that is manual work i want to do through TI process only.

Thanks.

Which is it though?
Export 100 customers from one cube?
or
Delete data from all customers and all cubes?

They are very different requests...

I'd also refer you to the Request for Assistance Guidelines stickied at the top of the forum. It is well worth reviewing this so that your posts meet the minimum standards and increase the chances for a useful response.

At a minimum I would also suggest that your review the TI functions in the online help and have a go at scripting this yourself, in a development of course!

Cheers,