<Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
	<ObjectDefinition>
		<Database xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
			<ID>TestHTMLAction</ID>
			<Name>TestHTMLAction</Name>
			<ddl200:CompatibilityLevel>1100</ddl200:CompatibilityLevel>
			<Language>1033</Language>
			<Collation>Cyrillic_General_CI_AS</Collation>
			<DataSourceImpersonationInfo>
				<ImpersonationMode>Default</ImpersonationMode>
			</DataSourceImpersonationInfo>
			<Dimensions>
				<Dimension>
					<ID>testHTMLAction</ID>
					<Name>testHTMLAction</Name>
					<Source xsi:type="DataSourceViewBinding">
						<DataSourceViewID>local</DataSourceViewID>
					</Source>
					<UnknownMember>Visible</UnknownMember>
					<ErrorConfiguration>
						<KeyNotFound>ReportAndStop</KeyNotFound>
						<KeyDuplicate>ReportAndStop</KeyDuplicate>
						<NullKeyNotAllowed>ReportAndStop</NullKeyNotAllowed>
					</ErrorConfiguration>
					<Language>1033</Language>
					<Collation>Cyrillic_General_CI_AS</Collation>
					<UnknownMemberName>Unknown</UnknownMemberName>
					<Attributes>
						<Attribute>
							<ID>testHTMLAction</ID>
							<Name>testHTMLAction</Name>
							<Usage>Key</Usage>
							<KeyColumns>
								<KeyColumn>
									<DataType>Integer</DataType>
									<NullProcessing>UnknownMember</NullProcessing>
									<Source xsi:type="ColumnBinding">
										<TableID>nq_dim_testHTML</TableID>
										<ColumnID>id</ColumnID>
									</Source>
								</KeyColumn>
							</KeyColumns>
							<NameColumn>
								<DataType>WChar</DataType>
								<DataSize>8</DataSize>
								<Source xsi:type="ColumnBinding">
									<TableID>nq_dim_testHTML</TableID>
									<ColumnID>name</ColumnID>
								</Source>
							</NameColumn>
						</Attribute>
					</Attributes>
					<ProactiveCaching>
						<SilenceInterval>-PT1S</SilenceInterval>
						<Latency>-PT1S</Latency>
						<SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>
						<ForceRebuildInterval>-PT1S</ForceRebuildInterval>
						<Source xsi:type="ProactiveCachingInheritedBinding" />
					</ProactiveCaching>
				</Dimension>
			</Dimensions>
			<Cubes>
				<Cube>
					<ID>cube_testHTMLAction</ID>
					<Name>cube_testHTMLAction</Name>
					<Language>1033</Language>
					<Collation>Cyrillic_General_CI_AS</Collation>
					<Dimensions>
						<Dimension>
							<ID>testHTMLAction</ID>
							<Name>testHTMLAction</Name>
							<DimensionID>testHTMLAction</DimensionID>
							<Attributes>
								<Attribute>
									<AttributeID>testHTMLAction</AttributeID>
								</Attribute>
							</Attributes>
						</Dimension>
					</Dimensions>
					<MeasureGroups>
						<MeasureGroup>
							<ID>mg_testHTMLAction</ID>
							<Name>mg_testHTMLAction</Name>
							<Measures>
								<Measure>
									<ID>Value</ID>
									<Name>Value</Name>
									<DataType>Integer</DataType>
									<Source>
										<DataType>Integer</DataType>
										<Source xsi:type="ColumnBinding">
											<TableID>nq_mg_testHTML</TableID>
											<ColumnID>value</ColumnID>
										</Source>
									</Source>
								</Measure>
							</Measures>
							<StorageMode>Molap</StorageMode>
							<ProcessingMode>Regular</ProcessingMode>
							<Dimensions>
								<Dimension xsi:type="RegularMeasureGroupDimension">
									<CubeDimensionID>testHTMLAction</CubeDimensionID>
									<Attributes>
										<Attribute>
											<AttributeID>testHTMLAction</AttributeID>
											<KeyColumns>
												<KeyColumn>
													<DataType>Integer</DataType>
													<NullProcessing>UnknownMember</NullProcessing>
													<Source xsi:type="ColumnBinding">
														<TableID>nq_mg_testHTML</TableID>
														<ColumnID>id</ColumnID>
													</Source>
												</KeyColumn>
											</KeyColumns>
											<Type>Granularity</Type>
										</Attribute>
									</Attributes>
								</Dimension>
							</Dimensions>
							<Partitions>
								<Partition>
									<ID>Nq Mg Test HTML</ID>
									<Name>Nq Mg Test HTML</Name>
									<Source xsi:type="DsvTableBinding">
										<DataSourceViewID>local</DataSourceViewID>
										<TableID>nq_mg_testHTML</TableID>
									</Source>
									<StorageMode>Molap</StorageMode>
									<ProcessingMode>Regular</ProcessingMode>
									<ProactiveCaching>
										<SilenceInterval>-PT1S</SilenceInterval>
										<Latency>-PT1S</Latency>
										<SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>
										<ForceRebuildInterval>-PT1S</ForceRebuildInterval>
										<Source xsi:type="ProactiveCachingInheritedBinding" />
									</ProactiveCaching>
								</Partition>
							</Partitions>
							<ProactiveCaching>
								<SilenceInterval>-PT1S</SilenceInterval>
								<Latency>-PT1S</Latency>
								<SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>
								<ForceRebuildInterval>-PT1S</ForceRebuildInterval>
								<Source xsi:type="ProactiveCachingInheritedBinding" />
							</ProactiveCaching>
						</MeasureGroup>
					</MeasureGroups>
					<Source>
						<DataSourceViewID>local</DataSourceViewID>
					</Source>
					<Actions>
						<Action xsi:type="StandardAction">
							<ID>Action</ID>
							<Name>testHTMLAction</Name>
							<TargetType>AttributeMembers</TargetType>
							<Target>[testHTMLAction].[testHTMLAction]</Target>
							<Type>Url</Type>
							<Expression>
								//URL for test
								"https://www.sql.ru/forum/olap-dwh"
							</Expression>
						</Action>
					</Actions>
					<ProactiveCaching>
						<SilenceInterval>-PT1S</SilenceInterval>
						<Latency>-PT1S</Latency>
						<SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>
						<ForceRebuildInterval>-PT1S</ForceRebuildInterval>
						<Source xsi:type="ProactiveCachingInheritedBinding" />
					</ProactiveCaching>
				</Cube>
			</Cubes>
			<DataSources>
				<DataSource xsi:type="RelationalDataSource">
					<ID>local</ID>
					<Name>local</Name>
					<ConnectionString>Provider=SQLNCLI11.1;Data Source=(local);Integrated Security=SSPI</ConnectionString>
					<ImpersonationInfo>
						<ImpersonationMode>ImpersonateServiceAccount</ImpersonationMode>
					</ImpersonationInfo>
					<Timeout>PT0S</Timeout>
				</DataSource>
			</DataSources>
			<DataSourceViews>
				<DataSourceView>
					<ID>local</ID>
					<Name>local</Name>
					<DataSourceID>local</DataSourceID>
					<Schema>
						<xs:schema id="local" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
							<xs:element name="local" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
								<xs:complexType>
									<xs:choice minOccurs="0" maxOccurs="unbounded">
										<xs:element name="nq_dim_testHTML" msprop:IsLogical="True" msprop:FriendlyName="nq_dim_testHTML" msprop:DbTableName="nq_dim_testHTML" msprop:TableType="View" msprop:Description="" msprop:QueryDefinition="SELECT *       &#xD;&#xA;FROM (values(1, 'testHTML')) v(id, name)" msprop:QueryBuilder="GenericQueryBuilder">
											<xs:complexType>
												<xs:sequence>
													<xs:element name="id" msdata:ReadOnly="true" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:int" />
													<xs:element name="name" msdata:ReadOnly="true" msprop:DbColumnName="name" msprop:FriendlyName="name" minOccurs="0">
														<xs:simpleType>
															<xs:restriction base="xs:string">
																<xs:maxLength value="8" />
															</xs:restriction>
														</xs:simpleType>
													</xs:element>
												</xs:sequence>
											</xs:complexType>
										</xs:element>
										<xs:element name="nq_mg_testHTML" msprop:IsLogical="True" msprop:FriendlyName="nq_mg_testHTML" msprop:DbTableName="nq_mg_testHTML" msprop:TableType="View" msprop:Description="" msprop:QueryDefinition="SELECT *       &#xD;&#xA;FROM (values (1, 100)) v(id, value)" msprop:QueryBuilder="GenericQueryBuilder">
											<xs:complexType>
												<xs:sequence>
													<xs:element name="id" msdata:ReadOnly="true" msprop:DbColumnName="id" msprop:FriendlyName="id" type="xs:int" minOccurs="0" />
													<xs:element name="value" msdata:ReadOnly="true" msprop:DbColumnName="value" msprop:FriendlyName="value" type="xs:int" minOccurs="0" />
												</xs:sequence>
											</xs:complexType>
										</xs:element>
									</xs:choice>
								</xs:complexType>
								<xs:unique name="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
									<xs:selector xpath=".//nq_dim_testHTML" />
									<xs:field xpath="id" />
								</xs:unique>
							</xs:element>
							<xs:annotation>
								<xs:appinfo>
									<msdata:Relationship name="nq_mg_testHTML-nq_dim_testHTML" msdata:parent="nq_dim_testHTML" msdata:child="nq_mg_testHTML" msdata:parentkey="id" msdata:childkey="id" msprop:IsLogical="True" msprop:Description="" />
								</xs:appinfo>
							</xs:annotation>
						</xs:schema>
						<local xmlns="" />
					</Schema>
				</DataSourceView>
			</DataSourceViews>
		</Database>
	</ObjectDefinition>
</Create>

// URL for linking to MSN Maps
"http://maps.msn.com/home.aspx?plce1=" +

// Retreive the name of the current city
[Geography].[City].CurrentMember.Name + "," + 

// Append state-province name
[Geography].[State-Province].CurrentMember.Name + "," +

// Append country name
[Geography].[Country].CurrentMember.Name +

// Append region paramter 
"&regn1=" +

// Determine correct region paramter value
Case
    When [Geography].[Country].CurrentMember Is
         [Geography].[Country].&[Australia]
    Then "3"
    When [Geography].[Country].CurrentMember Is
         [Geography].[Country].&[Canada] 
         Or
         [Geography].[Country].CurrentMember Is
         [Geography].[Country].&[United States]
    Then "0"
    Else "1"
End 

// The "plce1" parameter represents a named location.
// The "regn1" parameter indicates the region in which 
// the named location is located.

// 0 = North America
// 1 = Europe
// 2 = World Atlas
// 3 = Australia
// 4 = Brazil