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? 🤔  

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.

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.    

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

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. 

We have a combo-box for entity selection on a dashboard however, it only allows a user to select 1 entity at a time. How do I make that comb-box open to multi-select 2 or more entities? I do not see a multi-select true or false option on the combo box form. Parameter: Combo Box: In Dashboard:        

Thought this was cool and wanted to share so others have the recipe.  If you build a default landing Home Page for users upon login, this is where the XML sits for that Dashboard.   Then, (I was thrilled) to discover this) once you have a default Dashboard set for users, the OneStream logo is now a clickable button!  It returns you to your Home Page Dashboard.    

Originally posted by Sam Richards 6/27/2019 Slice Security Question: I have a cube setup with restricting all access from all of my UD1 members. For some reason when I pull a UD1 in spreadsheet I can still see the data. It is probably something small I am missing but here are my setups. The bottom picture is the quick view I am using to test

Hi, I'm a little confused with a workflow security issue I have always assumed that locked and certified parents prevent the unlocking and modification of the workflow steps below it, however I have just tested and found this isn't the case. I have locked and certified a parent workflow, logged in with a test user that only has access to a single base entity but has the 'unlock workflow unit' security application security role and in my test I am able to unlock my base entity, make changes in forms and relock, all without disrupting the locked and certified status of the parent. Is that the expected functionality? Does anyone have a recommendation for updating the workflow unlocking so that it will only be allowed if the parent is also unlocked? In my first attempt at an eventhandler I ran into the issue that I couldn't access the locked/unlocked state of the parent workflow without the user also having access to the parent workflow

Hi, We have a user that is getting the error below while trying to refresh an excel file using Smartview.  I've had a look at the file, and it's nothing special. Just a few XFgetCell formulas, and it runs fine for me. Error: Index was out of range. Must be non-negative and less than the size of the collecion. Parameter name: index.   Any ideas folks?

Are there any steps that need to be taken for YE close in OneStream. Balances rollover P&L to R.E. and Opening balances for BS accounts. Do we just run a 2024 force consolidation? Any recommendations?

Hello, I am trying to pull data into OneStream from Snowflake using REST Api. Does anyone know how the entire process works and worked on it before .If anyone one can give a heads-up on this it would be of great help ,I have been going through few documents but not able to understand it up to the mark .If anyone has a business rule that I can use as reference and build my BR that is greatly appreciated.

Dear Community , Is it possible to use a business rule to download a file from the file explorer to the local system? Thank You

Hi all, I'm looking for a way to skip a dimension parent level in a Tree expansion while still maintaining a tree style view.  Does anyone know if this is possible? Alternatively, does anyone know of a way to declare an expansion MyHierarchy.Tree and include a .Where or .Remove clause?  I can't seem to get this to work for me so I wonder if it's just not possible using the "Tree" method. Example: Default Expansion based on .Tree expansion Parent 1     Child 2        Child 3            Base MemberDesired View (skip the Child3 parent):Parent 1      Child 2            Base Member

Hi,  Anyone has any idea how I can setup security to limit the users from seeing other entities but at the same time not impacting IC partner for IC Matching Report? The cube views are setup for all entities. When doing it via entity dimension - setting read access and read and write access, IC Matching report is affected as when performing intercompany, the user can't see their IC partner.

When loading a YTD feed for an entity, if that entity is terminated mid-year (possibly moved to a new entity due entity structure changes) the imputed periodic value translates at the current period FX rate causing there to be a residual USD value remaining in the first period where no balances exist.  This issue is discussed on page 77 of the Foundations book, however the explanation on that page seems to indicate that this is mathematically correct, and therefore seems to infer that it is therefore a correct accounting presentation.Has anyone found any combination of scenario, workflow, or cube settings that has prevented this from happening, or have you used a business rule or some other process to remove these values from periods where no activity or balances should appear?