Issue: My query output is "X".
I have created a formula Variable with Replacement path , the reference characteristic is 0CALWEEK.
Formula variable is being used in Calculated key figure (CKF) and same CKF has been used in the columns - Selection and restricted with current week - 4 .
My query output is "X" . May i know the reason?
Note: Query static filter is on Info provider and in that info provider, column 0CALWEEK is not available but available at multiprovider level ( Underlying DSO & cubes)