have some dim (dim_prod), and I would like to create a calculated member based on that dim that will do the following: If the user choose in level3 prod_no 114 I would like that the calculated member will contain 114,113 and 112 in case of choosing 121 it will take 121. 119, 118 If the user choose in level2 prod_no 13 I would like that the calculated member will contain 13,12 and 11 etc.. I tried to do the following, but it didn't work: ([dim_prod].[dim_prod].currentmember + [dim_prod].[dim_prod].currentmember.lag(1) + [dim_prod].[dim_prod].currentmember.lag(2) ) please help. also attached part of dim product: Level1 level2 level3 1 11 111 1 11 112 1 11 113 1 11 114 1 11 115 1 11 116 1 11 117 1 11 118 1 11 119 1 12 121 1 12 122 1 12 123 1 12 124 1 12 125 1 12 126 1 12 127 1 12 128 1 12 129 1 13 131 1 13 132 1 13 133 1 13 134 1 13 135 1 13 136 1 13 137 1 13 138 1 13 139 Kind Regards, Leonid
... View more