• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1126
  • Last Modified:

Accessing OLAP Cube data from Reporting Services

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
DavidDunn
Asked:
DavidDunn
  • 2
  • 2
1 Solution
 
hkamalCommented:
Do you have Essbase? What query are you using to extract data into the cube?
0
 
arbertCommented:
The query is simply the name of the cube--nothing else?

Essbase? What does that have to do with SQL/Reporting services?
0
 
hkamalCommented:
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
 
arbertCommented:
I know what it is--I just didn't see where it applied to this question...
0
 
DavidDunnAuthor Commented:
Hi,

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now