Build MS Olap Cubes, by scripts, from Txt files (as input)

The purpose is to build MS Olap cube (Analytical Services) from given flat files.

For the project, cubes are with three (3) dimensions, and each dimension have many hierarchies (Respectively: 3, 3, 16).

Building and deploying the cubes thru SSDT and Wizard is very simple.

Only a very fee number of parameters must be needed: name of the DB to create, Server Name, Username and Password, Path to localize Text files to read and number of dimensions (or loop on files).

---------------------- the goal to achieve -----------------------------

What we want is a main script doing the job with no manual input nor using wizard.


Of course, the main script may call other scripts.

See [url removed, login to view] for example.

May be SSIS could be used but must be flexible (i.e. with parameters).

We are providing the four (4) text files with the pipe (|) as separator as THE example to validate completely the main script.

Validation of the project will be straightforward:

1. Must run on our server (SQL Server [url removed, login to view])

2. The database does not exist in SQL Server and Analytical Services

3. Run the script with appropriate parameters

4. Open Excel, connect to the Cube and browse data

Habilidades: .NET, Servidor de Microsoft SQL , SQL

Ver más: design mondrian olap cubes, design olap cubes mondrian, olap cubes mondrian, postgresql olap cubes support, gui input txt file, olap cubes postgres, using text files input output vbasic 2008, pentaho olap cubes, input txt, zip list files unix txt, interpretation olap cubes, free olap cubes, olap cubes mondrian design, postgresql olap cubes, using excel files input, ftp files using perl scripts

Información del empleador:
( 0 comentarios ) Bruxelles, Belgium

Nº del proyecto: #12734905

10 freelancers están ofertando el promedio de $788 para este trabajo


Hi, I've read the details you mentioned and I'm interested in working on this project! I've a few important queries to ask so Please message me (Because only employer can initiate chat) so that we can discuss every Más

$588 USD en 10 días
(23 comentarios)

Hello Sir, I am an excellent .Net developer and SQL Server DBA. I have worked with OLAP in past and would like to discuss this project with you. Could you please share the sample text file with just couple of recor Más

$882 USD en 10 días
(39 comentarios)

Hi, I have read your post and understood your requirement. I have great experience working on /.NET/PHP/MySQL/HTML5/jQuery/Laravel/Wordpress/Magento/Joomla/Drupal/AngularJS/node.js/CSS3/Java/Python/Django/Javascr Más

$1030 USD en 10 días
(6 comentarios)

Hi, I can deliver this project within 1-2 days. I would need to ask a few questions to clarify the scope. Please send me a message if you're interested. Thank you.

$1000 USD en 0 días
(5 comentarios)

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore Más

$882 USD en 20 días
(11 comentarios)

Hi, I’m software and database developer with more than 35 years experience. Twenty of those years I worked (full-time, in-situ) for two international organizations; IATTC, in San Diego, CA, USA, and the Food and Agricu Más

$777 USD en 8 días
(3 comentarios)

I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in programming and development I Más

$555 USD en 10 días
(3 comentarios)

Hello, Its a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work upon customization part, if we can proceed towards more discussion. I have gone through your project Más

$833 USD en 18 días
(0 comentarios)
$776 USD en 10 días
(0 comentarios)
$555 USD en 10 días
(0 comentarios)