Dynameomics - MDX Queries

The SQL Query Language
The MDX Query Language
Sample Queries
- MDX Queries
- SQL Queries
Database Access link

Previous Query Next Query

Distance between two chosen atoms over a simulation

WITH MEMBER [ID].[Hierarchy].[ATM1] as '[ID].[Hierarchy].[structure].[1a2p-1].[1].[5]' MEMBER [ID].[Hierarchy].[ATM2] as '[ID].[Hierarchy].[structure].[1a2p-1].[2].[21]' MEMBER [Measures].[distance] as ' ( (([ID].[Hierarchy].[ATM2],[Measures].[x Coord])-([ID].[Hierarchy].[ATM1], [Measures].[x Coord]))^2 + (([ID].[Hierarchy].[ATM2],[Measures].[y Coord])-([ID].[Hierarchy].[ATM1], [Measures].[y Coord]))^2 + (([ID].[Hierarchy].[ATM2],[Measures].[z Coord])-([ID].[Hierarchy].[ATM1], [Measures].[z Coord]))^2 ) ^ 0.5' SELECT [Measures].[distance] on 0, [time].[1]:[time].[20000] on 1 FROM [dynameomics] WHERE ([Run].[1], [Temp].[498], [Conditions].[cs=.4,nbcycl=3,cor=8]);