OneStream Platform Forums

Hi all, We have a Global Chart of Accounts that is used for both our Statutory and Management reporting. For our management reports, there is a requirement to have expense items below OP showing as negative - such as Tax, Interest, Depreciation etc. Opex accounts above OP will be shown as positive, as is currently happening. I understand this could be done by allocating the sign flip to the specific accounts in the transformation rules and/or changing the account type to Revenue, however, this is only relevant for the Mgmt set of reports, not the Stat reports. I'm interested in seeing if anyone has any ideas for how to show different signage on certain reports, rather than applying them all reports. On the cube views, the rows currently us A#M_NPAT.base for the entire CoA . Thanks in advance. Andrew  

Hi Experts, I would like to store existing cell destination value to temp variable so as to write back to destination by appending of source cell value using databuffer - with the following script i have written can only copy source cell to destination, but it does not append if the value is already exist in destination prior to write from source cell amounts.( I need because multiple source values are writing up to same destination then each time it is getting replaced already existing value- which is not correct as per the business case) Dim ResulDataBuf As DataBuffer = New DataBuffer() Dim DestinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("V#Periodic") Dim DataBufFilter As DataBuffer = Api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic),[A#[root].base.Where((Text1 <> "")And (Text2 <> ""))]") DataBufFilter.LogDataBuffer(api, "records", 100) For Each sourceCell As DataBuffercell In DataBufFilter.DataBufferCells.Values Di

Hi All, I have written below rule where, I am not able to see the results, But rule is executed without any errors. Rule is about : Writing up the source values based on the Tex1 and Tex2 assigned in the source Accounts. where Text1 & Text2 are target Intersections to to actually be written to... Kindly help me if something is missing in the code. Dim ResulDataBuf As DataBuffer = New DataBuffer() Dim DestinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("V#Periodic") Dim DataBufFilter As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic,[A#[BS].Base.Where(Text1 <> vbnullstring And Text2 <> vbnullstring)])") For Each sourceCell As DataBuffercell In DataBufFilter.DataBufferCells.Values Dim cashflowCell As New DataBufferCell(sourceCell) 'Temp buffercell within the loop to copy my cashflow cell Dim sText1 As String = api.Account.Text(cashflowCell.DataBufferCellPk.AccountId, 1) 'Source Mvmt Dim sText2 As String = a

Hi Experts,I am trying to read the member ID in data buffer to assign some values accordingly, But it is giving in correct ID seemsin the log file i can see ID as "-1" , Generally Member ID was different in the dimension library if this is readying correctly - Kindly confirmDim vSrcUD2Split As String() = Split(sText2,":")Dim GetUD1Ac As String = Trim(vSrcUD2Split(0)):Dim GetUD1Mvt As String = Trim(vSrcUD2Split(1))Dim vTgtActID As Integer = api.Members.GetMember(DimType.Account.Id,GetUD1Ac).MemberPk.MemberIDapi.LogMessage(vTgtActID) Outcome is : -1

Hi,I'm using a Derivative Check Rule for the first time - using the sample available in GolfStream (HoustonSalesDetailOffset > ValidateCheckSum) - the Rule itself is working fine, I am getting the correct Pass/Fail Status.  My question is where can I expect to see the CheckRuleMessage displayed?GolfStream Sample: My Result (partial screenshot only as from Client App):It feels like there's a column missing from the screen?  Or perhaps it should be a pop-up window on the right like with other Validation/Intersection errors?Thanks in advance for any help!

I have 50 rows and 4 columns, here I have to do a calculation with cell wise.For eg: col4row20 = col1row1 / col1row10             col4row21 = col1row2/col1row11             col4row22 = col1row3/col1row12Likewise I need to input the multiple formulas for the cells, here what type of member formula I can use.

Is it possible to use the right click - Navigate button in a quickview?This button shows up but it is greyed out.  I would like to see if there is a way to navigate to a dashboard similar to creating a linked dashboard in a cube view.  It would pass the default parameters (ie EntityNavLink) from the quickview.     

I have a case where the client needs to add members to a dimension regularly and the ADM, Add Dimension Members, dashboard is idea as found in GolfStream.  However, there is a problem in the ADM_SolutionHelper rule that stops this from running.  It doesn't compile properly. Error compiling Business Rule 'ADM_SolutionHelper'. 1) Error at line 136: Property 'Name' is 'ReadOnly'. 2) Error at line 137: Property 'DimId' is 'ReadOnly'. Can someone explain how to resolve this please.  

Hi, I'm trying to copy data from Actuals into Forecast,  but it seems to only work for Input and Forms Origin members, and not for Adj. Here is my formula, which I put on the Forecast Scenario: 'Copy data from Source Scenario for months 1-5 Dim currMonthNum As Integer = api.Time.GetPeriodNumFromId(api.Pov.Time.MemberId) Dim sScenario As String Dim ScenarioSource As String = api.Scenario.Text(api.Pov.Scenario.MemberId, 1) If ScenarioSource = "" Then sScenario = api.Pov.Scenario.Name Else sScenario = ScenarioSource End If If currMonthNum = 1 Or currMonthNum = 2 Or currMonthNum = 3 Or currMonthNum = 4 Or currMonthNum = 5 Then If api.Cons.IsLocalCurrencyforEntity() And Not api.Entity.HasChildren() Then api.Data.Calculate("S#Forecast2:A#All = S#" & sScenario & ":A#All") api.Data.Calculate("S#Forecast2:A#All:O#AdjInput = S#" & sScenario & ":A#All:O#AdjInput") End If End If Not sure what I'm doing wrong.  Any ideas?   Thanks!

Does anyone know if it's possible to access XFStrings through Business Rules? We are adding other languages to our application and we are using XFStrings for Cube Views and Dashboards. We want to present our custom BR error messages in the user's chosen language so we thought XFStrings would be a good place to keep them. However we don't know if it's possible and if it is possible, how to do it. We are currently using Transformation Rules for some other areas but we want to have a single place where the translations can be managed. Thanks

Hello,   I am looking for help with the quick view functionality. We are moving from HFM, and when creating back up for certain journal entries/rollforwards in HFM ad-hoc excel files, we would type POV:{} in the header of the spreadsheet so that when the file was printed it would also show the POV members used to generate the data in the spreadsheet. I have included an example. Does anyone know how to accomplish something similar through quickview? Thanks!  

Hi,I have a data management step which runs an extensibility rule. In the rule I am using the “Throw New XFUserMsgException” command to return error messages.For example:Throw New XFUserMsgException(si,"","","Error: Copy cannot be completed. Source Scenario/Year must be different from target Scenario/Year")Gives the following result when conditions are met: When the step completes without error a box message appears, like the following one: How can I control the message shown when the step is successfully completed? I.e., how do I return a message in a box message without throwing an error?

Hi All,We have a requirement where we need to write a custom consolidation rule for Subsidiary(Method) entities.Kindly provide us with a sample business rule along with the functions to be used. so that we can modify as per the business need.Requirement:1) Subsidiary: Entity owned at = 57%.2) The Subsidiaries financial statements are consolidated and eliminated. 3) The Equity associated with the subs financial statements are eliminated against the Holding companies Investment in the sub. 4) The owned portion of Equity is eliminated and the unowned portion is reclassed to Minority Interestregards,BCG

