Warm tip: This article is reproduced from serverfault.com, please click

ssas mdx

Named set vs 'grouped set' in MDX

发布于 2020-11-27 21:43:28

To get a named set, for example the years between 2015-2018 (four values -- 2015, 2016, 2017, 2018) I can do:

WITH set [2015-2018] as {[Season].[Season].[Season].&[2015]:[Season].[Season].[Season].&[2018]}
SELECT {
        [Measures].[Wins]
} ON COLUMNS, {
    [2015-2018]

} ON ROWS
FROM [Nfl2]

And it gives me:

        Wins
2015    256
2016    254
2017    256
2018    254

How would I create a single grouped set (or whatever it is termed in MDX) where I could do the following:

            Wins
2015        256
2016        254
2017        256
2018        254
2015-2018   1020   *** how to do this in mdx?

Questioner

carl.hiass

Viewed

0

BOUBRIT Nacim 2020-11-28 12:28:31

In Mdx we don't say Grouped set, but members, your aim is to create a member that holds the sum of wins from 2015 to 2018. In order to achieve that you need to specify an aggregation function for the calculated member [2015-2018] like this:

WITH 
Member [Season].[Season].[All].[2015-2018] AS SUM({[Season].[Season].&[2015]:[Season].[Season].&[2018]})
set [2015-2018-All] as {[Season].[Season].&[2015]:[Season].[Season].&[2018],[2015-2018] }
SELECT {
        [Measures].[Wins]
} ON COLUMNS, {
    [2015-2018-All]

} ON ROWS
FROM [Nfl2]

carl.hiass 2020-11-28 23:06:37

thanks, why did you put the member under the .All hierarchy? That is, why add it at [Season].[Season].[All].[2015-2018] instead of [Season].[Season].[Season].[2015-2018] ?

BOUBRIT Nacim 2020-11-29 00:52:27

We know that attributes has two levels: All level and leaf level who holds the members like this All --> members. So if we want to add a new member we will place it under the All level like this [Season]. [Season]. [All]. [2015-2018]

carl.hiass 2020-11-29 04:21:42

sure, but why put it in the [All] level instead of the [Season] level, wouldn't both work?

热门帖子

1

IPV6 太香了

2

最近同事的一句话让我一直耿耿于怀，大伙帮忙分析下

3

阿里 ECS 突然 CPU 和磁盘 IO 跑满，如何去查，给阿里提工单有用吗

4

公司下个月要裁员，现在要提桶跑路吗？

5

我这个到底是什么病，还有救吗

6

有出服务器类发票的吗？

7

打算和媳妇出国旅游，有没有推荐？

8

把网址全变成长得一样的棒棒： llIlI.lI

9

即将三十岁，辞掉 6 年电子厂的企划的工作，转行成人用品行业的摄影师

10

川西之旅，照片分享

热门github

1

A multi-platform library for OpenGL, OpenGL ES, Vulkan, window and input

2

Dev tool that writes scalable apps from scratch while the developer oversees the implementation

3

shadcn/ui, but for Svelte. ✨

4

The Python Risk Identification Tool for generative AI (PyRIT) is an open access automation framework to empower security professionals and machine learning engineers to proactively find risks in their generative AI systems.

5

Performance-portable, length-agnostic SIMD with runtime dispatch

6

ZK Credo

7

OpenCodeInterpreter: Integrating Code Generation with Execution and Refinement

8

Joplin - the secure note taking and to-do app with synchronisation capabilities for Windows, macOS, Linux, Android and iOS.

9

Mamba is a new state space model architecture showing promising performance on information-dense data such as language modeling, where previous subquadratic models fall short of Transformers. It is based on the line of progress on structured state space models, with an efficient hardware-aware design and implementation in the spirit of FlashAttention.

10

This repository contains System Design resources which are useful while preparing for interviews and learning Distributed Systems

11

Curso para aprender el lenguaje de programación Python desde cero y para principiantes. 75 clases, 37 horas en vídeo, código, proyectos y grupo de chat. Fundamentos, frontend, backend, testing, IA...

12

🎓 Path to a free self-taught education in Computer Science!

13

1️⃣🐝🏎️ The One Billion Row Challenge -- A fun exploration of how quickly 1B rows from a text file can be aggregated with Java

14

A collective list of free APIs

15

📚 Freely available programming books