SELECT *
FROM SYSTEMRESTRICTSCHEMA($system.discover_partition_stat
,DATABASE_NAME = 'hello world'
,CUBE_NAME = 'hello world'
,MEASURE_GROUP_NAME = 'Views'
,PARTITION_NAME='20120101'
)
如何编写模糊查询,比如:partition_name like '%2012%'
------解决方案--------------------
微软BI 模糊查询: MDX 类似SQL查询中的Like的用法, 该如何写MDX代码? http://www.flybi.net/question/553 模糊查询的,参考下这个
------解决方案--------------------
参考 http://www.bidn.com/blogs/ChrisAlbrektson/bidn-blog/1293/how-to-use-a-like-operator-in-mdx