How to read ODS data in FOX - IP ?

79 Views

Hi experts,

I am new to fox codes in IP.

In my planning function, I want to read ODS data and using that data i need to manipulate planning cube data.

But i am not sure how to read ODS data..

my ods is not selected in filter. fields to be changed are Material and infoprovider.

so my requirement in for Material which is there in cube , I need to read one key figure value of ODS.

Key figure is sales value (ZS_1).

this key figure is present in cube and ODS. But code which i have written, its reading value from cube instead of ODS.

*********************************************************

DATA ODS TYPE 0INFOPROV.

DATA sku TYPE 0MAT_SALES

DATA SALES TYPE F.

ODS ='ZSALES'.

sales = { ZS_1, ODS, sku}.

**********************************************

this sales value i will be using further to manipulate cube other Key figure values.

Please help me how i can retrieve ODS Key figure value in one variable??

thanks in Advance.