June CTP Report Model Creation using Analysis Services Datasource.

I'm having trouble creating a Report Model in Visual Studio.

Steps:
1) I create a data source which connects to AS (Note, I have to have the AS project in the same solution)
2) I create a data source view but I have no way to access the AS data source I just created. It only allows relational data sources. I also tried to create a new data source from the data source view wizard and that still does not work.

I can create my model from SQL Management Studio but I want to create it via Visual Studio.

What are the steps to properly create a model via Visual Studio or is this a bug in the latest CTP?

[623 byte] By [tabuelt] at [2007-12-16]

«« ApplicationDeployment.CurrentDeployment.ActivationUri
»» SQL Server Procedure call timeout from .Net

# 1

You can not create a Report Model on top of Analysis Services using the development environment. You'll have to continue to do it either via SSMS (connecting to Reporting Services) or via Report Manager (browse to where you have an SSAS data source defined and you'll see a Generate Model button on the properties page).

Dave Fackler

DaveFackler at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech