Export data

Post Reply
Amit91
Posts: 2
Joined: Thu Jul 04, 2019 12:34 pm
OLAP Product: TM1
Version: 2.0.6
Excel Version: 2016

Export data

Post by Amit91 »

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.
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Export data

Post by Elessar »

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
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
Amit91
Posts: 2
Joined: Thu Jul 04, 2019 12:34 pm
OLAP Product: TM1
Version: 2.0.6
Excel Version: 2016

Re: Export data

Post by Amit91 »

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.
User avatar
Steve Rowe
Site Admin
Posts: 2410
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

Post by Steve Rowe »

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,
Technical Director
www.infocat.co.uk
Post Reply