Partitions in SSAS with no data

If you get the error below when processing a cube in SSAS. You might have partitions in the cube, that doesn’t have corresponding data in the underlying relational tables.

Errors in the OLAP storage engine: The restrictions imposed on partition slice where violated.‏

A solution could be to just delete the affected partitions from the cube.

Using special national characters in unittests with NBI

First of all, if you have a .csv file containing the results that you want to compare with your test and the result contains special national characters, then you need to encode the file in Unicode before saving the file. You change the encoding in Notepad for Windows as shown below.

SaveUnicode

If your .mdx file with the test to perform contains national characters in Danish that could be the characters æ (ae), ø (oe) and å (aa). Then you have to translate them to these characters to make them work.

æ æ
Æ Ã†
ø ø
Ø Ã˜
å Ã¥
Å Ã…

More characters can be found here.

An example of and MDX-query with national characters for in .mdx file for unittesting in NBI would look like the query below.

 

Using Search Engine Optimization (SEO) Toolkit in ISS 8.5

The guide below will show you how to use the Search Engine Optimization Toolkit for IIS. The toolkit is built for IIS 7.0 and ISS 7.5, but it works in IIS 8.5. The problem is that you can’t follow the guides available for IIS 7.0 or 7.5.

When you have installed the toolkit and wants to use it, you should go to the Default Web Site and choose Search Engine Opt…

Unavngivet

Here it’s possible to Create a new analysis.

2Unavngivet

But it’s not possible to change the path away from http://localhost/ in IIS 8.5. Please comment, if you know how to do this.

3Unavngivet

What you can do is the following. Right click on Sites and choose Add Website

4Unavngivet

You will meet this screen.

5Unavngivet

You can enter the information below. But in the Host name (www.mysite.com) you should enter the site you want to check. And press OK, when you’re done.

6Unavngivet

Now you have a new site. Go to the new site (Test site) and choose Search Engine Opt…

7Unavngivet

Choose Create a new analysis

8Unavngivet

Now you can give the analysis a name.
The path has changed to http://www.mysite.com (or what ever you have entered) and is not http://localhost/.
When you have given the analysis a name, you can hit OK, and the analysis of the website starts.

10Unavngivet

Getting the CU for your SharePoint installation

The pages below shows you how to get information about the CU (Cumulative Update) for your SharePoint installation.

The first page shows you how to get information about the CU.
http://www.brightworksupport.com/find-your-sharepoint-cumulative-update-or-patch-level/

The second page shows you what CU you are using based on the information found through the first page.
http://blogs.technet.com/b/steve_chen/archive/2013/03/26/3561010.aspx

SAS crashes when you connect with RDP

If your SAS-session crashes when you connect with RDP to a server the root-cause could be a check that SAS does for available printers.

To avoid these crashes it is possible to set a parameter in the config-file for SAS. The main config-file for SAS is called SASv9.cfg and in SAS 9.2 it’s usually located in C:\Program Files\SAS\SASFoundation\9.2\nls\en.

The parameter you have to add to the config-file is:
-noqueryports

Disable fair sharing in Windows Server

The post below will show how to disable fair sharing of CPU, disk and network in Windows Server 2012/2012R2. The post relies on information found in here and here.
It’s possible to disable it directly in the Windows Registry with the program RegEdit.exe or using PowerShell commands. Both approaches will be shown.
Disclaimer: Do a backup of Windows Registry in RegEdit.exe (File -> Export, remember to choose Export Range = All) before doing these changes!

It’s possible to disable fair sharing of the CPU using Regedit.exe. You have to change the value EnableCPUQuota from 1 to 0 (zero). NB! You change it by double-clicking on EnableCpuQuota. This value can be found in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Quota Systemreg1

It’s possible to disable fair sharing of the disk using Regedit.exe. You have to change the value EnableFairShare from 1 to 0 (zero). This value can be found in
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TSFairShare\Disk

reg2

It’s possible to disable fair sharing of the network using Regedit.exe. You have to change the value EnableFairShare from 1 to 0 (zero). This value can be found in
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TSFairShare\NetFS

reg3

It is also possible to do this through PowerShell where you write the command below

This will give you a list of the settings for terminalservices as shown below. You are interested in EnableDFSS, EnableDiskFSS and EnableNetworkFSS. For some reason EnableNetworkFSS is not set here.

PSFairShare

To disable CPU fair sharing in PowerShell you write.

To disable disk fair sharing in PowerShell you write.

To disable network fair sharing in PowerShell you write.

Test network connection with ping

With the ping command it is possible to test a network connection

ping <HOST> -t –l 1000

Example ping 8.8.8.8 –t –l 1000 (8.8.8.8 is Googles public DNS-server)

If you run it from a command prompt in windows, it will look as below. The option -t will force the ping command to run until you stop it. It’s possible to stop it by pressing Ctrl-C on the keyboard. The -l option tells ping how many bytes to send with each ping, in this case it’s a 1000 bytes.pingIf you want the result of the test to be sent to a file you can send it to a file using the command below.

ping 8.8.8.8 –t –l 1000 > MyTestFile.txt

When the test is done you can look for Request Timeout in the output.