SSAS MDX计算的度量 - [ITEMS]的COUNT。[项目]分组[项目]。[项目组]

作者: 荧惑
发布时间: 2024-12-10 09:29:15 (18天前)
转自：

2 条回复

0#
回复此人
部落用户 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 在AdventureWorks上查看以下示例。 </p> <pre> <code> with member [Measures].[CountTest] as count(existing [Product].[Subcategory].members - [Product].[Subcategory].[All]) select { [Measures].[Internet Sales Amount],[Measures].[CountTest] } on columns, { ([Product].[Category].[Category] ,[Product].[Subcategory].[Subcategory] -- comment this line for the second result ) } on rows from [Adventure Works] </code> </pre> <P> <a href="https://i.stack.imgur.com/B2t54.jpg" rel="nofollow noreferrer"> <img src =“https://i.stack.imgur.com/B2t54.jpg”alt =“在此处输入图片说明”/> </A> </p> <P> 现在注释父视图的指示行。 </p> <P> <a href="https://i.stack.imgur.com/dHwg7.jpg" rel="nofollow noreferrer"> <img src =“https://i.stack.imgur.com/dHwg7.jpg”alt =“在此处输入图片说明”/> </A> </p> </DIV>

编辑

登录后才能参与评论