文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >MDX查询已执行了很长时间

问MDX查询已执行了很长时间
EN

Stack Overflow用户
提问于 2017-02-13 22:47:53
回答 2查看 33关注 0票数 2

我有一个MDX-query：

代码语言：javascript
复制
SELECT
{[Measures].[Count of Tickets], [Measures].[Ticket Average Per Day]} ON COLUMNS,
{[Specification].[Specification].Members} ON ROWS
FROM [Tickets Star Schema]
WHERE
({Filter([Creation Date].[Day].Members, [Creation Date].[Day].CurrentMember.Name >= '2017/02/06' AND [Creation Date].[Day].CurrentMember.Name <= '2017/02/13')} * ({[Ticket Type].[Ticket Type].[9145452713113549283], [Ticket Type].[Ticket Type].[9134488303913230171], [Ticket Type].[Ticket Type].[9138837241613081595], [Ticket Type].[Ticket Type].[9138836630013081453], [Ticket Type].[Ticket Type].[9134833380413407058], [Ticket Type].[Ticket Type].[9145452713113549281], [Ticket Type].[Ticket Type].[9134911151013454609], [Ticket Type].[Ticket Type].[9134783010613387189], [Ticket Type].[Ticket Type].[9134783010613387187], [Ticket Type].[Ticket Type].[9138837241613081613], [Ticket Type].[Ticket Type].[9134654662613285455], [Ticket Type].[Ticket Type].[9140432570013809078], [Ticket Type].[Ticket Type].[9145452972713549451], [Ticket Type].[Ticket Type].[9140432570013809076], [Ticket Type].[Ticket Type].[9138836630013081428], [Ticket Type].[Ticket Type].[9145452972713549453], [Ticket Type].[Ticket Type].[9145452972713549455], [Ticket Type].[Ticket Type].[9145452972713549457], [Ticket Type].[Ticket Type].[9145452972713549459], [Ticket Type].[Ticket Type].[9145609457713578112], [Ticket Type].[Ticket Type].[9134792932413392960], [Ticket Type].[Ticket Type].[9134833277313407014], [Ticket Type].[Ticket Type].[9134792932413392962], [Ticket Type].[Ticket Type].[9134911151013454617], [Ticket Type].[Ticket Type].[9134911151013454615], [Ticket Type].[Ticket Type].[9138836630013081446], [Ticket Type].[Ticket Type].[9145452713113549279], [Ticket Type].[Ticket Type].[9145452713113549277], [Ticket Type].[Ticket Type].[9138837241613081620], [Ticket Type].[Ticket Type].[9145452713113549275], [Ticket Type].[Ticket Type].[9139560292713345110], [Ticket Type].[Ticket Type].[9145609457713578108], [Ticket Type].[Ticket Type].[9134654662613285461], [Ticket Type].[Ticket Type].[9134654662613285463], [Ticket Type].[Ticket Type].[9139560292713345112], [Ticket Type].[Ticket Type].[9145609457713578106], [Ticket Type].[Ticket Type].[9134792932413392958], [Ticket Type].[Ticket Type].[9134488303913230179], [Ticket Type].[Ticket Type].[9135138327113743686], [Ticket Type].[Ticket Type].[9134783010613387181], [Ticket Type].[Ticket Type].[9134488303913230177]}))

我有一个聚合表，由mondrian在执行查询时使用。但是这个查询执行的时间太长了！当我减少“票证类型”过滤器的计数时，查询执行得更快！请解释一下原因。

mdx
mondrian
EN

回答 2

Stack Overflow用户

发布于 2017-02-14 16:04:04

交叉连接并不是内存开销很大的操作。尝试将"*“替换为"，”：

