Prev: can't create a mode l for my cubes (rsModelGenerationError)
Next: PrinTDocument throws A generic error occurred in GDI+.
From: Wei Lu [MSFT] on 15 Nov 2006 02:42
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.

From: Marc on 15 Nov 2006 04:53
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
From: Wei Lu [MSFT] on 15 Nov 2006 21:02
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.

From: Marc on 16 Nov 2006 10:09
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

From: Marc on 17 Nov 2006 03:01
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
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: can't create a mode l for my cubes (rsModelGenerationError)
Next: PrinTDocument throws A generic error occurred in GDI+.