OneStream Platform Forums

Has anyone found a use for the brapi function CreateSessionInfoForAnotherApp? If yes, can you please explain it as I cannot seem to find any documentation on this function.  This is the example I'm seeing in BR: Dim si As SessionInfo = BRApi.Security.Authorization.CreateSessionInfoForAnotherApp(siSource, appName, openAppResult)   How do we setup the siSource sessionInfo parameter? Assuming that siSource needs to be initialized with info from the sessionInfo from another active app connection? What can we then do with the si from another application? 🤔  

Hello again, it seems that the error was not completely corrected, so I have the same problem as my previous post. Scenario 'Forecast 2023M10’s workflow settings do not allow input for Time member ‘2023M9’. I know this is a bit strange, but I need to modify values from the previous month. For example, now that I’m in November, I want to affect September. In February, it allows me to make these modifications because it’s still possible, but I want to do the same for the following months. The function value gives me as a form and I believe it is necessary to pass it to import, but I have no idea how to do it. For Each strItem As String In ({"Amount", "Annotation"}) Dim listTargetDC As New List(Of DataCellEx) For Each drResult As DataRow In dtResult.Rows Dim dcpkTarget As DataCellPk = drResult("DataCellPk") If strItem.Equals("Annotation") Then dcpkTarget.ViewId = BRApi.Finance.View.GetIdFromName(si, "Annotation") End If

How do I see if my OneStream application has Drivers based forecasting? Is it a separate module or workflow profile?

Hi All,   I have a dimension hierarchy like Account1(parent) and Account2(parent) hierarchy members in Account Dimension and i need those base members in the same row/column. I tried adding those members and got below error, can anyone suggest how to resolve this. Thanks in Advance.

Hello, We're building our Planning module and was wondering we have management fees that we get from our corporate office. They come in as USD. Is there a way that we can load in USD and translate them back in to Local Currency for the entities? This is a one time yearly load and didn't know if it was possible or if we have to calculate it to local currency and then load it? Thanks, Will

Hello, I am trying to insert an excel file (tab) into a book that will export to excel. The purpose of the file is to insert a tab as a separator between report tabs so that the name of this excel tab denotes the type of reports that come next. I am having trouble inserting an excel file so I have created a work around by creating a blank cube view and giving it the output name that I want it to have and then brining that "report" into the book, but I don't feel like I should have to do that. If anyone has any knowledge on adding an excel file to a book, that would be great. Thanks!

Our team uses cubes views for reporting.  Often times they will highlight a cell for analysis purposes in a separate color, however when they refresh the cube view the color reverts back to the original color.  Is there a way to keep color, upon refresh.    

Hai Everyone! Does any one know business rule to create a new member in a dimension using business rule by extender.If anyone knows please let me know and Share me the VB.net code.

Hi everyone. I have a problem with setdatacells, and it sends the following error: Scenario 'Forecast 2023M10’s workflow settings do not allow input for Time member ‘2023M9’. I know this is a bit strange, but I need to modify values from the previous month. For example, now that I’m in November, I want to affect September. In February, it allows me to make these modifications because it’s still possible, but I want to do the same for the following months. The function value gives me as a form and I believe it is necessary to pass it to import, but I have no idea how to do it. For Each strItem As String In ({"Amount", "Annotation"}) Dim listTargetDC As New List(Of DataCellEx) For Each drResult As DataRow In dtResult.Rows Dim dcpkTarget As DataCellPk = drResult("DataCellPk") If strItem.Equals("Annotation") Then dcpkTarget.ViewId = BRApi.Finance.View.GetIdFromName(si, "Annotation") End If Dim dcTarget As New DataCell(dcpk

Hi Everyone, Here's a (hopefully!) simple question to see if anyone has done this... I want a confirmation to run but only after T#2022M12 and onwards so that if a workflow was ever run in the past for some reason then this confirmation rule would not be triggered. I've played around with the Frequency Member Filter in confirmation rules but haven't got it to work. I want to to say something like: "Where Time > 2022M12" but obviously in the correct syntax. Is something like this possible? Thanks! Richard

