SQL BI

My Experience - Troubleshooting SQL BI Stack

Browse by Tags

Tagged Content List
  • Blog Post: XMLA– Clear Analysis Services (SSAS) database cache

    How to clear cache of a cube <ClearCache xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine "> <Object> <DatabaseID>Adventure Works DW</DatabaseID> <CubeID>Adventure Works DW</CubeID> </Object> </ClearCache>   How to clear...
  • Blog Post: SSAS Tip - IndexBuildThreashold

    <IndexBuildThreshold> Index creation is controlled by the number of rows, specified in the msmdsrv.ini (default location of msmdsrv.ini file – ?: \Program Files\Microsoft SQL Server\MSAS10_50.SQL2008R2\OLAP\Config\msmdsrv.ini ) file as <IndexBuildThreshold>, with a default of 4096. Partitions...
  • Blog Post: Different Kinds of SSAS Processing in simple words…..

    Often time I been asked this quest - what will be the impact of processadd on indexes or aggregations, do I need to recreate aggregations or Indexes after creating Process Update or what is the right approach of handling processing, so thought of writing this article. Here are the major Process Types...
  • Blog Post: 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 anything on net so thought of writing an article about it. Retain Configuration Setting: Will retain all properties of Connection String except Password. Project which you want to deploy, have SQL DB Server...
  • Blog Post: Migrating OLAP SSAS 2005 Database to SQL 2008

    Well one of my peer from Consulting team had asked this question tried looking for MSDN article but not find any so thought of writing it to my blog: Question: How to Migrate Database from SQL 2005 to SQL 2008 Scenario 1 - Moving SSAS Databases from SQL 2005 SSAS to another Server where we have...
  • Blog Post: 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 xmla/mdx -Create one batch file with command text as "d:\asjob\ascmd -S karan2k8-64\sql2005 -i d:\asjob\backup.xmla" In my instance- ASCMD is located in D Drive ASJob folder that’s...
  • Blog Post: SSAS Profiler Scheduler

    I have been asked by many customers and seen in many social sites, many people were asking about the procedure of scheduling SSAS profiler traces so one fine day thought of writing a utility. I have developed a small app which will help in scheduling SSAS Profiler Tracing using predefined Trace Template...
  • Blog Post: Moving Data Directory of Analysis Services (SQL 2005 / 2008)

    Applies to (Data,Backup,Log & Temp) You cant move Bin and Config Directory Manually, recommended way is Re-Insallation Here are the steps: From GUI: Start Microsoft SQL Server Management Studio, Connect to Analysis Services Server Right mouse click on server name, then choose properties...
  • Blog Post: Why do we need SPN for File Server (NAS / RAS / File Share System) DNS Alias (Cname)

    Very often we use UNC location while taking backup of SQL or Analysis Services Database or try to upload data in SQL Tables using bulk load command where text or csv file located in File Server so we access it by giving UNC. Sometimes File Server Machine (NAS / RAS or a computer where we have a shared...
  • Blog Post: SQL 2005 (SQL 2008) Analysis Services Server Side Tracing

    With Analysis Services 2005 (2008) you can collect traces without using gui this feature is known as Server Side Tracing. In this article we’ll talk about how to achieve Server Side Tracing. How to create a Server Side Trace Open SQL Server profiler connect to Analysis Services and...
  • Blog Post: How to Warm AS Cache using SSIS Package

    By following below mentioned steps we can warm AS Cache using SSIS Package by using Process Execute & Analysis Services Execute DDL Task -You need to get ascmd for SQL 2008 Analysis Services ( http://www.codeplex.com/MSFTASProdSamples ) or if you want to warm cache for SQL 2005 then you need to...
  • Blog Post: Tampering master.vmp file may result in losing all Analysis Services Databases

    The master.vmp file is the master version map that contains the GUIDS for all of the objects and the version of each object that currently exists on the server. When the server starts, it looks at the master.vmp file and attempts to find each of the objects referenced in the file. If there are...
  • Blog Post: SQL Server Analysis Services Port (SQL 2005 / 2008)

    Default Port:2383 You can change default Port for AS in msmdsrv.ini file of the Instance. Port Used by SQL Server Browser Services for SSAS is 2382 How to determine on which port AS is running? -Open Task Manager Get the PID for msmdsrv.exe -Open command Prompt type netstat /ao >>c...
  • Blog Post: SQL 2005 SPN (SSAS/SSRS/SQL)

    What is SPN? An SPN is a unique identifier for a service on a network that uses Kerberos authentication. It consists of a service class, a host name, and a port. On a network that uses Kerberos authentication, an SPN for the server must be registered under either a built-in computer account (such...
  • Blog Post: SSAS(64 Bit) and Oracle Client Issues

    While trying to create an Analysis Service Data Source that connects to Oracle using ORAOLEDB Provider, you get an error – TITLE: Connection Manager Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specified BUTTONS: Environment...
  • Blog Post: SSAS Performance Counter Error while collecting BLG file Reference error message: Access is denied.

    While Creating BLG file for SSAS counters getting below mentioned error message: System Log: Event Type: Error Event Source: SideBySide Event Category: None Event ID: 59 Date: 12/1/2008 Time: 1:52:35 AM User: N/A Computer: DBANALYSIS01 Description: Generate Activation Context failed for d:\Program...
  • Blog Post: Configuring Datapump in IIS 7

    Configuring HTTP Access to SQL Server 2005 or SQL 2008 Analysis Services on Microsoft Windows Server 2008 Getting Binaries Copy the contents of the %Installation folder%\OLAP\bin\isapi directory into the folder you would like to become the base for the virtual directory in IIS. In this example, we...
Page 1 of 1 (17 items)