Skip to Content
0
Jan 04 at 11:57 AM

Converting a characteristic to keyfigure via formula variable with replacement Path

61 Views

Hi ,

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)

Regards,

Mahesh