kyle_tetschlag
Explorer
Member since ‎2016 Jun 06

User Statistics

  • 15 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

Member Property used in RUNALLOCATION script logic

2020 Jul 17
Hi All Using BPC 10.1 NW, I'd like to create allocation script. Dimensions: ACCOUNT TIME PRODUCT Business scenario: I have loaded market growth assumptions to PRODUCT (PRODUCTA, B and C) members which are a property (INPUTNODE) of our mai...

BPC Transformation File Formula to add zero

2020 May 24
Hello Experts I am putting together a transformation file to pull in master data from a flat file. The dimension I am creating in BPC is 5 characters. I the flat file, the string is either 4 characters or 18 characters. For the 18 character stings,...

TMVL with WHEN_REF_DATA not working

2018 Jul 23
I am trying to pull an account (Acct A) from the previous month to calculate a current month's account (Acct B) balance. However I am having trouble when there is no data in the current month for Acct A. Script is as follows. First part is adding acc...

Using Member Formulas, how do I pull a different time other than current member?

2018 May 22
I am trying to create Member Formulas for Days Payable Outstanding (DPO) and Days Sales Outstanding. The monthly calculation I can figure out by the following: [ACCOUNT].[ZBSAP] / [ACCOUNT].[ZFACOSSTD]*30 [ZBSAREXCL] / [ZFANETSALES] / 30 ...

Property of Member in REC statement

2017 Oct 23
I am trying to run an allocation that takes the NETSALES amount multiply by percent to get to a Delivery account. The NETSALES are saved in 2018.01 for example while the percent is saved to 2018.INP (a property of 2018.01). How do I tell the REC to p...