After creating a cube in SSAS, is it possible to make this visible to users in Report Builder
As far as I can see Report Builder uses report models which are based on a relational database for a data source view, so it seems I have to rewrite all the cube logic in order to make it available in Report Builder (otherwise I guess it's a case of telling users to connect to the Cube from Excel )
Thanks
SSAS Cube and Report Model
Tigerwood2006
Cool! Perfect! That's exactly what I needed!
Thanks
madshi
Not sure this answer your question or not.
Once you deploy and process your cube go to SQL Server Management Studio, connect to Reporting Services.
Create "New Data Source" by right click Home to OLAP database.
data source type: Analysis Services
connection string: data source=OLAPServerName;initial catalog=OLAPDBName
right click that Data Source and Generate Model.
That model you can access from Report Builder
-Ashok