Solved

Accessing OLAP Cube data from Reporting Services

Posted on 2004-08-12
7
1,102 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now