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
Showing posts with label model. Show all posts
Showing posts with label model. Show all posts
Thursday, March 8, 2012
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?
Subscribe to:
Posts (Atom)