how to reverse engineer an SQL cube(Analysis Service)so that a data access for .NET applications is enabled , just like Entity Framework (ex. dataBase first approach ) but instead of an SQL DB a live Cube(Multidimensional Expressions) that can be queried via LINQ query ?
Asked
Active
Viewed 65 times
1 Answers
1
Use a data provider such as ADOMD which can connect to a cube to read its structure, and run MDX queries to return tables of values.
Magnus Smith
- 5,895
- 7
- 43
- 64
-
yes great used that and worked , but is there a tool that is LINQ query enabled as ADOMD only allows mdx query , and would it be a live cube ? – Wesam Jul 30 '18 at 10:55
-
If LINQ is for OLTP databases only (?) then I guess OLAP cubes are not possible. – Magnus Smith Jul 30 '18 at 11:54
-
See also https://stackoverflow.com/questions/2233839/using-entity-framework-with-an-ssas-cube – Magnus Smith Jul 30 '18 at 11:55