次の方法で共有


SQL Business Intelligence

This blog contains a plethora of information spread across various aspects of troubleshooting commonly encountered issues with SQL BI Technologies.

This blog presents the Blog writer's own view and this posting is provided "AS IS" with no

Tabular: .Net Provider supported by Tabular Mode

  Yes, tabular server supports .Net Provider but only for those Data Sources which are...

Date: 09/10/2013

SQL 2012 TABULAR: Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services

Most Awaited Tabular Performance Tuning Paper is out…………. Applies to: SQL Server 2012 Summary:...

Date: 08/02/2013

Tabular: Error while using ODBC data source for Importing Data

Issue When using ODBC as a Data Source in the Table Import Wizard to add data to a Tabular Server,...

Date: 07/25/2013

Power View for Multidimensional Model is Finally Here

I am pretty excited about this feature with SQL 2012 SP1 Cumulative Update 4,  you can create...

Date: 06/03/2013

Terms: Data Warehouse and SSAS

  Data warehouse and ssas terms from Karan Gulati

Date: 04/29/2013

DAX: Using filter and summarize in same Query

In this SQL Query we are grouping Sales by Year and Color plus adding a filter of 5000 select...

Date: 04/29/2013

PowerShell:How to List Database Roles and their Members

1: [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") 2: $ServerName...

Date: 04/29/2013

HDInsight on Windows: Building PowerPivot Report from Hive in a Few Easy Steps (PDF)

Download Step by Step PDF from Slide Share HDInsight on Windows: Building PowerPivot Report from...

Date: 04/29/2013

SSAS Crashing Intermittently: Caused by Monitoring / AV Scans

Problem Description: Analysis Services is crashing intermittently and also producing min-dumps....

Date: 04/10/2013

Hardware Sizing a Tabular Solution (SQL Server Analysis Services)

Applies to: SQL Server 2012 Analysis Services, Tabular Solutions Summary: Provides guidance for...

Date: 01/11/2013

SSAS Synchronization: Across different versions

  Problem Statement: Synchronization between different builds or versions of Analysis Services....

Date: 10/24/2012

SSAS encryption

Description: Customer asking if AS supports TDE like encryption we got in SQL Engine. Solution: SSAS...

Date: 10/23/2012

SSAS Data Collection: Collecting Perfmon for SSAS

Applies to Windows7, Windows 2008/R2 and Vista SQL Server all builds >= SQL 2005 Generally, for...

Date: 10/01/2012

Getting Deadlock Error During Processing

Issue: Intermittently Getting below mentioned error during processing OLE DB error: OLE DB or ODBC...

Date: 09/27/2012

SSDT Query Builder: MDX Query returning NULL instead of AllMembers

  *SSDT – SQL Server Data Tools *SSMS – SQL Server Management Studio In SSDT Query Designer...

Date: 09/19/2012

Configuring: PowerPivot for Excel 2013

  For configuring PowerPivot in Excel 2013 you need to follow below mentioned steps: In Excel...

Date: 09/19/2012

How to use Network Monitor to capture network traffic

  Often I need to share these steps with customers while troubleshooting Connectivity issues,...

Date: 09/17/2012

Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

Power View implementation paper is out and covers major scenarios of implementing Power View with...

Date: 08/15/2012

  SSAS 2012 Links Free SQL 2012 EBook SQL 2012 Virtual Labs DAX in the BI Tabular Model...

Date: 08/06/2012

SSAS: All Possible Scenarios of Changing SSAS Data Folder

Title - All Possible Scenarios of Changing SSAS Data Directories Scenario 1: Recreating a New Data...

Date: 07/30/2012

XMLA– Clear Analysis Services (SSAS) database cache

How to clear cache of a cube <ClearCache...

Date: 04/26/2012

SSAS Tip - IndexBuildThreashold

<IndexBuildThreshold> Index creation is controlled by the number of rows, specified in the...

Date: 04/20/2012

Step by Step Guide of Installing Power View with PowerPivot 2012

Install Win 2008 R2 + SP1 Roles IIS Add .Net Framework 3.5 Features Features Add Desktop Experience...

Date: 04/19/2012

SSAS Cluster: Issue with Mount Points while Performing Administrative Tasks

  Issue: Environment consists of 2 nodes, SQL and SSAS 2008 can failover between the 2 nodes,...

Date: 11/29/2011

MDX Descendant Function

This example shows how to use Descendant function with Desc_Flag as self_before_after which means...

Date: 10/19/2011

Connecting Project Server with SQL Analysis Services from External Domain.

  Environment Domain A Server A - Project server and Web Server Server B- SQL Analysis Services...

Date: 09/12/2011

Excel Report was not passing right user id to SQL Server Analysis Services

Background: Windows 2003x64, SQL 2005 SSAS with Dimension Security Enabled In this scenario when we...

Date: 12/28/2010

Excel report with SSAS taking more time to refresh over Wan

We had seen scenarios where Excel Sheet with Pivot table takes less time locally but over Wan it...

Date: 12/28/2010

YTD Based on Current System Date (Now() Function), based on same date pulling value for Last Year too.

  In this example we are trying to pull ytd based on current date using Now Function.  ...

Date: 10/25/2010

Dealing with Slowly Changing Dimension using SSIS

Surrogate Keys Also known as meaningless keys, substitute keys, non-natural keys, or artificial...

Date: 10/02/2010

During ETL detecting dirty records from Fact

  Attribute Key Not found Error occurs in SSAS due to the following reasons : Dimensions...

Date: 10/02/2010

SQL Server Deployment Property (Retain Configuration Setting)

Well one of my customers had asked the as significance of this property as he didn’t find...

Date: 08/16/2010

How to Deal with Corruption in Analysis Services

  I had seen few scenario where you perform any action on Analysis Services you get weird Error...

Date: 08/11/2010

Migrating OLAP SSAS 2005 Database to SQL 2008

  This blog talks about different procedures of moving SSAS 2005 Databases to SQL 2008...

Date: 08/10/2010

Running AS Command(XMLA / MDX) as a Batch Job Using SSIS Package

  • Get ASCMD for right version 2008 2005 -Create a file with XMLA / MDX Command and give extension as...

Date: 07/17/2010