OLAP

Great Reads

OLAP CUBE Optimization Technique and a Small Trade off

by SERokon

OLAP cube performance optimization technique

Introduction to Named Query in Sql Server Analysis Services

by Mubin M. Shaikh

Create Named Query in Data Source View While Designing OLAP Cube in SSAS

Presenting NSimpleOlap (Alpha & Unstable)

by Carlos Conceição

NSimpleOlap is embeddable .Net OLAP library for use in console, desktop, or other types of applications.

Serializing CellSet Adodm MDX Query Result Set to JSON

by Fedor Dzjuba

Sometimes, we need to present MDX result on the web or a client application that has no native provider to Microsoft Analysis Service. Solution is to use Adodm.Client CellSet, serialize it into sensible JSON and spit it out to the client to render.

Latest Articles

Exploring Data Cubes on NSimpleOlap (Alpha)

by Carlos Conceição

Current features of NSimpleOlap library

Presenting NSimpleOlap (Alpha & Unstable)

by Carlos Conceição

NSimpleOlap is embeddable .Net OLAP library for use in console, desktop, or other types of applications.

Serializing CellSet Adodm MDX Query Result Set to JSON

by Fedor Dzjuba

OLAP for Free

by IChechin

How to implement free OLAP cube in your project

All Articles

top

OLAP

OLAP CUBE Optimization Technique and a Small Trade off

25 Sep 2014 by SERokon

OLAP cube performance optimization technique

SQL-Server

OLAP

Introduction to Named Query in Sql Server Analysis Services

29 Sep 2013 by Mubin M. Shaikh

Create Named Query in Data Source View While Designing OLAP Cube in SSAS

Presenting NSimpleOlap (Alpha & Unstable)

22 Apr 2021 by Carlos Conceição

NSimpleOlap is embeddable .Net OLAP library for use in console, desktop, or other types of applications.

.NET

Dev

OLAP

How to use OLAP cubes in my Silverlight application

9 Apr 2011 by Wendelius

This depends on what you're going to do in the end. SSRS (Reporting Services) can be used to report from analysis services so that's one possibility. Also using ADOMD.NET[^] could be reasonable if you want to utilize more advanced techniques.And if connecting using ADOMD, don't forget...

Silverlight

OLAP

Serializing CellSet Adodm MDX Query Result Set to JSON

1 Dec 2019 by Fedor Dzjuba

How to fetch data from Online analytical processing(OLAP) using webservice or in c#

26 Sep 2013 by Maciej Los

I would suggest you to read these:Understanding Microsoft OLAP Architecture[^]About OLAP source data in PivotTable and PivotChart reports[^]How to tune OLAP Cube performance? - Case fetching data with SQL query from DB is faster[^]How to perform a SQL Server distributed query with OLAP...

web

OLAP

service

Four Ways to Improve Back-end Performance for Multidimensional Analysis

9 Jan 2018 by JIANG Buxing

To speed up OLAP analysis, there are 4 ways available for use.

Dev

OLAP

OLAP for Free

20 Jun 2019 by IChechin

How to implement free OLAP cube in your project

T-SQL

OLAP

How to use OLAP cubes in my Silverlight application

9 Apr 2011 by Member 7826959

hello all,I am creating a Silverlight application with Visual Studio 2010, and I intend to add a business intelligence module that analyzes data in OLAP cubes.SQL Server BI Developer Studio which is included in SQL Server 2005 allowed me to create cubes and deploy it, but I do not know how...

Silverlight

OLAP

How to use OLAP cubes in my Silverlight application

17 Apr 2011 by kroxa

see also pivotgrid for SSAS on codeplex/[^]

Silverlight

OLAP

Crystal Report using Oracle Cube?

27 Mar 2012 by Anoop Ananthan

Hello Everyone,I need to create a report from SAP Crystal Report XI using Oracle 11, Cube.I have already created cubes in Oracle Database. I could not find a way to access this cubes using Crystal Reports. When I try to create a report using OLAP Cube ReportWizard, I get an option to...

Oracle

CrystalReports

OLAP

Runtime Impersonation for OLAP Database Connection

