A simple example filtering all cities containing an "ar" string
Query
Filter( [Geography].[City].members as s, PatternMatches( ".*ar.*", s.currentmember.name ) )
Result
{
[Geography].[Geo].[City].[Caracas],
[Geography].[Geo].[City].[Paris],
[Geography].[Geo].[City].[Barcelona]
}
Assertion : MDX Equals
{[Geography].[City].[Caracas],[Geography].[City].[Paris],[Geography].[City].[Barcelona]}
Assertion : MDX Equals
Filter( [Geography].[City].members as s, s.currentmember.name.contains("ar") )
A simple example filtering all cities containing an "ar" string
Query
Filter( [Geography].[City].members as s, s.currentmember.name.contains("ar") )
Result
{
[Geography].[Geo].[City].[Caracas],
[Geography].[Geo].[City].[Paris],
[Geography].[Geo].[City].[Barcelona]
}
Assertion : MDX Equals
{[Geography].[City].[Caracas],[Geography].[City].[Paris],[Geography].[City].[Barcelona]}
Assertion : MDX Equals
Filter( [Geography].[City].members as s, PatternMatches( ".*ar.*", s.currentmember.name ) )
A simple example checking if a number isNan (is not a number)
Query
WITH
MEMBER [Measures].[isNan] AS isNaN( 0.0 / 0.0 )
SELECT
{[Measures].[isNan]} ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[isNan] AS true
SELECT
{[Measures].[isNan]} ON 0
FROM
[Sales]
A simple example checking if a number is infinite
Query
WITH
MEMBER [Measures].[isNan] AS IsInfinity( 1.0 / 0.0 )
SELECT
{[Measures].[isNan]} ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[isNan] AS true
SELECT
{[Measures].[isNan]} ON 0
FROM
[Sales]
An example to convert a String to a data using a specific format
Query
WITH
MEMBER [Measures].[isDate] AS StringToDate("4/6/2001","d/M/yyyy")
SELECT
{[Measures].[isDate]} ON 0
FROM
[Sales]
Result
| isDate |
| 2001-06-04T00:00:00.000 |
Assertion : MDX Equals
WITH
MEMBER [Measures].[isDate] AS StringToDate("6/4/2001","M/d/yyyy")
SELECT
{[Measures].[isDate]} ON 0
FROM
[Sales]
An example how to build a date
Query
WITH
MEMBER [Measures].[isDate] AS DateTime(2001,6,4)
SELECT
{[Measures].[isDate]} ON 0
FROM
[Sales]
Result
| isDate |
| 2001-06-04T00:00:00.000 |
Assertion : MDX Equals
WITH
MEMBER [Measures].[isDate] AS StringToDate("4/6/2001","d/M/yyyy")
SELECT
{[Measures].[isDate]} ON 0
FROM
[Sales]