Solved

Accessing OLAP Cube data from Reporting Services

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

680 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