函数
|
描述
|
返回在多维数据集的指定计算传递上对 MDX 表达式求得的值。
| |
|
with
member
measures.test
as
'
CalculationPassValue
(
membertostr
([sales average]) , -1, RELATIVE)'
select
{measures.test, [sales average] }
on
columns
, { [Time]
.allmembers
}
on
rows
from
Sales
上面的语句按理是对的,但不能运行!待改!
|
将空单元值合并为字符串或数字。
| |
|
with
member
measures.test
as
'
CoalesceEmpty
(Time
.currentmember.Parent.Name
,
"EMPTY"
)'
select
{measures.test }
on
columns
, {time
.allmembers
}
on
rows
from
Sales
能运行但不是预想效果
|
返回通过在集合上对字符串表达式计算而创建的连锁字符串。
| |
|
看上面的
|
返回由逻辑测试确定的两个字符串或数值之一。
| |
|
with
member
measures.test
as
'
iif
(
isempty
(Time
.currentmember.Parent
) ,
"EMPTY"
,
"exist"
)'
select
{measures.test }
on
columns
, {time
.allmembers
}
on
rows
from
Sales
|
返回在同一数据库中另外一个指定的多维数据集上对 MDX 表达式求得的值。
| |
|
看上面的
|
从某个成员构造一个字符串。
| |
|
with
member
measures.test
as
'
MemberToStr
([store Sales]) '
select
{measures.test }
on
columns
,
{ [Time]
.allmembers
}
on
rows
from
Sales
|
返回维度、层次结构、级别或成员的名称。
| |
|
略
|
返回包含成员属性值的字符串。
| |
|
with
member
measures.test
as
'store
.currentmember.Properties
(
"Store Manager"
) '
select
{measures.test }
on
columns
,
{
Descendants
([Store].[All Stores].[USA],[Store].[Store Name])}
on
rows from
Sales
|
用集合构造一个字符串。
| |
|
select
{measures.[store sales] }
on
columns
,
{
strtoset
(
SetToStr
({[Time].[1997], [Time].[1998]}))}
on
rows
from
Sales
|
用元组构造一个字符串。
| |
|
with
member
[measures].[TupleToStr]
as
'
TupleToStr
(([Measures].[Sales Count], [Store].[All Stores].[USA])) '
SELECT
{ [measures].[TupleToStr] }
ON
COLUMNS
, [Store]
.allmembers
ON
rows
from
sales
|
返回维度、级别或成员的唯一名称。
| |
|
略
|
返回当前连接的域名和用户名。
| |
|
with
member
measures.test
as
'
username
'
select
{ measures.test }
on
columns
,
{ [Time].[1997], [Time].[1998]}
on
rows
from
Sales
|
函数
|
描述
|
返回迭代过程中集合中的当前元组。
| |
|
with
set
kkk
as
'{{[Time].[1997], [Time].[1998]}*{[Store].[All Stores].[Canada],[Store].[All Stores].[USA]} }'
member
measures.jjj
as
'
TupleToStr
(kkk
.current
)',
solve_order
=1
select
{ measures.[store sales],measures.jjj }
on
columns
,
{kkk}
on
rows
from
Sales
待改!找不到current的用途!
|
从集合中返回元组。
| |
|
with
set
kkk
as
'{{[Time].[1997], [Time].[1998]}*{[Store].[All Stores].[Canada],[Store].[All Stores].[USA]} }'
member
measures.jjj
as
'
TupleToStr
(kkk
.item
(0)
.item
(0))',
solve_order
=1
select
{ measures.[store sales],measures.jjj }
on
columns
,
{kkk}
on
rows
from
Sales
|
用字符串构造一个元组。
| |
|
with
member
measures.jjj
as
'
StrToTuple
(
"([store Sales], "
+time
.currentmember.uniquename
+
")"
)',
solve_order
=1
select
{ measures.jjj }
on
columns
,
{time
.allmembers
}
on
rows
from
Sales
|