Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Where condition is not working in Cubes

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.

1 Reply
Not applicable

Re: Where condition is not working in Cubes

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

Community Browser