Rules

Is there any way to perform bulk copy of a compressed data table to an Oracle Database using SIC.

Hello everyone, Im tryng to add a drillback option to my BR connector, but i have no idea how i can write it down on my script, any help or instructions from you guys is well apreciated!Here is my complete BR connector it pulls data from a biblent table: Imports System.Data Imports System.Data.Common Imports System.IO Imports System.Collections.Generic Imports System.Globalization Imports System.Linq Imports Microsoft.VisualBasic Imports System.Windows.Forms Imports OneStream.Shared.Common Imports OneStream.Shared.Wcf Imports OneStream.Shared.Engine Imports OneStream.Shared.Database Imports OneStream.Stage.Engine Imports OneStream.Stage.Database Imports OneStream.Finance.Engine Imports OneStream.Finance.Database Namespace OneStream.BusinessRule.Connector.Central_Connector_BiBlend Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Transformer, ByVal args As ConnectorArgs) As Object Try 'Get the query informat

Hi, does anyone have any idea on the functionality of 'Revert to Default Scenario' setting for a scenario type in the member formula? Apparently, when a calc is written in the default scenario, it gets executed for ALL scenario types regardless of whether the revert to default scenario setting is set to True or False. Any help/lead about the use of this setting is appreciated. Thanks!   JackLacava   

Hi, I have a requirement to export 2 files and then merge it into single file. While the export can be done via OOTB DM step, I wonder if we have any api or default function which can be used to merge the 2 exported files?

Hello Community, I am encountering an issue with a Data Management Sequence consisting of four steps. The first step is not executing as expected. If anyone has insights into potential causes, I would greatly appreciate your assistance. Details of the sequence are as follows: The first step is dependent on the successful completion of the second step. The first step involves executing a Business Rule (BR) that includes an Extensibility Rule. The remaining three steps are custom calculations utilizing the Finance rule type.When I run the sequence after running the 1st step separately, it is working fine. But the issue is When i try to run the Sequence which is having all 4 steps it is not working fine  Thank you in advance for your help.

