Showing posts with label model. Show all posts
Showing posts with label model. Show all posts

Thursday, March 8, 2012

Can't create report model on Analysis Database

Hi,
Help!!
I have created and deployed my Analysis Database using SQL Server 2005.
Next, I intend to create a report model based on this database, so that can
perform ad-hoc reporting via Report builder.
But, I can't seem to be able to create report model based on the Analysis
database data source. FYI, I am using BI Development Studio to create report
model.
Also, I have tried to use the Generate Model from report manager
(http://localhost/reports) and SQL Server Management Studio, but the option
seem not available !! I just couldn't find the option.
Please advise.
rgds,
tkCreating a Analysis model is different - here's a link.
http://msdn2.microsoft.com/en-us/library/ms345292.aspx
"tk" wrote:
> Hi,
> Help!!
> I have created and deployed my Analysis Database using SQL Server 2005.
> Next, I intend to create a report model based on this database, so that can
> perform ad-hoc reporting via Report builder.
> But, I can't seem to be able to create report model based on the Analysis
> database data source. FYI, I am using BI Development Studio to create report
> model.
> Also, I have tried to use the Generate Model from report manager
> (http://localhost/reports) and SQL Server Management Studio, but the option
> seem not available !! I just couldn't find the option.
> Please advise.
> rgds,
> tk

Tuesday, February 14, 2012

Can't connect to Report Server Model

I've created and successfully deployed a Report Server Model. However, when I try to use it as a data source to write reports against, I can't connect to it. When I create a new shared data source, the option of Report Server Model appears in the Type: dropdown, but there's no way for me to add/edit the connection string. That option is grayed out.

Is this a security issue? I've checked all the permission options in Management Studio and I should have access to everything. I'm not sure what he problem is here.

Any help is appreciated.

BTW, I can create reports using Report Builder (web interface), but not in BIDS.

Anyone?