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...
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 ...
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...
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...
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...
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...
Used in a rule to automate batch import, validate, load, process and confirm, most likely in an Extender or Event Handle 'Set Processing Switches Dim valTransform As Boolean = True Dim valIntersect As Boolean = True Dim loadCube As Boolean = True Dim...
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...
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 ...
Set Literal Parameter Value Dim parameterName As String = "LiteralParameterName" Dim newValue As String = "NewLiteralValue" 'Set literal parameter BRApi.Dashboards.Parameters.SetLiteralParameterValue(si, False, parameterName, newValue)
Open Dashboard file resource & get its contents 'Define File Name Dim fileResourceName As string = "FileName.txt" '<- Enter file name to get from Dashboard 'Get the FileResource Dim fileResource As DashboardFileResource = BRApi.Dashboards.FileResourc...
Retrieve value stored in literal paramater Dim parameterName As String = "LiteralParameterName" Dim parameterValue As String = "" 'Set literal parameter parameterValue = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, parameterName)
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...
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. '-------------------------------------...
An account that calculates Daily Revenue by taking three months of Total Revenue and dividing it down to a daily amount 'Calculate Daily Revenue 'Get Text1 priority from current Scenario to learn which Scenario to copy prior data from Dim priorScenar...
An account that calculates Annualized Revenue by taking three months of Total Revenue and dividing it down to a monthly amount then multiplying by 12 'Calculate Annualized Revenue Return api.data.GetDataCell("(A#TOTREV:I#Top:U1#Top:V#Trailing3MonthTo...
Efficiency Measure: A financial ratio that measures a company's profitability and the efficiency with which its capital is employed. Formula: EBIT/ (Total Assets- Total Liabilities) 'Calculate Return on Capital Employed 'Formula: EBIT/ (Total Assets-...
Efficiency Measure: The ratio is considered an indicator of how effectively a company is using its assets to generate earnings before contractual obligations must be paid. Formula: EBIT / Total Net Assets 'Calculate Return on Total Assets 'Formula: E...
Efficiency Measure: Return on equity measures a corporation's profitability by revealing how much profit a company generates with the money shareholders have invested. Formula: ROE= Net Inocme/ Average Shareholders Equity 'Calculate Return on Equity ...
Efficiency Measure: An indicator of how profitable a company is relative to its total assets. It gives an idea as to how efficient management is at using its assets to generate earnings. Formula: ROA = Net Income / Average Total Assets 'Calculate Ret...