Hi all, I'm bit new in developing rules in one stream and I have a simple question. I'm trying to retrieve the accountId member name from a member formula on the account itself. I'm using the below code but it seems api.Pov.Account.Name is not working, if I replace it with the account name it works. Dim AcctName As String = api.Pov.Account.NameDim AcctId As Integer = api.Members.GetMember(DimType.Account.Id,AcctName).MemberId Any suggestion?

Hi All, For a Bi Viewer Dashboard I use a Cube View which calculates values with a GetDataCell calculation. I display the values in a line chart. The values are displayed correctly, but the calculated variable name in the legend does not match the defined name in the Cube View calculation, instead the first used account name from the calculation is used. How can I use the name I defined in the cube view cell in BI Viewer, or if it is not possible, how can I rename the variable name manually in BI Viewer?

Im trying to create a formula for one of our Statistical Cal accounts.  Its a derivation of of a calc we already have.  However the line will no compile even when I copy the existing formula completely. Return api.Data.GetDataCell("(Divide(A#1200:I#None,A#TTM_Net_Sales_wo_IC)) * 365)") I can compile the existing account without issue, but when I copy this formula into the new account I get an error  

Dear Community, I am using FdxExecuteDataUnitTimePivot for getting my data in Time column wise manner. I need to display it in Time columns under which account columns should be created. Is there any way to create sub columns . I will attach screenshot for reference.  

Hello everyone, We have a client that uses 13 period time dimension in their current system that we are moving to onestream at the moment. They use period 13 to load TB' post adjustments even input disclosures  currently.We first wanted to use a UD dimension to capture it but I'm more and more leaning towards having custom 13 period time dimension to cater that. I know that is something that needs to be set up during application creation so I'm guessing we need a new application. Is that something to be requested from OneStream to set up?I also would love to hear if any of you had a similar case and how you handled it. 

Hi, I have a (.csv) file in my File Share Folder that I want to read and load into the cube using a Workflow Profile. I have written an extensibility rule for getting that file and reading the file contents and creating a Data Table. now what should I do next? Is this the right approach or is there any other way to accomplish this? Below is the code of the Extensibility rule. Thanks

Hi all I accidentally deleted a Business Rule by loading a XML file with an older version on top of it. Is there any way to recover it? Cheers

Hi everyone. I’m working on a cube view, and I have a variable that handles the scenario, and I want another column to have the PY of that selected scenario, so if you could help me know how this can be done. Example for the scenario to modify.  

Hey folks, We have a requirement to define range of rows in a GetDataCell. For example: GetDataCell(CVR(Row1) + CVR(Row2) + CVR(Row3)..... CVR(Row100))Instead of defining it manually till Row100, Is there any way to give a range like this GetDataCell(CVR(Row1):CVR(Row100)) ?Any solution to this will be helpful. Thanks. 

I would like to see just the current form profile and related cubeview to be seen as "Required" option. I dont want to see this "Deprecated" options. Does anyone know how to change this? I couldn't find an option in the workflow profile.   

Hi Community...! Here I'm getting Zero but instead of this I want to get  accounts data for that...Can you please share me some insights or some reference for this...?I'm using FDXExecuteDataunit method for this  

I have a question with the documents web.config how does that document needs to be configurated? So I can access onestream demo    

Hello Community I have data sorted in descending order in Data Adapter. But when that data is imported to BI Viewer I am not getting in descending order or any other sorting order. 

Hello, I have a workflow step of type 'Workspace, Certify'. Through a workspace button, I am able to complete/revert the step. I am wondering If I can navigate to the 'Certify' window automatically upon completing workspace through a business rule, or we can only do so manually ?

Looking for help to display Text data in a cube view.  I'm using the member filter below which works for every account type EXCEPT  DynamicCalc.   Account Type set under Settings in the Member Properties (see below).  U8#Acct_Text3:V#Annotation