analysis services mdx query

The MultiDimensional eXpressions (MDX) language provides a specialized syntax for querying and manipulating the multidimensional data stored in OLAP cubes.[1] While it is possible to translate some of these into traditional SQL, it would frequently require the synthesis of clumsy SQL expressions even for very simple MDX expressions. MDX has been embraced by a wide majority of OLAP vendors and has become the standard for OLAP systems.

cubes
.Net Blazor
Ian McHugh

Microsoft Analysis Services MDX Query with Linq

Currently there is no Object Mapping Layer for Analysis Services OLAP or Tabular and this can make it difficult to render data in anything other than a Pivot Table or BI Tool such as Power BI, Tableau etc. This post discusses a simple method for getting results of Analysis Services MDX Queries into C# dynamic objects and using Linq and standard Blazor components to render in the UI.

Read More »
9 February 2024 No Comments

Do You want to accelerate your Project?

drop me a line and keep in touch

CONTACT ME