Solved

Accessing OLAP Cube data from Reporting Services

Posted on 2004-08-12
7
1,106 Views
Last Modified: 2011-03-01
I am trying to retreive OLAP data from a Cube (Test1) in SQL Server Reporting Services.

I have created a shared Data Source:

Provider=MSOLAP.2;Client Cache Size=25;Data Source=DEV08;Auto Synch Period=10000;Initial Catalog=BAMAnalysis

I have a Data Set as follows:
Command Type: TableDirect
Query: Test1 (the name of the Cube)

When I run the query the cube dimension data is returned but none of the measure data. Does anyone know why? How can I retrieve the measure data from the Cube?

Thanks in advance.
0
Comment
Question by:DavidDunn
  • 2
  • 2
7 Comments
 
LVL 5

Expert Comment

by:hkamal
ID: 11782755
Do you have Essbase? What query are you using to extract data into the cube?
0
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 11788482
The query is simply the name of the cube--nothing else?

Essbase? What does that have to do with SQL/Reporting services?
0
 
LVL 5

Expert Comment

by:hkamal
ID: 11791353
Quite right - I didn't see "Reporting Services"
Essbase is a 3rd party product often used with SQL Server/Sybase particularly for dense multidimentional financial (cube-friendly) data. With something like AlphaBlox as front-end, drag&drop reporting is possible on terrabytes of related data. It is however a distinct entity and requires daily extracts from SQL Server to populate its cubes.
0
 
LVL 34

Expert Comment

by:arbert
ID: 11795887
I know what it is--I just didn't see where it applied to this question...
0
 

Author Comment

by:DavidDunn
ID: 11828413
Hi,

I was hoping that I could keep it simple without using an MDX query but it appears not.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question