ContributionsMost RecentMost LikesSolutionsRe: Cube View DatePicker, Time Zone and Custom Calculate Christian, Unfortunately, this approach won't work. The issue is that "Local" time refers to the local time of the computer that the code is running on. In a SaaS environment, that is the "Local" t...Re: Trying to link an adj form to a cube view 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"...Re: How do I get the correct Cell Status on a data buffer cell? 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 fu...How do I get the correct Cell Status on a data buffer cell? 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 m...New Syntax for LookupRowFieldValue() 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 .Look...Re: Writing Annotation data in a Finance Rule (like SetDataBuffer) 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 ...Writing Annotation data in a Finance Rule (like SetDataBuffer) 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 d...Re: New Syntax for LookupRowFieldValue() 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. Re: Excel VBA automation - Refresh Workbook function Hi Cosimo, There is a OS Knowledge Base article about this: KB0010071 https://onestreamsoftware.service-now.com/sp/?sys_kb_id=09389b291be7601099ce86e1604bcb5d&id=kb_article_view&sysparm_rank=1&sysp...Can a Data Mgmt Data Extract step be saved somewhere other than under that user's folder? 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...