Accepted Code Samples
OneStream approved sample code snippets and examples to help everyone write rules.

Knowledge Base Articles

Extender: Rename a dimension

Rename a dimension '>>>>>>>>>>>>>>CAUTION<<<<<<<<<<<<<<<< 'BRApi.Finance.Dim.GetDimPk 'This API does not make entries into the Audit tables and will not be reflected in the Audit Metadata Report Dim originalDim As String = String.Empty '<-- Dimension...

OSAdmin by Valued Contributor
  • 485 Views
  • 0 comments
  • 0 kudos

Extender: Auto Update Member Property

Update Text1 value for Account member '>>>>>>>>>>>>>>CAUTION<<<<<<<<<<<<<<<< 'BRApi.Finance.MemberAdmin.SaveMemberInfo 'This API does not make entries into the Audit tables and will not be reflected in the Audit Metadata Report 'Recommended usage of ...

OSAdmin by Valued Contributor
  • 662 Views
  • 0 comments
  • 4 kudos

Extender: Auto Create Member

Create a new account member '>>>>>>>>>>>>>>CAUTION<<<<<<<<<<<<<<<< 'BRApi.Finance.MemberAdmin.SaveMemberInfo 'This API does not make entries into the Audit tables and will not be reflected in the Audit Metadata Report 'Recommended usage of this API d...

OSAdmin by Valued Contributor
  • 605 Views
  • 0 comments
  • 2 kudos

Extender: Export Metadata via Extender

To be used with an Extender rule to export the metadata zip file from the application Select Case args.FunctionType Case Is = ExtenderFunctionType.Unknown, ExtenderFunctionType.ExecuteDataMgmtBusinessRuleStep 'Prepare the Stage Data Extract File path...

OSAdmin by Valued Contributor
  • 466 Views
  • 0 comments
  • 1 kudos

Extender: Export Data from Stage via Extender

To be used with an Extender rule to export data from the stage for a Workflow Profile Select Case args.FunctionType Case Is = ExtenderFunctionType.Unknown, ExtenderFunctionType.ExecuteDataMgmtBusinessRuleStep 'Prepare the Stage Data Extract File path...

OSAdmin by Valued Contributor
  • 586 Views
  • 0 comments
  • 0 kudos

Extender: User Inactivity Email

Automate sending of emails prior to user expiration. Imports System Imports System.Data Imports System.Data.Common Imports System.IO Imports System.Collections.Generic Imports System.Globalization Imports System.Linq Imports Microsoft.VisualBasic Imp...

OSAdmin by Valued Contributor
  • 648 Views
  • 0 comments
  • 1 kudos

Extender: Automate Import, Validate, Load

Used in a rule to automate batch import, validate and load, most likely in an Extender or Event Handler 'Set Processing Switches Dim valTransform As Boolean = True Dim valIntersect As Boolean = True Dim loadCube As Boolean = True Dim processCube As B...

OSAdmin by Valued Contributor
  • 536 Views
  • 0 comments
  • 1 kudos

Extender: Automate Application Metadata Backup

Extender buiness rule that all application metadata to a zip file for the current application. The files are written to the application Data Mgmt Export folder in the file share directory. 'Prepare the Stage Data Extract File path Dim configSettings ...

OSAdmin by Valued Contributor
  • 446 Views
  • 0 comments
  • 1 kudos
Top Contributors