BI数据权限问题

WITH MEMBER [Measures].[本月销量] AS  SUM(MTD([Dim Date].[Y-M-D]),[Measures].[销售量]) MEMBER [Measures].[本月整月销量] AS  ([Dim Date].[Y-M-D].parent,[Measures].[销售量]) MEMBER [Measures].[本月目标] AS ([Dim Date].[Y-M-D].parent.firstchild,([Dim Target].[Target For].&[总销量],[Measures].[目标值]))

 MEMBER [Measures].[本月完成率] AS IIF([Measures].[本月销量]=NULL OR [Measures].[本月目标] =NULL,0,

[Measures].[本月销量]/[Measures].[本月目标]) MEMBER [Measures].[上月同期销量] AS (PARALLELPERIOD([Dim Date].[Y-M-D].[Month],1),[Measures].[本月销量]) MEMBER [Measures].[上月整月销量] AS ([Dim Date].[Y-M-D].parent.prevmember,[Measures].[销售量])  MEMBER [Measures].[月环比] AS IIF([Measures].[本月销量]=NULL OR [Measures].[上月同期销量] =NULL,0,

[Measures].[本月销量]/[Measures].[上月同期销量]-1) MEMBER [Measures].[去年同期销量] AS  (PARALLELPERIOD([Dim Date].[Y-M-D].[Year],1),[Measures].[本月销量]) MEMBER [Measures].[月同比] AS IIF([Measures].[本月销量]=NULL OR [Measures].[去年同期销量] =NULL,0,

[Measures].[本月销量]/[Measures].[去年同期销量]-1) MEMBER [Measures].[本年销量] AS  SUM(YTD([Dim Date].[Y-M-D]),[Measures].[销售量])   MEMBER [Measures].[去年累计同期销量] AS (PARALLELPERIOD([Dim Date].[Y-M-D].[Year],1),[Measures].[本年销量]) SELECT NON EMPTY { [Measures].[上月整月销量], [Measures].[上月同期销量], [Measures].[去年累计同期销量], [Measures].[本年销量], [Measures].[去年同期销量], [Measures].[月环比], [Measures].[本月销量], [Measures].[销售量], [Measures].[本月完成率], [Measures].[本月目标], [Measures].[月同比], [Measures].[本月整月销量] } ON COLUMNS, NON EMPTY { ([Dim Shop].[Shop Name].[Shop Name].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Dim Shop].[Shop ID].[All] } ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DimDateYMD, CONSTRAINED) ) ON COLUMNS FROM [KPI])) WHERE ( IIF( STRTOSET(@DimDateYMD, CONSTRAINED).Count = 1, STRTOSET(@DimDateYMD, CONSTRAINED), [Dim Date].[Y-M-D].currentmember ), [Dim Shop].[Shop ID].[All] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

1. 就是通过传参数来决定显示的维度，做切片。
2. 然后就是类似下面链接的，做Cube内限制