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

  • Estado Cerrado
  • Presupuesto $250 - $750 USD
  • Total de ofertas 12

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

Obtén cotizaciones gratis para un proyecto como este
Habilidades necesarias

¿Buscas ganar algo de dinero?

  • Fija tu plazo y presupuesto
  • Describe tu propuesta
  • Recibes pagos por tu trabajo

Contrata Freelancers que también oferten en este proyecto

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