Report Models for OLAP Cubes

Dear all
I studied BOL to find out how Report Models and Report Builder work. In
there it is written that Report Models from Cubes can only be created and
edited inside SQL Server Management Studio or Report Manager but not from
BIDS. They show this as an advantage, because automatical generating saves
time. This is true. But it is also less flexible!
Do you plan to make Cube Report Models accessible in BIDS in the near future
or did I miss a point?
Thanks for your help,
Kind regards,
MarcHello Marc,
You could create a SSAS datasource in the Report Project or Analysis
Project. And then, you could add this existing datasource into your Report
Model Project.
After that, you could create the Report Model in the BIDS.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei
Thanks for your answer. I tried this way, but I failed to create the
necessary data source view...
Marc|||Hello Marc,
You could create the data source view in the Analysis Services Project and
use it in the Report Model Project.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei
Thanks for your answer. My problem is still the same - it looks that the
data source view connects always to a relational database - even when I use
the one from an analysis services project.
But I want to create a report model that connects to a cube.
Thanks for your help,
Marc|||Hello Marc,
Sorry for misunderstood.
Your mainly concern is that you need to edit the report model which
generated in Report Manager or Management Studio.
You could do this by following.
After you generated the report model, you could right-click the report
model in the Management Studio and click Edit. It will save a smdl file in
your local machine. And then, you could add this file to your report model
project. You do not need to add any datasource then. You could edit the
report model in your BIDS.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei
OK. I created a Report Model Project and added the report model I saved
before out of management studio to my local machine.
After adding BIDS gives me a error message: "...smdl cannot be loaded: The
project must have a data source view associated with the model".
And a second message: Error loading'...smdl': The project must have a data
source view associated with the model.."
But this is exactly what I can not do, because I do not have a data source
view that connects to a cube.
mmmm... Any ideas?
Regards,
Marc|||Hello Roger,
After I save the smdl file to my local machine, I checked the smdl file and
find that it embedded the datasource view.
So when I add the smdl file to the BIDS, it will get the datasource view
information and generate a datasource view.
Please try to open the smdl file you saved and check whether it contained
the datasource information.
If it contains, you could add it to the BIDS.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei
Thanks for this information. Unfortunately I still fail to add the smdl file
to my Report Model Project.
How did you find out that there was an embedded data source view? When I
open the file in Visual Studio, all I receive I see is unformatted xml
text... When I search it for the extension dsv, I do not get a result. But I
think this is the wrong way to look.
Can it be that I need to change a setting in Management Studio that it gives
also the data source view with it?
Best regards,
Marc|||Hi Wei
OK. I checked it to find a enbedded dsv in my report model generated from a
Cube (!) but could not find the data source view within this smdl file.
After that I generated a report model from a relational database (!), edited
this smdl file and added to BIDS like you said. This worked very well.
So it looks that your way works for a relational report model but not for a
analytical (=SSAS, Cube) model.
My goal is to edit a report model generated from a Cube in BIDS...
Any ideas? Thanks Wei!
Marc|||Hi Marc,
I will consult the internal team to check about this issue. I appreciate
your patience.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
=====================================================
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================.|||Hi Marc,
After consulting our internal team, I confirmed that you could only
generate a model via Report Manager / SSMS.
You may send your feedback to the following url:
http://connect.microsoft.com/sqlserver.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei
Thanks for your support. I will post this feedback at
http://connect.microsoft.com/sqlserver.
Kind Regards,
Marc