I used where condition in following script but it is not working. it showing full data only. i do not know whether i am making any mistake in the condition. the data fetched from Cubes via SAPOlapconnector.
Select PseudoMDX D (
where [0CALYEAR] = 2013
can any one help me.
If you need use the sentence where in the load of a cube, you have that add the follow line:
Please try with this code, but you may that check the value of the value field.