Reset your DeepSee cache in the DeepSee Shell
The DeepSee Shell Best Practices Series - Reset your DeepSee cache in the DeepSee Shell
This method is provided as a convenience for developers for use on development or test systems. You should not use this method on production systems as it will have immediate effect on the performance of end user operations.
- Stops all DeepSee background agents
- Clears any pending tasks
- Clears the result cache for the current namespace.
- If you use “reset 1”, then the cell cache for the current namespace is also cleared.
>>reset 0
** Stops all DeepSee background agents, clears any pending tasks, and clears the result cache for the current namespace.
>>reset 1
** Same as above plus cell cache for the current namespace.
After you reset cache, the query you just run might take a bit longer because the result is not cached until you run it the first time after cache reset.
>>stats off Stats are: off >>SELECT {[Measures].[%COUNT],[Measures].[Allergy Count],[MEASURES].[MEDIAN TEST SCORE]} ON 0,NON EMPTY HEAD(NONEMPTYCROSSJOIN([AgeD].[H1].[Age Group].Members,[AgeD].[H1].[Age Bucket].Members),2000) ON 1 FROM [PATIENTS] %FILTER [GenD].[H1].[Gender].&[Female] Patient Count Allergy Count Median Test Scor 1 0 to 29->0 to 9 69 45 73.50 2 0 to 29->10 to 19 74 47 75.50 3 0 to 29->20 to 29 80 56 68.00 4 30 to 59->30 to 3 82 43 77.00 5 30 to 59->40 to 4 75 49 75.00 6 30 to 59->50 to 5 58 43 68.00 7 60+->60 to 69 43 24 68.00 8 60+->70 to 79 24 16 70.50 9 60+->80+ 20 9 78.00 Elapsed time: .029869s >>reset 1 Query cache reset >>SELECT {[Measures].[%COUNT],[Measures].[Allergy Count],[MEASURES].[MEDIAN TEST SCORE]} ON 0,NON EMPTY HEAD(NONEMPTYCROSSJOIN([AgeD].[H1].[Age Group].Members,[AgeD].[H1].[Age Bucket].Members),2000) ON 1 FROM [PATIENTS] %FILTER [GenD].[H1].[Gender].&[Female] Patient Count Allergy Count Median Test Scor 1 0 to 29->0 to 9 69 45 @Computing 0.00% 2 0 to 29->10 to 19 74 47 @Computing 0.00% 3 0 to 29->20 to 29 80 56 @Computing 0.00% 4 30 to 59->30 to 3 82 43 @Computing 0.00% 5 30 to 59->40 to 4 75 49 @Computing 0.00% 6 30 to 59->50 to 5 58 43 @Computing 0.00% 7 60+->60 to 69 43 24 @Computing 0.00% 8 60+->70 to 79 24 16 @Computing 0.00% 9 60+->80+ 20 9 @Computing 0.00% Elapsed time: 3.768352s Results pending... Patient Count Allergy Count Median Test Scor 1 0 to 29->0 to 9 69 45 73.50 2 0 to 29->10 to 19 74 47 75.50 3 0 to 29->20 to 29 80 56 68.00 4 30 to 59->30 to 3 82 43 77.00 5 30 to 59->40 to 4 75 49 75.00 6 30 to 59->50 to 5 58 43 68.00 7 60+->60 to 69 43 24 68.00 8 60+->70 to 79 24 16 70.50 9 60+->80+ 20 9 78.00
The DeepSee Shell Best Practices Series
Run MDX queries in the DeepSee Shell
Get your MDX query performance stats from the DeepSee Shell
Reset your DeepSee cache in the DeepSee Shell
Execute an MDX query in the DeepSee Shell with/without results cache
Get your MDX query plan, MDX query trace and more from the DeepSee Shell