Creation of an OLAP variable

[Former Member]

Hai All,

I need to create an OLAP variable in an infopackage for an object for picking up data from last two months. I mean to say that the object has to pickup all the data pertaining to the last two moths only from the system date without any manual intervention. I see that there is an option in info package where I can select 7-OLAP variable and another option ABAP program. Which one of these is a good way and how to doit? any advise or also any reference to documentationwill be appreciated.

Thank you very much.

Message was edited by: vasu vasu

[Ashwin]

Hi!

check this help page for more info.

http://help.sap.com/saphelp_nw04/helpdata/en/a3/4f8f3b294a7f2de10000000a11402f/content.htm

i think it is better to use ABAP routine.

with regards

ashwin

[Former Member]

Hai Ashwin,

Thanks a lot for the reply. I actually need to need to create a new varible for the info pack. The ones available donot meet my requirements. Where can I create the variable? I know RSZV is now integrated with query builder. I have the r/3 data coming to an ODS. Do I need to create a varible in a query on that ods. I already created a variable giving an offset but its not showingup in the list of OLAP variable showed in the info package. Is there any other place where I need to do this?

Thank you.

[former_member188975]

Hi Vasu,

You will have to create the variable in the query designer. It is not required to create a query on your ODS which uses this variable...in fact the variables are global, so all that matters is creating a variable on the Calmonth InfoObject.

Hope this helps...

[Former Member]

Hi Vasu,

> I already created a

> variable giving an offset but its not showingup in

> the list of OLAP variable showed in the info package.

> Is there any other place where I need to do this?

I experienced the same problem. My solution was to edit the variable and deselect the 'ready for input' option. Also the variable has to be a SAP- or customer-exit variable so that it can run as a background job.

Best regards,

Christian Frier