About former_member309686

former_member309686 · 06-11-2019

Dear Experts, Mistakenly I have archived BPF finalized instance. Is there any way to revoke the process? or is there any way from back end tables in BW to view the process activity details and comments that was already archieved? Thanks

former_member309686 · 11-18-2015

Hi Experts,I am using *Select statement in which I need to use TMVL function. But the system does not recognize TMVL function in *SELECT statement.The script I am using is written below.*SELECT(%DEP_LOOP%,ID,TIME,ID>=%TIME_SET% AND ID<= TMVL(5,%TIME_...

former_member309686 · 09-04-2015

Hello Experts,I have to retract data from BPC to ECC. There are two queries regarding this1) Data that exists in BPC cube is a bottom level data. The hierarchy information is not shown in the cube as a column. Do we have to maintain master data as a ...

former_member309686 · 09-02-2015

Hi Experts,I am using a lookup function in my script logic. The code is written below.*LOOKUP Sales_Main//the real name of model 2*DIM SALES_ACCOUNT ="QTY"*DIM PRODUCT = "0100100101"*DIM AP:CATEGORY="Annual_Plan" //variable AP*DIM LP:CATEGORY="L...

former_member309686 · 12-09-2014

Hi Experts,I have a scenario where I have to lookup the records from different model and push the same in current model.My script logic works if I put a fact value 0 or something else. But if I don't have any fact value the *rec statement does not wr...

former_member309686 · 11-19-2015

Hi Vadim,The count of asset categories will not exceed 200. Though the number range is bit long.can you help me in the script logic. I don't want to do ABAP for this script. I am thinking of the ABAP code as a last option.Regards

former_member309686 · 11-19-2015

Hi Vadim,My mistake.. yes it will start from the next month.The asset super no. is same as Asset categories. The number range is from 30000 till 70000Regards

former_member309686 · 11-19-2015

Capex Driver:This below cost exist in the main CAPEX model against each Asset Super Class (Laptop, Desktop, car etc)We need to build a mechanism in order to calculate the depreciation based on the life in months set in capex driver model. For eg. Th...

former_member309686 · 11-19-2015

Hi Vadim,Please find below the script logic.*LOOKUP CAPEX_DRIVER*DIM ALIFE:ACC_CAP_D= "ASSETLIFE"*DIM CURRENCY= "PKR"*DIM VERSION = "Plan"*DIM ASSET_SUPER = CI3*DIM TIME = NO_TIME*DIM ENTITY = %ENTITY_SET%*ENDLOOKUP*XDIM_MEMBERSET VERSION = Plan*XDIM...

former_member309686 · 11-18-2015

Hi Vadim,Thanks for your reply.I lookup the member NO_OF_MONTHS from another model.This LOOKUP value will be used in the main model in FOR loop.for eg. No_of_months = 4then in the main model the for loop should start from the %TIME_SET% till the No_o...

User Statistics

User Activity

SAP BPC BPF view archived instance

TMVL in Select Statement

Retraction query

Lookup Function variable issue

REC statement returns no record

Re: TMVL in Select Statement

Re: TMVL in Select Statement

Re: TMVL in Select Statement

Re: TMVL in Select Statement

Re: TMVL in Select Statement