D
D
Dmitry Bystrov2018-03-14 14:53:31
SQL
Dmitry Bystrov, 2018-03-14 14:53:31

Are there ready-made libraries for C# to create an Olap cube?

Hello!
There is a task: to create a web application that will receive an xls file via the web interface, parse data from it into the database and, based on the filled database, form an olap cube and unload all this disgrace in some format (I don’t know yet in which one, still to cope with the initial stages)
Are there any ready-made libraries for C # that will painlessly allow you to create an olap-cube? All the documentation that I found is quite old, and the technology itself is almost forgotten.
Let's say that the web muzzle, parsing data from a file to a database is solvable. And what about the creation of an olap-cube - this is not clear to me. Maybe someone has done something similar recently. What's the best way to do it?
Planned to use MS SQL Server and add-ons for VS 2017 (SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT)).
If I'm going in the wrong direction, please correct me. Maybe there are other solutions? Tell me, if there are such DBMS that support the creation of an OLAP cube, some options with NoSQL may work.
This whole issue is based on solving a problem that I have already discussed earlier HERE , but I have not found suitable tools.
I will be glad for any information.
Thank you!

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
d-stream, 2018-03-15
@Teshuhack

MS buried Analysis Server, now it has been replaced by BI ...
But for now, people still use AS (it grumbles and axes grumble at it, but it is installed on fresh OSes)
Well, then your application should be just an intermediary that feeds AS data and that's it. ...

L
lrv, 2018-04-03
@lrv

Why do you need a library for C#, if you can create a cube in VS. Only the server of type Analysis Services on SQL MS is necessary. Download VS and create a cube as a separate project.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question