MDX 获取用户名，其中用户 ID [英] MDX Get UserName Where UserID

问题描述

下面是我的 MDX 查询:

Here is my MDX query below:

SELECT 
  {
    [Measures].[Amt Exrate]
   ,[Measures].[Comm Exrate]
  } ON COLUMNS
 ,NonEmpty([AccSetting].[User N].[User N] * [Cur Log].[Cur Log ID].Children) ON ROWS
FROM [report]
WHERE 
  [AccSetting].[Ag ID].&[113];

http://i.stack.imgur.com/0yDHg.pngUserID =113 是一个层次结构，想要获取它的 userN我想在行上准确返回 UserID =113 的 UserName .但我不知道该怎么做.

http://i.stack.imgur.com/0yDHg.png UserID =113 is a hierarchies and a want to get the userN of it I want to return exactly UserName of UserID =113 on Rows. but I'm not sure how to do it.

推荐答案

试试这样:

with dynamic set UserN as
NonEmpty(
            [AccSetting].[User N].[User N].members * [Cur Log].[Cur Log ID].Children
            ,
            [AccSetting].[Ag ID].currentmember
                            *
            {
                [Measures].[Amt Exrate],
                [Measures].[Comm Exrate]
            }
        )

SELECT 
  {
    [Measures].[Amt Exrate]
   ,[Measures].[Comm Exrate]
  } ON COLUMNS
 ,UserN ON ROWS
FROM [report]
WHERE 
  [AccSetting].[Ag ID].&[113];

这篇关于MDX 获取用户名，其中用户 ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！