IsAggregatable Property – Analysis Service

Q:- I want to hide All in my dimension. How can I do it? Is it good to do it?

Ans:- In Analysis Service we generally see all dimension has All member. This is because of IsAggregatable property of the attribute. You can set its value to false, so that it will not show All member.

Its default member for that attribute. If you hide this member than you will have to set other attribute value to default member else it will pick some value as default and this will create confusion in browsing data if someone is not known to change in default member.

Its good to use it in ParentChild dimension where there is one root member in the hierarchy.

Problem with multilingual character in SSAS

Q:- I have multilingual keywords in my table. It contains keywords chinese/japanese/arabic and many other languages. When I create a dimension I cant see that characters , it shows box and question mark.

Ans.
You need to add language files for all related lanugages in your windows operating system.
Go to Control Panel-> Regional and Language Option

Go to Languages tab.

Go to supplement language option.
Select both two checkboxes click OK.

Windows will install files of all languages.

Now you can see data proper when you browse dimension

Memory properties in Analysis Service

Preallocate
It will allocated specified amount of memory to analysis service.By specifying preallocate Analysis Service uses large memory pages and we can not swap this to page file. It can give better performance to Analysis Service.

So we have to be cautious and also count required amount of memory to other applications before assigning values to it.Its ideal we should keep at least 20% of memory to system.
Service account for analysis service must have lock pages in memory privilege.

TotalMemoryLimit
If value is set to between 0 and 100 its counted as percentage else if its greater than 100 then its count as absolute value in bytes.
It had default value of 80%

LowMemoryLimit
If value is set to between 0 and 100 its counted as percentage else if its greater than 100 then its count as absolute value in bytes.
It has default value of 75%.

if server cross this limits it experience memory pressure. Depending on requirement of memory server feels various levels of pressure.It will start cleaner thread to clean memory depending upon pressure on the server

Levels of Memory Pressure

• When memory is in the specified range of TotalMemoryLimit and LowMemoryLimit there will no pressure

• When memory between LowMemoryLimit and TotalMemoryLimit cleaner will begin to clean memory. It will clean data from cache which is less used compare to highly used cache data

• If memory is greater than TotalMemoryLimit property, cleaner thread will clean the memory upto TotalMemoryLimit. If it can not release memory , it will try to cancel active requests. At this time we will feel various problem with analysis service related to performance.