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

Knowledge Base Articles

Extender: Rename a dimension

This snippet will rename a dimension. Note: RenameDim does not create entries in Audit tables, which means the Audit Metadata report will not contain anything related to this operation. For this reason, we do not recommend to use this snippet outside...

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

Extender: Auto Update Member Property

This snippet will modify a Member property that can vary by Scenario Type and/or Time. Just pass the relevant ScenarioType ID or Time member ID to set it in a more specific way; it will then appear as a "Stored Item" in the interface. Note: SaveMembe...

OSAdmin by Valued Contributor
  • 1467 Views
  • 0 comments
  • 5 kudos

Extender: Auto Create Member

This snippet will create a new Account member, including setting some properties that can vary by Scenario Type and/or Time. Note: SaveMemberInfo does not create entries in Audit tables, which means the Audit Metadata report will not contain anything...

OSAdmin by Valued Contributor
  • 1498 Views
  • 0 comments
  • 3 kudos

Extender: User Inactivity Email

This Extender can be executed in a Data Management step to automate emailing details of an auto-expiring account to the related user. Imports System Imports System.Data Imports System.Data.Common Imports System.IO Imports System.Collections.Generic I...

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

Extender: automate Import, Validate, Load

This example will perform Import, Validate, Load as a batch operation. The approach is typically seen in Extenders or Event Handlers. 'Set Processing Switches Dim valTransform As Boolean = True Dim valIntersect As Boolean = True Dim loadCube As Boole...

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

Extender: Automate Application Metadata Backup

This is an example Extender rule that extracts all application metadata to a zip file, for the current application. The file is created in the application Data Management Export folder, in the File Share directory. 'Prepare the Stage Data Extract Fil...

OSAdmin by Valued Contributor
  • 987 Views
  • 0 comments
  • 3 kudos
Top Contributors