create a formula variable using replacement path for current date

[former_member209700]

Hi All,

I created a formula variable using replacement path for current date.

But when i used this variable am getting an error message saying .

" This Variable cannot be used in this query".

Could you please let me know the reason?

Thanks,

Zehra

[Former Member]

Pls check if the ref. char, on which you have created variable with replacment path, is available in your query.

[shanthi_bhaskar]

did you fallow this

http://www.sd-solutions.com/SAP-HCM-BW-Replacement-Path-Variables.html

[former_member209700]

HI,

Thanks for your reply.

I want current date to be populated though replacement path. is that possible?

Thanks,

Zehra

[Former Member]

Hi,

I don't understand how can you get current date through replacement path. You can use customer exit type formula variable to get system date.

Best wishes,

Mayank

[former_member189638]

You need to write the user exit in CMOD and use sy-datum for populating the current date. Please search the forum for the ABAP code.

[former_member209700]

Hi All,

Thanks for all your help...

I just found a solution via the below link

.

Here he is trying to use the existing formula variable.

My doubt here is, Even i could not find this varaible in BEX formula variable, But could see this in BI Content path as mentioned in the above link. DO i have to transport this varaible , or i simply can activate it in production?

I just could find this in BI Content but not in MetaData Repository.

Thanks,

Zehra