Where condition is not working in Cubes

[#1]

Hi All,

        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.

[$0SD_C03]:

Load *;

Select PseudoMDX D (

Dimensions (

  [0CALYEAR] (),

  [0FISCPER] ()),

From ($0SD_C03))

where  [0CALYEAR] = 2013

;

can any one help me.

Regards,

Antony.

[#2]

Hi Antony,

If you need use the sentence where in the load of a cube, you have that add the follow line:

[$0SD_C03]:

Load *;

Select PseudoMDX D (

Dimensions (

  [0CALYEAR] (),

  [0FISCPER] ()),

Slices (

  [0CALYEAR].[2013]),

From ($0SD_C03));

Please try with this code, but you may that check the value of the value field.

Regards!.

Alejandro Urrego