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.
Export data
- Elessar
- Community Contributor
- Posts: 340
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Export data
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
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
Best regards, Alexander Dvoynev
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Posts: 2
- Joined: Thu Jul 04, 2019 12:34 pm
- OLAP Product: TM1
- Version: 2.0.6
- Excel Version: 2016
Re: Export data
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.
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.
- Steve Rowe
- Site Admin
- Posts: 2416
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Export data
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,
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,
Technical Director
www.infocat.co.uk
www.infocat.co.uk