Report Portal

OLAP cube reading through MDX : part 1

This article explain learning of MDX query in detail. when OLAP cube is designed and deployed on SSAS engine , we use MDX to read data. OLAP cube contains data in Cube database. this cube database is different from OLTP relational database. Cube database contains Datasources, Datasource views,Cubes,dimension and minining structure. Each cube in cube list contains Measure Groups. these measure groups consist of different measures on which multiple dimension can be apply. I am assuming you have already available of OLAP cube in SSAS engine. if it is not available then first download it from codeplex and deploy the cube. I have already cover OLAP Cube deployment steps in my previous article step by step SSAS cube designing.

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.