Rules TIP  - ONLY write / use Rules when necessary. OneStream projects should not be a contest to see who is better at writing complex rules. If you must write rules please remember: Unless specified, the calculation will run on Base Entities AND each Parent Entity. Use these lines almost always in your rules. For Base entities only use: If Not api.entity.HasChildren Then For Parent entities only use: If api.entity.HasChildren Then For ALL entities: api.Data.Calculate(“A#Account1 = A#Account2”) There are up to 6 calculation operations in the Consolidation process per Entity. Conditional statements can be added to formulas to limit which Consolidation calculation processes will do something for this formula. For Local currency only: If Api.Cons.IsLocalCurrencyforEntity Then For Translated currency only: If api.Cons.IsForeignCurrencyForEntity Then For Parent-Child Relationship levels

I use the Text3 field in Flow members to hold a status value. I have a BR that is creating one Flow member at a time. When the BR runs the line with SaveMemberInfo, every one of my flow member's Text3 values are changed to values that are incorrect. Does anyone have any thoughts on why this is happening. Following is the code I am using to save the Flow member:****************************************************************************************************strModName = "This is the Flow member name"strCurrPdoDescr = "This is the Flow member description"Dim objDim As OneStream.Shared.Wcf.Dim = BRApi.Finance.Dim.GetDim(si, "std_Flow")Dim intModId As Integer = BRApi.Finance.Members.GetMemberId(si, dimtypeid.Flow, strModName)Dim objMemberPk As New MemberPk(DimType.Flow.Id, intModId)Dim objMember As New Member(objMemberPk, strModName, strCurrPdoDescr, objDim.DimPk.DimId)Dim objProperties As New VaryingMemberProperties(DimType.Flow.Id, objMember.MemberId, DimConstants.Unknown)Dim NewFlowMb

When writing DataBufferCells to a cube, does anyone know how to create a DataBufferCell having a StorageType=DataCellStorageType.Journals?  

I have declared CurrYear and CurrMonth to retrive year and month respectively. Dim CurrTime As String = api.Pov.Time.NameDim CurrYear As Integer = TimeDimHelper.GetSubComponentsFromName(CurrTime).YearDim CurrMonth As Integer = TimeDimHelper.GetSubComponentNameFromName(currTime).Month can you help me to retrieve month in CurrMonth? 

Hi everyone,  I'm trying to create a formula for an account member that includes different accounts and UDs. I'm trying to do something like this: (A#COMMODITY_GM = A#GROSS_MARGIN - A#NET_INCOME:U2#WC - A#NET_INCOME:U2#US + A#503099:U2#EC - A#FINANCE_EXPENSE:U3#OTHERGRN) I found in the book Finance Rules and Calculations a possible solution using a Data Buffer, so I came up with the following formula: Dim grossmarginDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("A#GROSS_MARGIN:U8#None") api.Data.FormulaVariables.SetDataBufferVariable("GROSS_MARGIN",grossmarginDataBuffer, False) Dim netincomeWCDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("A#NET_INCOME:U2#WC:U8#None") api.Data.FormulaVariables.SetDataBufferVariable("NET_INCOME_WC" , netincomeWCDataBuffer , False) Dim netincomeUSDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("A#NET_INCOME:U2#US:U8#NONE") api.Data.FormulaVariables.SetDataBufferVariable("NET_INCOME_US" , netincomeUSData

Hi Guys,  I'm at a project where we use Data Cell Detail, we have created classifications and added 2 lines of test data. I can find the data via a data adapter Method query: But now i want to add it via a BRApi, i've found a post here but what ever I try i cannot get it to work. I have a cube view with 2 columns and the only difference is the UD8 member, so i first want to get the current data cell POV and set UD8 to None: Dim objMbrScrBldr = New MemberScriptBuilder() 'Apply current POV to memberscript and override UD8 api.Data.ApplyDataCellPkToMemberScriptBuilder(objMbrScrBldr, api.pov.GetDataCellPk(), True, True, True, True) objMbrScrBldr.SetUD8("None") Then I call the datacell containing the amount:  'Return the sum of the DataCells that contain the selected Classification Dim objDataCell As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, api.Pov.cube.name, objMbrScrBldr.GetMemberScript()) and check if the data has DataCellDetail: I

api.Data.Calculate("A#FCTR:F#EndBalanceLoad:I#None:O#Import:V#YTD:U1#00000:U2#00:U3#GL:U4#0000:U5#00:U6#00:U7#None:U8#None = A#Assets:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share - A#Liabilities:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share - A#Equity:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share") Error in formula: Error processing source script 'A#Assets:F#EndBalanceLoad:V#YTD:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:C#Share' or destination script 'A#FCTR:F#EndBalanceLoad:V#YTD:O#Import:I#None:U1#00000:U2#00:U3#GL:U4#0000:U5#00:U6#00'.Error processing data. The item was not found. Entity, Parent, -1.

I have the existing BR rule to export the region hierarchy which is working for last one year without any issues and I am trying to reuse the BR rule for country hierarchy export purpose. I copied & pasted the BR rules, and I am getting the error below while compling. Can you suggest what are all the possibilities to check these issues?   1) Error at line 313: Type 'SessionOptions' is not defined. 2) Error at line 315: 'Protocol' is not declared. It may be inaccessible due to its protection level. 3) Error at line 324: Type 'Session' is not defined. 4) Error at line 329: Type 'PGPLib' is not defined. 5) Error at line 338: Type 'TransferOptions' is not defined. 6) Error at line 339: Type 'TransferOperationResult' is not defined. 7) Error at line 340: 'TransferMode' is not declared. It may be inaccessible due to its protection level. 😎 Warning at line 18: Namespace or type specified in the Imports 'WinScp' doesn't contain any public member or cannot be found. Make sure the name

Hello, Is there a way to create a mapping rule for an account that looks at all entities but one?For example, A#123:E#*but E#456Thanks!

HI Am looking to lock the accounts (Rev first and then COGS ), such that if the Rev load is done i should be locking the Rev account for a particular scenario, then lock COGS account based on the Input deadlines. Can anyone help me on this Regards Narayana (BOYD Corporation)

