Clear Cache and bug in Clearing Cache for partition

We can Clear Cache by using ClearCache command in XML for Analysis (XMLA)

for a specified Database, Cube, MeasureGroup ,dimension or partition.


Once we clear the cache analysis service will rebuild the cache

We can use this command to check performance testing of MDX Queries

Syntax for clear cache

<Command>

<ClearCache>

<Object>...Object>

ClearCache>

Command>

Clear Cache for Database

<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>Adventure Works DW 2008DatabaseID>

Object>

ClearCache>

Clear Cache for Cube

<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>Adventure Works DW 2008DatabaseID>

<CubeID>Adventure WorksCubeID>

Object>

ClearCache>

Clear Cache for Measure Group

<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>Adventure Works DW 2008DatabaseID>

<CubeID>Adventure WorksCubeID>

<MeasureGroupID>Fact Internet Sales 1MeasureGroupID>

Object>

ClearCache>

Clear Cache for Dimension

<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>Adventure Works DW 2008DatabaseID>

<DimensionID>Dim CustomerDimensionID>

Object>

ClearCache>

Clear Cache for partition

<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>Adventure Works DW 2008DatabaseID>

<CubeID>Adventure WorksCubeID>

<MeasureGroupID>Fact Internet Sales 1MeasureGroupID>

<PartitionID>Internet_Sales_2001PartitionID>

Object>

ClearCache>

This gives error

Errors in the metadata manager. The object with ID of 'Internet_Sales_2001', Name of 'Internet_Sales_2001' is of type 'partition' which does not support the requested operation.

But in BOOKS Online of SQL Server 2008

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10md_2devguide/html/afad5c39-d4c3-4307-b3b9-a06617da0028.htm

It says that we can clear cache of partition also , but while we try to clear partition cache it gives error.

It sounds me like a bug.

Cheers
Amish Shah

4 comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts