寻找MDX查询解决方案 [英] Looking for MDX query solution

问题描述

我使用MDX查询从SQL Analysis Service会话中获取数据库列表，但我不知道如何编写MDX查询。

我将如何执行以下操作： -

从$ system.DBSCHEMA_CATALOGS中选择*

其中CATALOG_NAME喜欢'％_15％'



注意第一行工作，但是当我添加where子句时它没有。



PS：我不希望将来需要编写任何其他MDX查询，所以我真的不想学习如何编写MDX查询，通过教程等。我只是在寻找这个查询的解决方案。



FYI，the查询的第一部分返回如下数据（中间2个字段为空）： -



select * from $ system.DBSCHEMA_CATALOGS



CATALOG_NAME描述ROLES DATE_MODIFIED

Australia_DB_F1_Daily_Gap_FX_Base_151207090409 12/06/2015 22:04



什么我试过了：


从$ system.DBSCHEMA_CATALOGS中选择*

其中CATALOG_NAME喜欢'％_15％'

I use an MDX Query to get a list of Databases from a SQL Analysis Service session, but I don't know how to write MDX queries.
How would I do something like the following :-
select * from $system.DBSCHEMA_CATALOGS
where CATALOG_NAME like '%_15%'

Note the first line works, but when I add the where clause it doesn't.

PS: I don't expect to need to write any other MDX queries in the future, so am not really looking to learn how to write MDX queries, via tutorials, etc. I am just looking for a solution to this one query.

FYI, the first part of the query returns data like the following (the middle 2 fields are empty) :-

select * from $system.DBSCHEMA_CATALOGS

CATALOG_NAME DESCRIPTION ROLES DATE_MODIFIED
Australia_DB_F1_Daily_Gap_FX_Base_151207090409 12/06/2015 22:04

What I have tried:

select * from $system.DBSCHEMA_CATALOGS
where CATALOG_NAME like '%_15%'

推荐答案

system.DBSCHEMA_CATALOGS

其中CATALOG_NAME喜欢'％_15％'



注意第一行是有效的，但是当我添加时它没有的where子句。



PS：我不希望将来需要编写任何其他MDX查询，所以我真的不想学习如何编写MDX查询，通过教程等。我只是在寻找这个查询的解决方案。



FYI，查询的第一部分返回数据，如以下（中间2个字段为空）： -



select * from

system.DBSCHEMA_CATALOGS
where CATALOG_NAME like '%_15%'

Note the first line works, but when I add the where clause it doesn't.

PS: I don't expect to need to write any other MDX queries in the future, so am not really looking to learn how to write MDX queries, via tutorials, etc. I am just looking for a solution to this one query.

FYI, the first part of the query returns data like the following (the middle 2 fields are empty) :-

select * from

system.DBSCHEMA_CATALOGS



CATALOG_NAME描述ROLES DATE_MODIFIED

Australia_DB_F1_Daily_Gap_FX_Base_151207090409 12/06/2015 22:04



我尝试过：



select *来自

system.DBSCHEMA_CATALOGS

CATALOG_NAME DESCRIPTION ROLES DATE_MODIFIED
Australia_DB_F1_Daily_Gap_FX_Base_151207090409 12/06/2015 22:04

What I have tried:

select * from

system.DBSCHEMA_CATALOGS

其中CATALOG_NAME喜欢'％_ 15％'

system.DBSCHEMA_CATALOGS
where CATALOG_NAME like '%_15%'

这篇关于寻找MDX查询解决方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！