<div>
Do you have Essbase? What query are you using to extract data into the cube?
</div>


Do you have Essbase? What query are you using to extract data into the cube?

<div>
Quite right - I didn't see &quot;Reporting Services&quot;<br />
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&amp;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.<br />

</div>


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.


<div>
I know what it is--I just didn't see where it applied to this question...
</div>


I know what it is--I just didn't see where it applied to this question...

<div>
Hi,<br />
<br />
I was hoping that I could keep it simple without using an MDX query but it appears not.
</div>


Hi,

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

<div>
<div class="content wysiwyg-content">
I am trying to retreive OLAP data from a Cube (Test1) in SQL Server Reporting Services.<br />
<br />
I have created a shared Data Source:<br />
<br />
Provider=MSOLAP.2;Client Cache Size=25;Data Source=DEV08;Auto Synch Period=10000;Initial Catalog=BAMAnalysis<br />
<br />
I have a Data Set as follows:<br />
Command Type: TableDirect<br />
Query: Test1 (the name of the Cube)<br />
<br />
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?<br />
<br />
Thanks in advance.
</div>
</div>


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.

Accessing OLAP Cube data from Reporting Services

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.