代码语言：javascript
复制
SELECT
{[Measures].[Count of Tickets], [Measures].[Ticket Average Per Day]} ON COLUMNS,
{[Specification].[Specification].Members} ON ROWS
FROM [Tickets Star Schema]
WHERE
({Filter([Creation Date].[Day].Members, [Creation Date].[Day].CurrentMember.Name >= '2017/02/06' AND [Creation Date].[Day].CurrentMember.Name <= '2017/02/13')}, ({[Ticket Type].[Ticket Type].[9145452713113549283], [Ticket Type].[Ticket Type].[9134488303913230171], [Ticket Type].[Ticket Type].[9138837241613081595], [Ticket Type].[Ticket Type].[9138836630013081453], [Ticket Type].[Ticket Type].[9134833380413407058], [Ticket Type].[Ticket Type].[9145452713113549281], [Ticket Type].[Ticket Type].[9134911151013454609], [Ticket Type].[Ticket Type].[9134783010613387189], [Ticket Type].[Ticket Type].[9134783010613387187], [Ticket Type].[Ticket Type].[9138837241613081613], [Ticket Type].[Ticket Type].[9134654662613285455], [Ticket Type].[Ticket Type].[9140432570013809078], [Ticket Type].[Ticket Type].[9145452972713549451], [Ticket Type].[Ticket Type].[9140432570013809076], [Ticket Type].[Ticket Type].[9138836630013081428], [Ticket Type].[Ticket Type].[9145452972713549453], [Ticket Type].[Ticket Type].[9145452972713549455], [Ticket Type].[Ticket Type].[9145452972713549457], [Ticket Type].[Ticket Type].[9145452972713549459], [Ticket Type].[Ticket Type].[9145609457713578112], [Ticket Type].[Ticket Type].[9134792932413392960], [Ticket Type].[Ticket Type].[9134833277313407014], [Ticket Type].[Ticket Type].[9134792932413392962], [Ticket Type].[Ticket Type].[9134911151013454617], [Ticket Type].[Ticket Type].[9134911151013454615], [Ticket Type].[Ticket Type].[9138836630013081446], [Ticket Type].[Ticket Type].[9145452713113549279], [Ticket Type].[Ticket Type].[9145452713113549277], [Ticket Type].[Ticket Type].[9138837241613081620], [Ticket Type].[Ticket Type].[9145452713113549275], [Ticket Type].[Ticket Type].[9139560292713345110], [Ticket Type].[Ticket Type].[9145609457713578108], [Ticket Type].[Ticket Type].[9134654662613285461], [Ticket Type].[Ticket Type].[9134654662613285463], [Ticket Type].[Ticket Type].[9139560292713345112], [Ticket Type].[Ticket Type].[9145609457713578106], [Ticket Type].[Ticket Type].[9134792932413392958], [Ticket Type].[Ticket Type].[9134488303913230179], [Ticket Type].[Ticket Type].[9135138327113743686], [Ticket Type].[Ticket Type].[9134783010613387181], [Ticket Type].[Ticket Type].[9134488303913230177]}))
票数 0
EN

Stack Overflow用户

发布于 2017-02-14 18:44:32

将Where子句替换为以下子句：

过滤是一项非常繁重的操作，你可以用一个范围(：)

代码语言：javascript
复制
WHERE
(
    {
        [Creation Date].[Day].[2017/02/06]:[Creation Date].[Day].[2017/02/13]
    },  
    {
        [Ticket Type].[Ticket Type].[9145452713113549283], 
        [Ticket Type].[Ticket Type].[9134488303913230171], 
        [Ticket Type].[Ticket Type].[9138837241613081595], 
        [Ticket Type].[Ticket Type].[9138836630013081453], 
        [Ticket Type].[Ticket Type].[9134833380413407058], 
        [Ticket Type].[Ticket Type].[9145452713113549281], 
        [Ticket Type].[Ticket Type].[9134911151013454609], 
        [Ticket Type].[Ticket Type].[9134783010613387189], 
        [Ticket Type].[Ticket Type].[9134783010613387187], 
        [Ticket Type].[Ticket Type].[9138837241613081613], 
        [Ticket Type].[Ticket Type].[9134654662613285455], 
        [Ticket Type].[Ticket Type].[9140432570013809078], 
        [Ticket Type].[Ticket Type].[9145452972713549451], 
        [Ticket Type].[Ticket Type].[9140432570013809076], 
        [Ticket Type].[Ticket Type].[9138836630013081428], 
        [Ticket Type].[Ticket Type].[9145452972713549453], 
        [Ticket Type].[Ticket Type].[9145452972713549455], 
        [Ticket Type].[Ticket Type].[9145452972713549457], 
        [Ticket Type].[Ticket Type].[9145452972713549459], 
        [Ticket Type].[Ticket Type].[9145609457713578112], 
        [Ticket Type].[Ticket Type].[9134792932413392960], 
        [Ticket Type].[Ticket Type].[9134833277313407014], 
        [Ticket Type].[Ticket Type].[9134792932413392962], 
        [Ticket Type].[Ticket Type].[9134911151013454617], 
        [Ticket Type].[Ticket Type].[9134911151013454615], 
        [Ticket Type].[Ticket Type].[9138836630013081446], 
        [Ticket Type].[Ticket Type].[9145452713113549279], 
        [Ticket Type].[Ticket Type].[9145452713113549277], 
        [Ticket Type].[Ticket Type].[9138837241613081620], 
        [Ticket Type].[Ticket Type].[9145452713113549275], 
        [Ticket Type].[Ticket Type].[9139560292713345110], 
        [Ticket Type].[Ticket Type].[9145609457713578108], 
        [Ticket Type].[Ticket Type].[9134654662613285461], 
        [Ticket Type].[Ticket Type].[9134654662613285463], 
        [Ticket Type].[Ticket Type].[9139560292713345112], 
        [Ticket Type].[Ticket Type].[9145609457713578106], 
        [Ticket Type].[Ticket Type].[9134792932413392958], 
        [Ticket Type].[Ticket Type].[9134488303913230179], 
        [Ticket Type].[Ticket Type].[9135138327113743686], 
        [Ticket Type].[Ticket Type].[9134783010613387181], 
        [Ticket Type].[Ticket Type].[9134488303913230177]
    }
)
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/42206842

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档