Page 1 of 1
Fastest way to Load data from excel to cube
Posted: Tue Jan 17, 2017 6:23 am
by gishita
which is the fastest way to load data from excel to cube?
Re: Fastest way to Load data from excel to cube
Posted: Tue Jan 17, 2017 7:50 am
by Alan Kirk
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.
Re: Fastest way to Load data from excel to cube
Posted: Tue Jan 17, 2017 11:37 am
by BariAbdul
why can't you simply save it as CSV and load the data in to the cube? is Excel is must? Thanks
Re: Fastest way to Load data from excel to cube
Posted: Fri Jan 20, 2017 10:06 am
by mvaspal
copypaste
Re: Fastest way to Load data from excel to cube
Posted: Fri Jan 20, 2017 12:56 pm
by jim wood
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.