22 Nov 2012 by Stephen Hewison

Hi,I've currently got an issue where I have a website which is running as a specific user. I'm not able to run the website using impersonation.I have a SQL analysis service database which returns different data depending on the connected user.How can I override the windows user...

ASP.NET

OLAP

Runtime Impersonation for OLAP Database Connection

22 Nov 2012 by Stephen Hewison

Well I beat all you experts to an answer. The following is the class I constructed. This class changes the current windows identity for the duration of the classes life span. Disposal and deconstruction is used to revert to the previous user.A usage example will follow...

ASP.NET

OLAP

How to fetch data from Online analytical processing(OLAP) using webservice or in c#

26 Sep 2013 by Harendra.jadon

Please tell me how to fetch data from OLAP by any means in .NET using anything. In Asp.net, c#, webservice, wcf anything.

web

OLAP

service

Reading data from offline OLAP cube

9 May 2014 by Olylesia

I have simple JavaScript component that can read data from OLAP cube via XMLA using msmdpump.dll. How I can communicate with offline cubes, discover data structure or execute MDX queries? Do I need some special libraries or settings?

Javascript

OLAP

Problem in Exporting the SyncFusion OlapClient Grid and Chart to Excel

18 Dec 2014 by Raghuveer Kasyap

Hi,I am unable to export the OlapClient Chart & Grid to Excel.Please help me ASAP.Below is the exception details.Specified Argument was out of valid values.Parameter name : firstCol and lastCol.Thanks,Raghuveer

ASP.NET4

OLAP

Problem in Exporting the SyncFusion OlapClient Grid and Chart to Excel

18 Dec 2014 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Quote:Specified Argument was out of valid values. Parameter name : firstCol and lastCol.Seems like the values present in those columns are going beyond the valid range. Please dig more into the code and find out.You can also put a question in the SyncFusion forums.

ASP.NET4

OLAP

Please help to do OLAP connectivity

30 Mar 2016 by Member-515487

Unable do OLAP connectivity using (OleDbConnection connection = new OleDbConnection("Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Adventure Works DW 2008R2;Data Source=http://demos.telerik.com/olap/msmdpump.dll")) { ...

OLAP

Exploring Data Cubes on NSimpleOlap (Alpha)

5 May 2021 by Carlos Conceição

Current features of NSimpleOlap library

OLAP for LightSwitch

2 Sep 2011 by MESCIUS

A video that demonstrates OLAP for LightSwitch

LightSwitch

OLAP

Introduction to Named Calculations in SQL Server Analysis Services

30 Sep 2013 by Mubin M. Shaikh

Create Virtual Column Using Named Calculation in SQL Server Analysis Services

Create First OLAP Cube in SQL Server Analysis Services

21 Jul 2014 by Mubin M. Shaikh

Learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data Warehouse

Learn to Write Custom MDX Query First Time

17 Jan 2014 by Mubin M. Shaikh

Learn Custom MDX Query Step by Step

apply association rule on multidimensional data mining cube

13 Feb 2012 by jigarpandya

Dear all, i am doing ME from gujarat in Computer engineering.i am doing one project on data mining cube .my definition is "apply association rule on multidimensional data mining cube " . I am totally new to this field so if you can please help me in my...

multiple hierachi is possible with same dimension

31 May 2014 by rehank99

Hi Mubin,I need help. Is it possible if can create multiple hierachi in the one or two table within one dimension. We have entity table where we have entity and parent entity. wentityid is unique key in the table and related is based on wparentid in the same table. We have multiple...

OLAP

can I switch an olap cube to a relational Database

24 Feb 2015 by Member 11333067

I want to cross SEVERAL cubes, so I thought if I can switch olap to a relational database to make better use of the data ??

DWH

OLAP

Show BACK_COLOR from OLAP in PivotTable

3 Sep 2015 by Member 10976343

In c# Excel Add-In I want to find out the true background color (CELL PROPERTIES BACK_COLOR) of the values from MDX query. Not the color of the cell from Pivot tables, which can be changed manually.

C#5.0

pivot-table

OLAP