SSAS 2005/08

CLEAR CACHE - SSAS:
<ClearCache xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>DATABASE</DatabaseID>
</Object>
</ClearCache>

UPDATE IN SSAS:

--BEGIN TRANSACTION

UPDATE CUBE [Adventure Works]
SET ([Date].[Calendar].[Calendar Quarter].&[2003]&[1]
,[Employee].[Employees].&[284]
,[Sales Territory].[Sales Territory].[Country].&[Canada]
,[Measures].[Sales Amount Quota] ) = 7704

--COMMIT TRANSACTION

/*
SELECT ([Date].[Calendar].[Calendar Quarter].&[2003]&[1]
,[Employee].[Employees].&[284]
,[Sales Territory].[Sales Territory].[Country].&[Canada]
,[Measures].[Sales Amount Quota]) on 0
FROM [Adventure Works]
*/

Networking, Linux

How to change the computer name?

1. Open and edit /etc/hosts

[IP] name

2. open and edit: /etc/sysconfig/network,
in debian should be: /etc/hostname

HOSTNAME="name"

3. Execute:

hostname name

4. Restart and check with the following command:
uname -a

Share your internet connection

1. Execute
modprobe iptable_nat iptables -t nat -A POSTROUTING -s 192.168.0.5/24 -o eth0 -j MASQUERADE

2. Execute
echo 1 > /proc/sys/net/ipv4/ip_forward