admin管理员组

文章数量:1308192

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 edited Mar 7 at 16:04 Govind Parmar 21.6k7 gold badges56 silver badges89 bronze badges asked Feb 2 at 1:53 Александр ДексбахАлександр Дексбах 91 bronze badge
Add a comment  | 

1 Answer 1

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]

本文标签： ssasSize dimension to quantity MDXStack Overflow

版权声明：本文标题：ssas - Size dimension to quantity MDX - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741858438a2401481.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。