Error when browsing Analysis services cube: “Logon failure: unknown user name or bad password”

Error when browsing Analysis services cube: “Logon failure: unknown user name or bad password”

Two articles describing the solution (work-around):

http://sqlblog.com/blogs/marco_russo/archive/2011/11/19/solving-security-issue-in-powerpivot-for-sharepoint-and-power-view.aspx

http://blog.brainlitter.com/2010/09/05/the-given-key-was-not-present-in-the-dictionarysharepoint-2010-error/

 

Analysis services


view report

Example: To View Report By URL

SQL Server report server provides a shortcut to view report directly by browser with an URL. This way a report could be viewed by varied applications and end user does not have to login to report manager to get report run.

To generate the URL of a report, follows this pattern:

http://<report server url>?/<report folder>/<report name>&Parameter1=Value1&Parameter2=Value2&rs:command=render&rc:Parameters=false…

(See a detailed reference for “rs” and “rc” command http://msdn.microsoft.com/en-us/library/ms155391.aspx)

Sample:

A trick for an OLAP report or the value of report parameters include a “&” character:

because the “&” character is reserved  in URL, so if any parameter or value contain “&” character, the browser will not explain it as a part of value, the report will not run or return wrong data. So we need to use javascript eacape function (when open a new window from the “Navidation” property of a report element):


ssrs

SSRS Reports not refreshing data when run in BIDS (Business Intelligence Development Studio)

SSRS Reports. I ran into a problem where changes to the data set I was making in one of my reports in BIDS were not being reflected in the data the report was returning. Found an interesting article about caching that BIDS does –

http://connect.microsoft.com/SQLServer/feedback/details/522670/ssrs-turn-off-local-data-cache-in-bids

http://blog.summitcloud.com/2010/05/disable-reporting-services-data-cache-in-development/