Creating a report model against an SSAS Cube in Visual Studio

I'm trying to create a report model in visual studio. I need the model
to report against an exiting cube. I can easily make the model in SQL
Server management studio. When I try to do the same in Visual Studio I
run up against a problem when I try to create the datasource view. The
steps I'm taking:
- I add a new Report Model Project into the solution that contains my
Analysis Services Project.
- I add a new datasource to the Report Model Project choosing to create
the source on an object and choosing the existing Analysis Services
Project.
- If I try to add a datasource view, the datasource I created doesn't
show up. (I've read in Microsoft documentation that this is designed
functionality)
- I can't find a way to create a report model directly against the
datasource and of course there is no datasource view. It would seem
that I should be able to create a report model directly against the
datasource since that's how both SQL Server Management Studio and the
reporting web interface works but I can't figure it out.
Can someone help me?I'm not sure I really understood what do you want to achieve
The way to create a model with Analysis Services data source is to :
a) open your Reporting Seervices with Mangement Studio
b) Choose your Analysis Services data source
c) Right click and choose "Generate a model..." from the contextual menu
Med Bouchenafa
"krosschell@.rdacorp.com" <talldrink@.gmail.com> a écrit dans le message de
news: 1138217467.115673.224510@.z14g2000cwz.googlegroups.com...
> I'm trying to create a report model in visual studio. I need the model
> to report against an exiting cube. I can easily make the model in SQL
> Server management studio. When I try to do the same in Visual Studio I
> run up against a problem when I try to create the datasource view. The
> steps I'm taking:
> - I add a new Report Model Project into the solution that contains my
> Analysis Services Project.
> - I add a new datasource to the Report Model Project choosing to create
> the source on an object and choosing the existing Analysis Services
> Project.
> - If I try to add a datasource view, the datasource I created doesn't
> show up. (I've read in Microsoft documentation that this is designed
> functionality)
> - I can't find a way to create a report model directly against the
> datasource and of course there is no datasource view. It would seem
> that I should be able to create a report model directly against the
> datasource since that's how both SQL Server Management Studio and the
> reporting web interface works but I can't figure it out.
> Can someone help me?
>|||When you say "Management Studio" I believe you are refering to SQL
Server Management Studio. I agree, creating a reporting model from
there is easy as cake. I'm trying to create a Reporting model from
Business Inteligence Management Studio. There is a project type "Report
Model Project" and I want to create a report model in this environemnt.
(one that uses a cube as it's data source). Does that make more sense?