Business Intelligence,Technology, Thoughts, Thinking

Those of you who looked for pie chart in PowerPivot and could not find it, can fild it now. To use it, you should install SharePoint 2010 SP1 and Sql Server 2012 SP1. The steps for appropriate installation can be found here : http://msdn.microsoft.com/en-us/library/hh231687

A Visual Studio add-in with features that extend and enhance business intelligence development functionality in SQL Server 2005, 2008, and 2008 R2 BI Development Studio (BIDS) and SQL Server 2012 SQL Server Data Tools (SSDT).   It can be download from here: http://bidshelper.codeplex.com/releases/view/88092

1.       Configure SSL Connections on a Native Mode Report Server  http://msdn.microsoft.com/en-us/library/ms345223.aspx   2.       A full end to end SSO custom solution with in an application can be downloaded from here: http://code.msdn.microsoft.com/SQL-Reporting-Single-Sign-eace0073. a step by step can be found at cliff green's blog: http://blogs.msdn.com/b/cliffgreen/archive/2011/03/29/reporting-services-single-sign-on-sso-authentication-part-1.aspx     3.     Supported authentication types: All users or applications who request access to report server content or operations must be authenticated using the authentication type configured on the report server before access is allowed. The following table describes the authentication types supported by Reporting Services. AuthenticationType Name HTTP Authentication Layer...

   Supported authentication types:All users or applications who request access to report server content or operations must be authenticated using the authentication type configured on the report server before access is allowed. The following table describes the authentication types supported by Reporting Services.     AuthenticationType Name HTTP Authentication Layer value Used by default Description RSWindowsNegotiate Negotiate Yes Attempts to use Kerberos for Windows Integrated authentication first, but falls back to NTLM if Active Directory cannot grant a ticket for the client request to the report server....

To better run EXCEL against SQL 2012 SSAS, Please download the following: Microsoft® SQL Server® 2012 SP1 ADOMD.NET ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2012 SP1 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.Note:The English ADOMD.NET setup package installs support for all SQL Server 2012 languages. Filename: X86 and x64 Package(SQL_AS_ADOMD.msi)Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2012 SP1 The Analysis Services OLE...

  The designed behavior in SSIS is to prevent storing passwords in a package, because it's bad practice/not safe to do so. Instead, either use Windows auth, so you don't store secrets in packages or config files, or, if that's really impossible in your environment (maybe you have no Windows domain, for example) then you have to use a workaround as described in http://support.microsoft.com/kb/918760 .The simplest answer is a config file to go with the package, but then you have to worry that the config file is stored securely so someone can't just read it and take the credentials....

Local cube files have an extension of .cub. We can open the SSMS and open a new mdx query editor window. Then we will create a GLOBAL CUBE query. This is a strange thing. Although the query uses CREATE GLOBAL CUBE, but it is in fact known as local cube or offline cube. Code Snippet CREATE GLOBAL CUBE STORAGE 'C:\Documents and Settings\bcsmith\My Documents\Adventure Works.cub' FROM ( MEASURE ., MEASURE ., MEASURE ., MEASURE ., DIMENSION .., DIMENSION .., DIMENSION [Adventure...

Microsoft SQL Server, had a provision to add remote servers until SQL Server 2008 R2. From Microsoft SQL Server 2012, this functionality is now deprecated, and we now need to add "linked” servers instead. If a user does attempt to use the sp_addserver syntax to add a remote server, system will result in the following error: Msg 15663, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 60Feature "sp_addserver" is no longer supported. Replace remote servers by using linked servers. The solution is to use the sp_addlinkedserver system stored procedure, using which the script would require changes as under: ...

sp_addlinkedserver (Transact-SQL) Creates a linked server. A linked server allows for access to distributed, heterogeneous queries against OLE DB data sources. After a linked server is created by usingsp_addlinkedserver, distributed queries can be run against this server. If the linked server is defined as an instance of SQL Server, remote stored procedures can be executed. Syntax sp_addlinkedserver 'server' 'product_name' ]      'provider_name' ]      'data_source' ]      'location' ]      'provider_string' ]      [ , [ @catalog=...

The SQL Server Native Client (SQLNCLI11) that ships with SQL Server 2012 does not support connections to SQL Server 2000 an earlier. I found this out during testing of our upgrade to SQL 2012. We upgraded our 2008 R2 servers in-place and it appears to have left the SQLNCLI10 provider in place but if you did a fresh install of SQL Server 2012 on a new server you may not have this provider. Does your 2012 server have the SQLOLEDB provider listed under Linked Server Providers in SSMS? If so, you could try using that.   Issue ...