Report Models for OLAP Cubes
in [Reports]
|
Prev: can't create a mode l for my cubes (rsModelGenerationError)
Next: PrinTDocument throws A generic error occurred in GDI+.
From: Marc on 14 Nov 2006 03:07 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, Marc
From: Wei Lu [MSFT] on 14 Nov 2006 04:56 Hello 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.
From: Marc on 14 Nov 2006 05:48 Hello Wei Thanks for your answer. I tried this way, but I failed to create the necessary data source view... Marc
From: Wei Lu [MSFT] on 14 Nov 2006 22:09 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.)
From: Marc on 15 Nov 2006 02:11
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 |