SSAS- Clearing Cache

To measure the performance of the query. We need to clear the SSAS cache, because the recent result will be stored in the cache memory. So the MDX query will quickly return the result set. To find out the correct timing of the query run. We need to clear the cache. Following is the XMLA query, will just work on the MDX query window.

XMLA Query:

<Batch xmlns="http://schemas.Microsoft.com/analysis services/2003/engine">

   <ClearCache>

      <Object>

         <DatabaseID>Database ID</DatabaseID>

         <CubeID> Cube ID </CubeID>

      </Object>

   </ClearCache>

</Batch>

How to find the Database ID:

1. Click on the Analysis service database name
2. Click on the properties

We can use the same way to fetch the Cube ID from the Cube properties.

Thanks,

Gowdhaman

SSRS Parameter pattern validation

One of our client wanted to validate SSRS parameters.If parameter is “Non-Alphanumeric”, then we need to write the message saying that “You have entered the Non Alphanumeric data [Value entered in the parameter], which is invalid” We have achieved as follows. Otherwise report should return the data properly.

We have added the Text box in the SSRS report body and entered the following expression.

= IIF(Parameters!Param1.Value like "*[a-z][0-9]*" OR Parameters!Param1.Value like "*[0-9][a-z]*",string.Empty,string.Format("You have entered the Non Alphanumeric data [{0}], which is invalid",Parameters!Param1.Value))

Take a look at the following screenshot.

Thanks

Gowdhaman