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

Compétences : .NET, Serveur SQL Microsoft, SQL

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Bruxelles, Belgium

Nº du projet : #12734905

10 freelance font une offre moyenne de $788 pour ce travail


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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(23 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(39 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(6 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(5 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(11 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(3 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(3 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 18 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)