Recent Discussions
Function to return the period associated with a date, when the period is 4-4-5 or 5-4-4
Has anyone written a complex expression that takes a date as an input, and determines the period associated with the date, when periods are not based on calendar ends (for example, 4-4-5, or 5-4-4)? There doesn't appear to be a BRApi function for this, but perhaps I'm missing something. Absent a function, what techniques are recommended? Thanks!
Locate the Workflow Audit information
Hi, this was already asked in an old post, but there was no solution given. Where is the Workflow Audit information (like the one in the picture) stored? For context, I know that Lock History information can be retrieved using the WorkflowLockHistory Data Adapter method, and it's also stored in the WorkflowLockHistory application table. However, I'm having trouble finding the Workflow Audit information that isn't part of the Lock History. Specifically, I'm looking for details on who performed each workflow step, which is displayed in the workflow audit window but not returned by the WorkflowStatus Data Adapter method. Can anyone provide guidance on where to find this information?
Reference External DB and Application DB in one SQL Query
Hello, I am writing a SQL Query that references tables in different databases, one that exists in the External database (BI Blend) and one that exists in the Application database. I am having trouble setting up my data adapter to allow for pulling in both tables to perform a Union, as I need to specify the Database Location. Is this possible?
Derivative Rule
Hello, I'm trying a Derivative Rule where I've one source target account which needs to be mapped to an another account and combination of attributes, the idea is it should create new row for each account attribute, but as I'm using multiple attribute values at once it throwing me an error Please let me know what I'm missing out or what I'm doing wrong from the below expression. A#[56000]=[ABC]:A1#[ACC-*;FTM-*;BTSRR-*;BPR-*;BSC*;CON-*]
Consolidation- Calcstatus showing CN for all period.
Hi Everyone, We recently migrated from 7.1.3 to 8.4 . after migrations, we are facing issue in Calcstatus- Consolidation from Bottom to Top ( Parent). we tried to consolidated-calcstatus from beginning of the data to till now. But its not running properly or not showing value in parent level. after closing cubeview again its showing CN. is there anyone faced this issue and find the solutions?Smart Integration Connector (SIC) Error
There are data management tasks scheduled, they are designed to extract OneStream data and load to external database. Some failed with below error messages, but they succeeded later on. Just wondering what could be the possible causes, I would appreciate if anyone could help me understand
Metadata Automation
Hi there, I'm looking to automate dimension uploads in that I want the dimension to be "replaced" with the new one that I am loading. I want to reduce the burden of having to add or remove members from dimension and just automate that process. How can this be done and where should I start? Thank you in advance, Joesef
Loading Amount and Annotations together
Hi, not sure if anyone came across with this one but thought it was interesting to share If you have a file which has in the same line amount and annotation you can set View to YTD (or periodic), then in the text value complex expression use this api prop: api.Parser.TextValueRowViewMember = "Annotation" That will make the parser to automatically generate the line(s) with the annotation if text value have a value. HTH
