Rules

Hi, I need to copy data between 2 cubes . they both use different Entity Dimensions . Not Extended ones.so is there any way I can map the entities . I am using customcalculate DM with the Destination Data Units  to run finance rule. I have given the Source Entity and destination Entity in the Corresponding DataBuffers. But when I give  api.Data.ConvertDataBuffer("sourceCube","SourceScenario", databufferConvInfo, sourceDataBuffer). I am getting Error Saying "the Cube and Entity Are invalid or Incompatible". What is the issue ? Thanks.

Hi Community, I have a rule that is using DataBuffer to copy data from 1 cube to another. The 2 cubes use separate Flow Dimensions . right now I have given in the following way : Is there any way I can give individual mappings of the base members instead of copying parent data. For example :Suppose BGBAL and EBAL are base members of F#SF_Movement. Map F#BGBAL in source Dimension to  F#BegBal in Destination Map #EBAL in Source Dimension to  F#EndBal. in Destination Is such data mapping possible ?. Thanks for the help.  

Dear Community Members,I have cloned the Blueprint OSB_CustomTranslate to apply code when FunctionType FxRate fires. My cube is set to Standard Using Business Rules for FxRates.My business rule is set as Business Rule 1 (and 2 as a matter of fact for logging purposes only).I am running Translate, Custom Translate, Consolidate, ForceConsolidate but i cannot get the FXRate FunctionType to fire.  I am logging in the rule to get a log message for every different FunctionType that fires.  Getting Calculate but not FXRate.Any tips would be much appreciated.  I am sure the resolution will be utterly embarassing but i am at the end of my wits.

Hi, I am trying to build C# finance BR where scenario is being pulled from POV but how to use in api.data.calculate function. If its VB then I can use with & but C# its not working.

Hi, Has anyone updated and added new member in metadata by using extender rule by picking the member information from SQL table or any other data warehouse? Table contains most of the information related member in OneStream and their member properties. If anyone has done similar kind of implementation, please let me know. Thanks.

I'm able to extract the monthly csv files uploaded using BRAPi.Import.Data.ExportStageArchives, but this doesn't seem to work for multiperiod uploads (specifically budget) or I'm just referencing a parameter incorrectly. I've tried entering the time parameter as "2021", "2021M12", "2021M1", even "2021M1-2021M12" within the business rule, but nothing is exported at all for the Budget scenario.... Any ideas?  

Hello, I have connection string written to connect to SAP Dim r3Conn As R3Connection = BRApi.Database.CreateSAPConnection(si, "ConnectionName", True) I want to know where the ConnectionName is confirgured.  I have the error massage which is pointing to IP which is not in our network.  Unable to execute Business Rule 'SAP_TB_ALL'. RfcOpenEx failed(RFC_ERROR_COMMUNICATION): SAP_CMINIT3 : rc=20 > Connect to SAP gateway failedConnect_PM  GWHOST=10.4.16.9, GWSERV=sapgw00, SYSNR=00   LOCATION    CPIC (TCP/IP) on local hostERROR       partner '10.4.16.9:3300' not reachedTIME        Tue Jul 09 12:38:29 202RELEASE     701COMPONENT   NI (network interface)VERSION     38RC          -10MODULE      nixxi.cppLINE        2845DETAIL  &nbs

Hi OS Experts: While I am running the ForceConsolidation in cube view, I am getting the below error message. Are there any possibilities of this error: Error calculating member 'EndBal_Calc' in dimension 'Flows'. Unable to execute formula for member 'EndBal_Calc'. Invalid script 'A#NET:F#EndBal:V#YTD:O#Top:I#Top:U1#USACAP:U2#TOT_DEPT:U3#TOT_PROJ:U8#None:E#' near 'E# I am checking the EndBal_Calc in flow dimension the calculation has been working from many years correctly but this time the strange issue. any suggestion. I see the similar error for the different entities' different runs.

Hi All,   I get an the following error message: Invalid calculation script. A comma was expected after ABN.With the Syntax as show below: What am i doing wrong? Both names exist in the rows of the report.  

Is there a way to save entries in Cell Details using a business rule?

Hi All: I have ran the workflow to copy the Actuals to Forecast and the data got copied over successfully. while validating the balance sheet for the certain IC plug accounts, Etiquity accounts the data is not matching Actuals versus Forecast. For example, the below.   I narrow down to the issue, I can see that the difference coming from historical override adjustment and beginning balance. I am not quite sure how to narrow down further to fix this issue, any leads/suggestion to check on this to fix?    

Hi Everyone. What I want to do is to obtain the child entities of an element, to save them in a variable and compare them with the entities that are traversed in a data management, I would like to know how I can do this in addition to how I can get in a BR the value of an intersection, as if it were in excel. Example the childrens of this.  

I have SIC version 8.2.1 I already created the gateway and is online, is a Direct connect type configured to connect with SAP I already install the SAP dll in the SIC local When I try to compile my SIF in the Onestream App asks me for the Gateway, but I can't see my direct connect gateway, only shows the Database Gateway What I'm doing wrong?   Regards

Hello - I'm looking for a formula to calculate data from one entity to another for two specific accounts. I would just use a standard data management job for this since the amounts are not changing, however I want the sign to change, so the amounts will net to zero when the entities are consolidated in the same structure. Can I use api.data.calculate for this? And if so, would the formula be stored on the two accounts? 

Hello All,We are having a requirement where we need to export Dynamic Calc members through FDX. We have few dynamic accounts which are complex and it refers to different time periods like (T#POVPrior, T#2023, T#2022). So whenever we run the export, it generates a very huge amount of error logs , 1 Million, referring to the T# Summary: Error processing script '((Divide(A#ABC:U8#Sample,A#DEF:U8#None))*100)'. Unable to execute formula for member 'ABC'. Invalid script 'A#DEF:I#Top:T#LastActualPeriod- A#IJK:V#YTD' near 'T#'Here LastActualPeriod will be calculated based on current actual period, Example T#2022M1Any idea why this happens and any alternate ideas to come out of this and export the Dyn Calc Accounts.Thanks in advance for your help !

Dear OneStream Experts: Thank you so much for the great help in the past. I am converting one Hyperion Planning application to OneStream application and would like to know how to use if statement to check calculation flag. For example: I have 3 dimensions Account dimension has the following 3 members Sales Rebate Rebate_Flag UD1 - Product Dimension has many Members TOTAL_Product  Parent member with children(Product_1,Product_2,Product_3,,,,,,Product_N). No_Product UD2 - Country of Sale Dimension has one parent member ALL_Country and 2 children members ALL_Country   USA   Canada In Hyperion application, I have Rebate_Flag->USA->No_Product =1 Rebate_Flag->Canada->No_Product =2 I want to calculate Rebate only when Rebate_Flag=1. In OneStream, I want to do api.Data.Calculation("A#Rebate=A#Sales * 0.10", "UD1#Total_Product.base",true) But how to I apply the if logic. In Hyperion, I can do Fix(@Relative("All_Country",0),@Relative("TOTAL_Product",0)) If("Rebate_Flag

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?