Fermé

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

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

11 freelance ont fait une offre moyenne de 767 $ pour ce travail

jastp

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

588 $ USD en 10 jours
(17 Commentaires)
6.1
seekdeveloper

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/[url removed, login to view] Plus

1030 $ USD en 10 jours
(6 Commentaires)
5.7
aanvikm

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

882 $ USD en 10 jours
(11 Commentaires)
5.3
steven6

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 jours
(3 Commentaires)
4.7
prashushinde9

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

882 $ USD en 20 jours
(11 Commentaires)
5.1
MarcoAGarcia

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

777 $ USD en 8 jours
(1 Commentaire)
3.5
hsh564cf84accd96

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

555 $ USD en 10 jours
(3 Commentaires)
1.4
lgrtechs

IT software application development company, Experts from United States having range of Skills available in our In-house staff: Dedicated:Android Developer,IOS Developer, Website Developer, ECommerce developer, PHP Dev Plus

555 $ USD en 10 jours
(0 Commentaires)
0.0
expertdevteam

Hello Sir, We are an Indian development company here. we have checked your posted details here and want more clarification in it, so message us to discuss on it more then we will able to move on it. Thanks

555 $ USD en 10 jours
(0 Commentaires)
0.0
RubyOnRail

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

833 $ USD en 18 jours
(0 Commentaires)
0.0
776 $ USD en 10 jours
(0 Commentaires)
0.0
555 $ USD en 10 jours
(0 Commentaires)
0.0