OneStream Community

PhilB · 06-08-2023

I have a process that builds a data buffer using Data Buffer Cell Loop logic. I need to check the cell status on each record and perform certain actions based on the status. Specifically, I want to make sure all 12 Account-Type dimensions are referen...

PhilB · 04-28-2023

Is there a way, in a member formula or Finance BR, to write annotation data back to the database in bulk?In OneStream rule writing, it's best practice to limit the number of times you are writing data back to the database (ideally only one SetDataBuf...

PhilB · 02-16-2022

Summary Is there any documentation and/or sample code showing how to use the new "dbWheres" argument in a LookupRowFieldValue() function? Detail In version 6.8 (maybe earlier), if you use .LookupRowFieldValue() with your criteriaExpression (i.e. - yo...

PhilB · 12-02-2021

When running a Data Mgmt Data Extract step, you can chose where you want the file saved:However, the name you provide always starts under the File Share\Applications\[App Name]\DataManagement\Export\[User Name] folder. So, the above extract would sho...

PhilB · 06-13-2023

I noticed in your cell POV that you have origin set to O#AdjInput. Typically, that origin member is used for journal entry adjustments, not for form input. Can you confirm what the "Adjustment Type" property on the A#HC_REG account is? It should be e...

PhilB · 06-09-2023

Hi Jack,Thanks for your feedback. I just wanted to clarify a few things that I think were misinterpreted: - I'm only creating the datacell objects from scratch as an example to demonstrate the fundamental issue (status is incorrect) for this forum po...

PhilB · 04-28-2023

Hi Omkareshwar,I'm not actually looking for anything custom. I'm talking about OneStream's standard annotation functionality (i.e. - V#Annotation). I want to populate the V#Annotation members in a data buffer in much the same way you would populate t...

PhilB · 02-16-2022

Hi Sai,Thanks for the response. I did look at Joe's post, but I think I missed the screen-shot with the example code. I'll try that and see how it works. Thanks again.

PhilB · 01-10-2022

Hi Cosimo,There is a OS Knowledge Base article about this: KB0010071https://onestreamsoftware.service-now.com/sp/?sys_kb_id=09389b291be7601099ce86e1604bcb5d&id=kb_article_view&sysparm_rank=1&sysparm_tsqueryId=9ec76c471b6a381099ce86e1604bcb0cIn practi...

OneStream Community

User Statistics

User Activity

How do I get the correct Cell Status on a data buffer cell?

Writing Annotation data in a Finance Rule (like SetDataBuffer)

New Syntax for LookupRowFieldValue()

Can a Data Mgmt Data Extract step be saved somewhere other than under that user's folder?

Re: Trying to link an adj form to a cube view

Re: How do I get the correct Cell Status on a data buffer cell?

Re: Writing Annotation data in a Finance Rule (like SetDataBuffer)

Re: New Syntax for LookupRowFieldValue()

Re: Excel VBA automation - Refresh Workbook function