Hello every expert: I am not able to reference a different scenario member in custom calculation business rule. I tried the following api.Data.Calculate("S#Forecast=S#Actual","A#10100" ...........) in the finance business rule I created. When I run the rule through Data Management Step, I have to specify Scenario and I select Forecast, I got error S#Actual is not valid dimension member when I run the business rule through custom calculate step. I really appreciate any helps from you. Thanks in advance.

Hi all, I have a member formula with simple calculation (e.g., Account A / Account B), and there is a data access security set up upon account A. I am wondering if a user without account A access, can the user be able to see the calculated result? My hunch is that it will show access on the end results, may I know how OneStream will handle this? Thank you.

Dear Team, while opening the cube view, I am experiencing issue " Value was either too large or too small for a Decimal."  I can see that in BR for EndBal, one of the divided formula causing the issue I am thinking. I am trying to add the divide function, but it is not working. any suggestions on the new formula?  0 Kudos   Accept as Solution Existing furmula: Return api.Data.GetDataCell("VariancePercent(A#AVG_Daily_Sales:T#POV:U8#None,A#AVG_Daily_Sales:T#POVPrior12:S#Actual:U8#None)/100")   New furmula: Return api.Data.GetDataCell("(VariancePercent(Divide(A#AVG_Daily_Sales:T#POV:U8#None,A#AVG_Daily_Sales:T#POVPrior12:S#Actual:U8#None)),100)")    

I would like to give my users the ability to launch the DM sequence from the workflow step. I have the dashboard with the button that passes the parameters to the DM package and launches the package. The last step in the DM sequence runs the Extensibility BR that completes the workflow step. Everything seems to work except that the workflow step window does not refresh after the sequence completion. The workflow step appears incomplete even though it is. The click on the "refresh Application" icon is required. Is there a way to address it? My Extensible BR is below:  

This is a doubt with the rest of the questions I have, and is that in the new workflow I created, when I hit complete worklfow there are two data management that are not executed (COPY_PLP_TO_PLN, PROCESS_PLP), which are below, but I try it in other workflows and it works correctly. Then I wanted to know how I can solve this in the new workflow, so that when I complete the workflow it also runs those data management as in the others.    

Is there any way I Can enter a +ve or -ve value based on the text property if a Flow member in a form. I think a Save Data Event Handler can, but I will throw an error if the only after the form is saved. What if the cell color will change (Just like in Excel) if the value enter on the form  should  +ve or -ve value based on the text property if a Flow member. is this achievable.   TIA, Nik

Hi Everyone. I wanted to know if there is a way to send emails that are made with parcel service automatically, for example, to send a certain number of days at a certain time, I would appreciate if you could help me to do something like that.  

I want to run a DM job from a dashboard (with the task popup showing progress, so no background running) and then when finished have the originating dashboard refresh after updating a parameter used in the dashboard.   If I call the DM job directly from the dashboard I am not sure how to return a task result that will update the parameter value in the dashboard.  I tried using a BR that called a DM job and then updated the parameter and refreshed the screen. However, when running it this way the popup did not appear and it just froze the screen, sort of negating the value of using the DM job.  Has anyone successfuly tried to do something like this before?

Hi all I like to check a manual data entry during save. Is this possible?  

Hello, I have a list of segments in WFText2 that I use as UD2 dropdown selection for my cube view.    So whenever I open my Form/Cube View I can see all segments excluding GBA_021, GBA031, GBA_032 and GBDP_001,  in UD2 Dropdown selection. My dilemma is, I am creating a confirmation rule that will loop for each UD2 that were not stated to be removed. I use this to get Text2: Dim WFText2 As String = brapi.Workflow.Metadata.GetProfile(si,si.WorkflowClusterPk.ProfileKey).GetAttributeValue(ScenarioTypeID.ScenarioType1, SharedConstants.WorkflowProfileAttributeIndexes.Text2) And the entire UD2: Dim GBA As List(Of Member) = api.Members.GetBaseMembers(api.Pov.ud2Dim.DimPk, api.Members.GetMemberId(dimtype.ud2.Id,"gba")) I initially used this GBA in my confirmation rule but it also includes those that were removed in WFText2 in the loop.   Any advise would be helpful.