Khilit's Business Intelligence Blog

My experiences, views, learning, findings and amazing journey of Microsoft BI – SQL Server, SSAS, SSIS, SSRS, MDX, PowerPivot, C#.Net, Excel, SharePoint, VSTS and more.

• Home
• C Tree
• About Me

Browse an SSAS Cube using Excel – Automatic Setup done by SQL Server Data Tools

Hi All, Most of us; who are working on SQL BI solutions are aware of connecting SSAS Cube using Excel (as client) for browsing. Because we know that how much the clients/financial users likes to work with Excel In SQL 2012 RC0, there is one handy-dandy quick-link which enables us to make this whole functionality [...]

February 12, 2012 · Khilitchandra Prajapati · 2 Comments
Tags: Excel, Pivot Table, SQL Server 2012, SSAS Â· Posted in: Excel, New Features, Pivot Table, Quick Tips, SQL Server, SSAS

• Blog Stats

  38326 hits

• Recent Posts

  • MDX and DAX Query Formatter …. is back :)
  • Recover Backed-up query files in SQL Server Management Studio
  • Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT
  • The Story of Precision, Scale, and Length in SQL Server
  • Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query
  • MSSQL: Find total records of each Table in given Database
  • Microsoft SSAS Solution: Cube Design Considerations
  • User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
  • Quick Introduction – What is FileTable in SQL Server 2012 ?
  • Microsoft Business Intelligence at a Glance Poster – FREE

• Archives

  • May 2013 (2)
  • February 2013 (1)
  • January 2013 (5)
  • December 2012 (2)
  • September 2012 (3)
  • August 2012 (3)
  • June 2012 (5)
  • May 2012 (3)
  • April 2012 (7)
  • March 2012 (12)
  • February 2012 (30)
  • January 2012 (9)

• World Foot-prints

• SQL Server Pedia

  • Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT
  • The Story of Precision, Scale, and Length in SQL Server
  • MSSQL: Find total records of each Table in given Database
  • Fastest way to find-out/understand relationships between tables in MS SQL Database

• Author’s Information

  Khilitchandra V. Prajapati
  bigatoron