Requesting OneStream to add a DateTime component for easy use by developers, at present textbox has been used everywhere to capture date from users in custom applications.

I am able to display it in data explorer but unable to display in PDF report.

Got a task to copy certain file from FileShare to Documents\Public because users security settings. Wanted to go with the standard System.IO.File.Copy(strSourceFile,strTargetFile) where source and targets are sting.   Can get full source file path using the FileShareFolderHelper. However can't get full path to the target, that is under FileSystemLocation.ApplicationDatabase.    Any suggestions how can I get the target path or otherwise copy the file in question?

Within the Extender business rule used to integrate with our ERP system I would like to loop through all the "Import" steps  within a specific node of workflow hierarchy and to read the values of the "TextX" properties. I've heard that this is possible but have no idea where to start. Any guidance would be greatly appreciated. Yan

Hi All, I need to share few specified columns  from one Cube View to another, Can anyone suggest how to use specified  columns in Cube Views.     Thanks in Advance.

Dear Community Users, We have Blank rows and Blank Columns for the space convention. I'm getting 0s for both blank rows and columns while generating the report. I used below condition: and even tried hard coding 'ReportNoDataNumberFormat = #' in all blank rows and columns. Couldn't be able to resolve it. Any solutions to this are really appreciated. Thanks. If (RowName Contains 'Blank') And (ColName Contains 'Blank') ThenReportNoDataNumberFormat = #ElseReportNoDataNumberFormat = [$#,###,0.00;($#,###,0.00);0.00]End If

Is there a way to report first Value for Each Time Period similar to TB First setting in Essbase? M1 .. M12 M1 Value to be shown for FY

Dear Community  We want to update an application from the 6.8.1 version to 7.3.3 of OneStream.  Is there any possibility that the member ID could change from one version to another?  Thank you in advance 

When I develop cube views, is it possible to have the description in the header for the data in the rows, for instance first column might be Account, second column Customer.  When I extract the cube view the header for these is blank and I have to manually insert a description to the dimension is relating.  Same issue occurs with quickviews.   Any solutions

We in the process of data validation and are constantly getting  "Exception of type 'System.OutOfMemoryException' was thrown." I know in hyperion we should change the time out.  Is there something similar we can do with onestream?      

In the prior version of onestream we had configured AAD authentication, and we had a service principal that would be used to process REST API requests (aka the onestream "web api").  This service principal was simply to make all the requests for gettting data (cubeviews, adapters). However since we upgraded to 7.1, the REST API has stopped working.  Whenever we present the onestream-web-api with the access token from AAD, it simply generates a bogus error: No Supported Authorization Provider Configured.   The reason the error seems bogus is because the AAD authentication provider is working for all interactive users.  It is only this particular AAD service principal that fails (the one associated with this REST api). We noticed that the release notes for 7.1.0 says: Microsoft is ending support for Azure Active Directory Authentication Library (ADAL) in December 2022. As a result, we have migrated to the Microsoft Authentication Library (MSAL) for authentication

Dear Community Users, As you can see in the above image, last character of the data [i.e., ')'] is getting printed in the next row of the report. I have tried increasing the width of the row. But it's not working. Any solutions to this are really appreciated. Thanks.