I am using PAW version 81 and if I go to edit some MDX in a cube view it appears to be very picky about the spacing, to the point where editing becomes almost impossible, at least for me.
Has anyone experienced this problem? I can't remember previous PAW versions being so picky.
An example of Full MDX is below, and the MDX window seems to add in tabs, for example see the tab between
[Year])}, left([Year].c
this is just after the select statement.
Full MDX example:
Code: Select all
WITH MEMBER [Employee].[Employee].[Grand Total] AS SUM({DISTINCT({StripCalculatedMembers({EXCEPT({TM1SubsetToSet([Employee].[Employee],"N_Level_Employee","public")}, {GENERATE({EXCEPT({TM1SubsetToSet([Employee].[Employee],"N_Level_Employee","public")}, {[Employee].[Employee].Levels(0).MEMBERS}, ALL)}, {[Employee].[Employee].CURRENTMEMBER.ANCESTORS})}, ALL)})})}), SOLVE_ORDER = 2, FORMAT_STRING = '#,##0.00;(#,##0.00)' SELECT {{{{{{{TM1FILTERBYLEVEL({FILTER( {TM1SUBSETALL([Year])}, left([Year].currentmember.name,4)>= Left([}ElementAttributes_Version].([Version].currentmember, [}ElementAttributes_Version].[Start Year]),4) and left([Year].currentmember.name,4) <= Left([}ElementAttributes_Version].([Version].currentmember, [}ElementAttributes_Version].[End Year]),4))},0)}}}}}}}*{DRILLUPMEMBER({TM1SubsetToSet([Period].[Period],"All Periods incl Leafs","public")}, {[Period].[Period].[All Periods]})} ON 0, NON EMPTY {{TM1SubsetToSet([Employee].[Employee],"N_Level_Employee","public")}, {[Employee].[Employee].[Grand Total]}}*{[Measures Payroll].[Measures Payroll].[Total Salary]} ON 1 FROM [Payroll Costs] WHERE ([Version].[Version].[Active Versions^Forecast Test 2022/2023], [Level].[Level].[Final], [Company].[Company].[Total Company^Central], [Dept].[Dept].[Total Dept^Engineering], [Position].[Position].[Total Positions], [Section].[Section].[Total Section^Software], [Type].[Type].[Total Type], [Grade].[Grade].[All Grades], [Scale].[Scale].[All Scales])Maren