.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Is a Dynamic Config Possible for SSAS BIDS Projects? (Data Source / Connection, and Deployment Targe

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

How do we automate SSAS Project configs such that (a) RDBMS data source server (connection) and (b) SSAS deployment target server are dynamic? 

As it stands, just before I script the ASDB (for deployment/promotion from Dev to QA, or QA to Prod, for example), I use BIDS designer interfaces to change the source connection and deployment targets, then script the ASDB. 

Is there a more dyamic alternative?  Perhaps something analogous to SSIS package configurations?  I can't believe that everybody is doing this as manually as I've done.

View Complete Post

More Related Resource Links

SSAS Deployment Wizard - Data Source connection string userid and Password getting removed



I have an SSAS database (Analysis Services 2005) which connects to Oracle for the data. I have the userid and password
saved in the connection string.


If I deploy the cube from Visual Studio I DON't have to manually edit the Data Source in the server to input the userid and password. The information is retained.


If I do a build and then deploy .asdatabase file using Deployment Wizard (Microsoft.AnalysisServices.Deployment.exe), the connection information dissappears. I have "Remove Passwords" = False in Project configuration. So when you build the project there will be a file with extension .assecurityinformation which holds the encrypted security info. Somehow

deployment wizard doesn't look at this file.


After the build I execute this command

Microsoft.AnalysisServices.Deployment.exe  .\Project.asdatabase /s:.\Deployment.log

I tried interactively and silent mode. Either way I cannot deploy the project with the userid and password in it.

Any clue?

Is it possible to have a dynamic data source

I am looking to develop a SSRS report, and the idea is that I want to view backup history on various DB servers. I would like to have a drop down list of servers, and from there I can choose a server and a query will run on that server. I have been trying to find out some information on this, but my understanding is that this can be done via URL, but not sure if thats the best way to do this. Thanks.

Adding source redirect code to end of a URL which used a dynamic data value

I'm trying to add some source redirect code to the end of a URL in a Data Form Web Part on a simple SharePoint aspx page. This is the basic url: /itservices/helpdesk/Lists/Service%20Requests/DispForm.aspx?ID={@ID} However I want to add a source redirect to the end of the URL so that it returns to a particular page rather than the list's default page. I have tried all of the following: /itservices/helpdesk/Lists/Service%20Requests/DispForm.aspx?ID={@ID}&source=/itservices/Pages/MyOverview.aspx That causes an error in the web part stating "This Web Part does not have a valid XSLT stylesheet: Error; A semi colon character was expected". I tried replacing the ampersand with the URL encoded character: /itservices/helpdesk/Lists/Service%20Requests/DispForm.aspx?ID={@ID}%26source=/itservices/Pages/MyOverview.aspx But when opening from this URL the form contains no data. What am I missing or can this not be done? Thanks.  

Deployment of shared data source/data set

Hi, Till SSRS 2008, while deploying reports from BIDS, even the data source is shared, the report deployment used to be successful with out any problem. In SSRS 2008 R2, what I have observed is that if there is a report that we are trying to deploy has a shared data source, then the data source needs to be deployed first. If we are not doing that, then the report deployment through BIDS fails giving an error that the data source is unavailable. Is this a change/enhancement in SSRS 2008 R2 or am I missing something critical? Request for experts advice on this. Regards,  Phani Note: Please mark the post as answered if it answers your question.

Errors in the high-level relational engine. A connection could not be made to the data source with t

When I deploy the cube which is sitting on my PC (local) the following 4 errors come up: Error 1 The datasource , 'AdventureWorksDW', contains an ImpersonationMode that that is not supported for processing operations.  0 0 Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'AdventureWorksDW'.  0 0 Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer', Name of 'Customer' was being processed.  0 0 Error 4 Errors in the OLAP storage engine: An error occurred while the 'Customer Alternate Key' attribute of the 'Customer' dimension from the 'Analysis Services Tutorial' database was being processed.  0 0

Cannot create a connection to data source !!!! SSRS 2005

I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group!  Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password.  I thought that since this datasource was set to Windows Authentification that it would just pass it through? I'm pulling my hair out at this point: Screen Shots: http://www.webfound.net/datasource_connection.jpg http://www.webfound.net/datasource_connection2.jpg http://www.webfound.net/datasource_connection3.jpg Also As far as I know, I've given sufficient permissions to the right logins and right users on my SQL Databases and related stored procs that the datasets (not datasource) run An error has occurred during report processing. Cannot create a connection to data source 'datasourcename'. For more information about this error navigate to the report server on the local server machine, or enable remote errors

REST Connection Data Source is getting overriddeen by SPD 2010

Hi, I used a Linked Datasource consist of two REST Connection Data Source with the credentials saving with the data source. The first time i add the Data View to the Web Part Zone everything is fine and the data is shown fine but the moment i save it and close the aspx page and open it again, SPD overrides and adds some of the attributes in the DataSources tag, which makes it giving an error saying connection problem and if i copy paste the original Datasource tag with the values it works fine. Any Idea guy's i am just fighting with this from 2 days. Thanks Girish

Data Source Connection Help


Hi Guys,


After the report deployment to http://XX-sql01/Reports/Pages/Report.aspx. When I click on report I am getting following error message. I checked all the data source connections and password everything seems to be ok.

Can anyone shed some light please.

  • The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)


