Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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