ContributionsMost RecentMost LikesSolutionsRe: Monthly vs Quarterly allocation of accounts Your table confuses me. But when I see division and parent members involved, there are almost always order of operation issues to consider that can only be solved through Dynamic Calcs. Depending o...Re: Onestream Certification : Lead architect or Core application architect ? The Lead Architect OCP exam is being retired in mid-Jan 2026. The Core Platform Architect OCP is the newly released go forward version of the exam. Those having the Lead Architect OCP certification...Re: Retrieve App Names from Development Environment via Business Rule I am unware of any App table in the Framework DB. Change your SQL query to the following: SELECT TextValue FROM ServerConfig WHERE ItemName1='ApplicationName' Re: Calculation definitions are not executing in the expected sequence. The packages will be started according to Order, but I am betting you are using a StartDataMgmtSequence() which starts the package in the background, allowing control to be passed on to the next item...Re: Calculation in Scenario member If you are showing the entire script, then part of your problem is that you have selected to write Durable data, which normally requires a preceding ClearCalculatedData() to get rid of previously cal...Re: Create a parameter to determine the initialization status of each forecast? You can use BRApi.Dashboards.Parameters.SetLiteralParameterValue() to assign a value to a Dashboard Parameter. You can either use that parameter in the Cube View or use GetLiteralParameterValue() in...Re: Filtering account by UD's More specifically, does the source data reside in A#61550:U2#Dept48? If so, check the Cell POV Information in the Cibe View using the Dynamic Calc account and that of where the source data resides. ...Re: How to get two decimal places in Member formula Well, then it is time to dump out the second data buffer to error log to see why you are getting zero. You could be encountering a constraint issue. Also dump out the value of Var1, as perhaps it i...Re: How to get two decimal places in Member formula In short, the error you are getting is because you are attempting to concatenate a Decimal datatype without any conversion into a String. The simple fix would be: api.Data.Calculate("A#520000 = A#4...Re: Reporting expenses as negative instead of positive This is readily addressed by creating a dynamically calculated U8#NaturalSign member, which flips the sign of Expense and Asset AccountType's.