数据仓库mdx的使用 sql 2000 as

最新推荐文章于 2025-08-09 14:08:01 发布

overmind

最新推荐文章于 2025-08-09 14:08:01 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： sql 文章标签：数据仓库 sql filter

本文链接：https://blog.youkuaiyun.com/overmind/article/details/1017418

sql 专栏收录该内容

36 篇文章

订阅专栏

基本查询
with member [measures].[基站站名] as '[基站控制器_基站_小区].CurrentMember.Properties("基站载频数")'
member [measures].[基站] as '[基站控制器_基站_小区].CurrentMember.Properties("基站设备型号")'
select {[measures].[基站],[measures].[基站站名]} on columns,
{[基站控制器_基站_小区].[所有基站控制器_基站_小区].[成都BSC83].[BSS83:BSS83:SITE-1:]}on rows from Radio_cell

跨过一个hierachy的查询

select {[measures].[基站设备型号],[measures].[基站载频数]} on columns,

except(
     generate([基站控制器_基站_小区].members,
             {
                        descendants(
                                        [基站控制器_基站_小区].currentmember,
                                        [基站控制器_基站_小区].[基站],
                                        self_and_before
                        )
              }
),
{ [基站控制器_基站_小区].[基站控制器].members}
)
on rows
from Radio_cell

===========================================================

对行的集合进行filter筛选

with
member [measures].[基站载频数] as '[基站控制器_基站_小区].CurrentMember.Properties("基站载频数")'
member [measures].[基站设备型号] as '[基站控制器_基站_小区].CurrentMember.Properties("基站设备型号")'
member [measures].[基站所在地市州] as '[基站控制器_基站_小区].CurrentMember.Properties("基站所在地市州")'

select {
              [measures].[基站设备型号],
              [measures].[基站载频数],
              [measures].[基站所在地市州]

} on columns,

filter(
except(
     generate([基站控制器_基站_小区].members,
             {
                        descendants(
                                        [基站控制器_基站_小区].currentmember,
                                        [基站控制器_基站_小区].[基站],
                                        self
                        )
              }
),
{ [基站控制器_基站_小区].[基站控制器].members}
),
INSTR([基站控制器_基站_小区].currentMember.Properties("基站所在地市州"),"成都")<>0
)

on rows
from Radio_cell

===================================================

加了一个或的逻辑判断

select {
              [measures].[基站设备型号],
              [measures].[基站载频数],
              [measures].[基站所在地市州]

} on columns,

non empty
filter(
except(
     generate([基站控制器_基站_小区].members,
             {
                        descendants(
                                        [基站控制器_基站_小区].currentmember,
                                        [基站控制器_基站_小区].[基站],
                                        self
                        )
              }
),
{ [基站控制器_基站_小区].[基站控制器].members}
),
INSTR([基站控制器_基站_小区].currentMember.Properties("基站所在地市州"),"成都")<>0
or
INSTR([基站控制器_基站_小区].currentMember.Properties("基站所在地市州"),"巴中")<>0