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

Este proyecto recibió 12 ofertas de freelancers talentosos con una oferta promedio de $749 USD.

Obtén cotizaciones gratis para un proyecto como este
Presupuesto de Proyecto
$250 - $750 USD
Ofertas Totales
Descripción del Proyecto

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 Requeridas

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online