By:
On:
In: Article, MDX Query, SSAS
Tagged: , , , ,

In this post we will see how we can get the datatype of each measures we use in our SSAS MDX Queries. This post may be helpful if you are working with SSAS cubes especially you need to work with the data you gets from the cubes like formatting the data, assigning the data as grid data source or formulate the data to any other form. I have got a requirement to show the cube data as a grid, So I was needed to know the types of each measures user selects so that I can assign the grid column types accordingly. There are fewRead More →

Convert data reader to data table

By:
On:
In: Article, Microsoft ADOMD, SSAS
Tagged: , , , , , ,

In this article we will learn how we can convert Microsoft ADOMD data reader to datatable. As you all know a data reader is the most efficient way for looping through the data. Performance wise a data reader is faster than any of the other way like data adapter and cell set in MDX result. So in few situations you may need to convert this data reader to a data table. Here in this post we will discuss how we can convert it. I hope you will like it. Background For the past few months I have been working with Microsoft ADOMD data sources. AndRead More →

Excel Export In MDX

By:
On:
In: Article, ASP.NET, MDX Query, SQL
Tagged: , , , , , , , ,

In this post we will see how we can export mdx query result. Here we are going to use MVC with the help of jQuery Ajax. We will run the MDX query and get the cell set and then we will convert this cell set to html table so that we can render this html table easily in client side. Once we render the html table we will do some manipulations with the data, to increase the readability. We use one jQuery Ajax Call, One Controller, One function to execute the query and get cell set, and another function to convert the cell set toRead More →

By:
On:
In: Article, MDX Query
Tagged: , , , , , , , , , , , ,

Introduction Today we will learn about filter conditions in MDX queries. There are so many conditions in MDX as we have SQL. I am going to discuss most used filter conditions in MDX. I hope you will like it. Background For the past few days I am working on the MDX queries. Since my applications data source were ADOMD data source, It was must to learn about MDX queries. If you are new to ADOMD, you can find out some tips here: ADOMD Tips What is MDX? Before going to start, we will see what MDX is? MDX stands for Multidimensional Expression It is aRead More →

By:
On:
In: Article, ASP.NET, C#, JQuery, Json, Microsoft ADOMD
Tagged: , , , , ,

In this article we will learn how we can convert Microsoft ADOMD cell sets to JSON. There are few possible ways to convert a CellSet to JSON, Here by I am sharing you one among that options. We will create a function which accepts cellset as the argument and we will loop through the axes of cellset and bind the values according to a string builder using a JsonWriter class. I hope you will like it. Background For the past few months I have been working with Microsoft ADOMD data sources. And I have written some article also that will describe the problems I haveRead More →