How to use Replacement Path Variables to perform Date Calculations in the BEx Analyzer

Step by step procedure is available.
 the useful link which I refered :
http://teklink.co.uk/sap/sap-bi-bw-how-to-use-replacement-path-variables-to-perform-date-calculations-in-the-bex-analyzer/\\

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

Add workbooks to user menu Favorites

This steps will help you , how to add the  work books  to User Menu  Favorites
Add workbooks to user menu Favorites RRMX -> Open workbooks -> Find a workbook ->Right-click ->Choose Properties-> click Information tab ->  Get the Workbook ID field.
SE37 -> Execute FAVOS_EVENT_ADD_TO_USER_SHELF function module.
Enter user_name.
Reporttype = TR
report_name= rrmx
SAP_GUID = the workbook ID
Enter your TEXT you wanna see in the favorites.
See all workbooks associated to an user:SE16 -> SMEN_BUFFC -> REPORTTYPE=TR Workbooks are stored in BW in RSRWBSTORE table or BDS. In RSRWBINDEX table, RSRWBSTORE=T, then the workbook is customer-created workbook, stored in RSRWBSTORE.
BDS workbooks:
T-code BDN1 
CLASS NAME=BW_CATALOG->CLASS TYPE = OT (OTHER OBJ) ->
OBJECT KEY= A_[WORKBOOK ID] ->DOCUMENT TYPE = bw_xlwb_xl
I have refered from : http://yangchuang.com/wp22/?p=21

Multiprovider Activation in Production System

Is it Possible to Activate  the MultiProvider in the Production system?
The important thing is without affecting the Reports.
Yes you can  Activate the Multiprovider in the Production system Directly without affting the Reports.
 
Use this Function Module : RSDG_MPRO_ACTIVATE
You  try  first  it on Sandbox, development system before attempting on production environment.