Dynamic data source for Data Form Web Part



I am using a data form web part which is using a rest service to fetch data from the List. Now my List is having different Views, and i want depending on a certain parameter can we make the datasource to fetch data from different views.

Any help is highly appreciated.



SSAS 2008 - The OLAP data source has no property fields available for this dimension


Last week I was able to view member properties for my Product Dimension in Excel 2010 pivot tables. Suddenly, without having made any changes to the dimension (for example, in the Attribute Relationships window of the dimension), those member properties are no longer available in Excel. I get the error "The OLAP data source has no property fields available for this dimension" when I try to select "Show Properties in Report" or "Show Properties in Tooltips" in the Pivot Table. At the same time, member properties are available for all other dimensions. I have also not made any changes to the data source connection in Excel and in any event, there is no option in the data source connection to enable or disable member property visibility. I am using BIDS 2008 and SQL Server 2008 R2 (10.50.1600.1). Does anybody have an idea why this might be happening?


Cannot create a connection to data source ''


I copied an old report and changed the data sources. The report works fine in the designer and on the report server. But when I run it from the server on which the database is located it gives me the following error. Works fine when I use 'Store credentials in report server'. tried anonymous login too. Doesnt work.

  • An error has occurred during report processing.
    • Cannot create a connection to data source '<name of my datasource>'.
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors
      • Please help.     &nb

SSIS as data source in SSRS connection string


I have a connection string

="/f c:\test\test2\test2\package.dtsx /set \package.variables[User::varfil].Value;" & Parameters!varempid.Value

but its not returning any results. I need a valid connection string.

Get/Edit Data Source in connectioString in web.config



I have a webservice in which I have a connectionstring in the web.config. I read the connectionstring with the following code:

var section = ConfigurationManager.ConnectionStrings;
var test = section[2].ConnectionString;

This gives me the correct and whole connectionstring:

"metadata=res://*/EvalDBEntityDataModel.csdl|res://*/EvalDBEntityDataModel.ssdl|res://*/EvalDBEntityDataModel.msl;provider=System.Data.SqlClient;provider connection string=\"Data Source=MyMSSQLServerName;Initial Catalog=EvalDB;Integrated Security=True;MultipleActiveResultSets=True\""

I want a config surface to my client app where the admin user could modify DB server name in case... I don't want to put the whole connectionsrting to the config surface. I just want the DB server (Data Source) could be modifiable. How can I complete my code snippet to read the Data Source from the connectionstring? Shoul I modify the whole code snippet or can I extend this one?




Change Dynamic Data database connection string


I have recently started to learn Dynamic Data Web application.

I have built a Dynamic data Website with LINQ data access layer. When the LINQ data context was built over an existing SQL2005 database, the connection string for that database was correctly, automatically, placed into the Settings and .edmx Code for the project. It works, but it's a "static" connection string.

I would like to be able to use this one LINQ data access layer against both test and production databases without having to manually change and recompile the project's connection string each time.

Is there a way to pass/change the User connection string to the LINQ data access layer at Run Time so that destination database changes? Ot in Other words How can user can choose a database from a list of databases.


LINQ data source control and db connection string


I have designed a few pages which use LINQ datasources and Gridviews to maintain data.

I have built a data layer which happily uses System.Web.Configuration.WebConfigurationManager.ConnectionStrings("myConnectionString").ConnectionString

However, the LINQ data source controls use Settings.designer.vb MySettings class definition which is auto generated and doesn't except the above Connection string.

Any ideas?

SSAS with Teradata Oledb data source



    I am getting this error while creating a data source view(for creating a cube)  from Teradata.As you can see from the message,I am using Oledb Provider for Teradata.

  'TDOLEDB.1' failed with no error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21). (Microsoft Visual Studio)

Can someone help me, I have searched online for answers but could not find the solution.





How to connect OLAP data source WITHOUT using http connection


Hello Guys,

I used to connect my OLAP database with this connection strings :

"Data Source=http://<target IP>/olap/msmdpump.dll;Catalog=<cube name>;Impersonation Level=Anonymous;"


but somehow, it managed to be disconnected for some other reason... 

then, i try to not using HTTP connection...

""Data Source=<target IP>;Catalog=<cube name>;Impersonation Level=Anonymous;"


the result is, I cannot connect to my OLAP.. 

Any suggestion? I want to connect my OLAP without using HTTP connection...



Best Regards and Thanks,

Roland Andreas

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend