ssas - Size dimension to quantity MDX - Stack Overflow

How do I make MDX show the quantity of sizes per item?

This query show what kind of sizes per item, but i want that he show me quantity per item.

Maybe need count or filter function, please help.

How i need write correct code?

select {} on 0,
{[Товары].[ItemID].[6863153]  
* [Товары].[SizeID].[SizeID]} on 1
from [Analyse]

Maybe need to create member. please help me.

How do I make MDX show the quantity of sizes per item?

This query show what kind of sizes per item, but i want that he show me quantity per item.

Maybe need count or filter function, please help.

How i need write correct code?

select {} on 0,
{[Товары].[ItemID].[6863153]  
* [Товары].[SizeID].[SizeID]} on 1
from [Analyse]

Maybe need to create member. please help me.

• ssas
• mdx
• olap
• mdx-query

Share Improve this question Follow edited Mar 7 at 16:04 Govind Parmar 21.6k77 gold badges5656 silver badges9090 bronze badges asked Feb 2 at 1:53 Александр ДексбахАлександр Дексбах 1922 bronze badges 1

• @Igor Shekhounov thx a lot. Can you explane what 'existing' do? можно и по-русски) Что делает 'existing' – Александр Дексбах Commented yesterday

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

with 
member [measures].[sizes_count] as 
  (existing [Товары].[SizeID].[SizeID]).count
select 
  {[measures].[sizescount]} on 0,
  {[Товары].[ItemID].[6863153]} on 1
from 
  [Analyse]