Fastest way to Load data from excel to cube

gishita · Post by **gishita** » Tue Jan 17, 2017 6:23 am

which is the fastest way to load data from excel to cube?

Alan Kirk · Post by **Alan Kirk** » Tue Jan 17, 2017 7:50 am

gishita wrote:which is the fastest way to load data from excel to cube?

How long is a piece of string?

Specifically, how much data, what format is is in, it it intended to be written live or uploaded in bulk, how you are doing the uploads currently or what approaches you are considering... pretty much all of the relevant and important details that were not included here.

BariAbdul · Post by **BariAbdul** » Tue Jan 17, 2017 11:37 am

why can't you simply save it as CSV and load the data in to the cube? is Excel is must? Thanks

mvaspal · Post by **mvaspal** » Fri Jan 20, 2017 10:06 am

copypaste

jim wood · Post by **jim wood** » Fri Jan 20, 2017 12:56 pm

If you want to keep the sheet as a data entry portal then and DBS statements to it. You can even go wild, add buttons, submission checks, all kinds of good stuff. Not really fast in terms of up front work, but quick once done and reusable,

Jim.

TM1 Forum

Fastest way to Load data from excel to cube

Fastest way to Load data from excel to cube

Re: Fastest way to Load data from excel to cube

Re: Fastest way to Load data from excel to cube

Re: Fastest way to Load data from excel to cube

Re: Fastest way to Load data from excel to cube