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

Knowledge Base Articles

Filter IC Dimension by Entity Property

A common requirement for reporting is to be able to filter the IC dimension by some property that exists only on the original Entity members. This can be achieved with a custom Member List defined in a Finance business Rule. Select Case api.FunctionT...

JackLacava_0-1704889740618.png
JackLacava by Community Manager
  • 470 Views
  • 0 comments
  • 4 kudos

Dashboard: Get or Set Literal Parameter

Literal Parameters are, effectively, application-wide variables that can be used to drive Dashboards and Cube Views. Their values can be set or retrieved in code as shown below. From version 7.3 onwards, they are contained in a Workspace. That means ...

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

Dashboard: Open Dashboard File Resource

Open a Dashboard file resource and retrieve its raw contents. Note: This snippet is for OneStream 7.4 and above. Previous releases can use similar logic, just without the WorkspaceID machinery. ' *** parameters to customize to your needs ' Specify th...

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

Dashboard: XFBR String

Business rules written and used as Parameters that return a specific value based on the defined inputs. This Business Rule can be applied to any Dashboard or Cube View property where a Parameter is used. Imports System Imports System.Data Imports Sys...

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

Dashboard: Data Sets

DashboardDataSet Rules are used to create programmatic query results. This rule type enables the rule writer to combine multiple types of data into a single result set using the full syntax capability of VB.Net. '-------------------------------------...

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