ContributionsMost RecentMost LikesSolutionsRe: Use 2 fields to determine dimension value in datasource Since this is a connector data source, I don't think api.Parser.DelimitedParsedValues() will work. I've used logic like this for complex expressions in connector sources. Below is index based, so fie...Re: WfTime parameter not working in SQL table editor Does having = '|WFText4|' and Period = '|WFTime|' work? If that doesn't fix the issue you could create an XFBR string that accepts WFTime and WFText4 as variables, and then create the where claus...Re: Reset/Clear the loaded data (O#Import) via BR You can clear the loaded data by creating a data management step Re: Add month T#|PovYearPrior||PovSubPeriod| The above member filter is using substitution variables, which can be found here in the member filter builder. Re: Add month What is the current member filter for the prior year columns? Re: Copy Prior Year Retained Earnings Do not factor any of the manual accounts into the calculation by creating a parent like RE_Calculated that holds only calculated RE amounts only. Re: Periodic data copy from YTD scenario Something like this should work Dim sourceBuffer1 As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(S#" & sSourceForecast & ":V#PERIODIC,A#Top.Base,O#AdjInput,O#Forms)") sourceB...Re: is there a way to check the total value on each account in the staging? If you are using a Connector to load the data, you could build logic within that rule to not bring in records that fit this case. Re: Copy Prior Year Retained Earnings Below is an illustration of how the data flows from Net_Income to CYRE, and how Accumulated RE flows into PYRE. This example would work if you have existing RE balances loaded, but cease loading...Re: Copy Prior Year Retained Earnings That represents a parent account, so the sum of CY and PY Retained Earnings. The formulas need to take into account if retained earnings data is being loaded from the ERP
