OneStream Platform Forums

Is there a way to exclude a tab in a book if that tab has no data? I have a cost center loop added to a book. The loop includes all cost centers, although I know some cost centers have no data. I want to make sure we aren't excluding any cost centers in the event an old cost center is used. I'm trying to ensure the report is complete. However, adding all cost centers to the loop results in many completely blank tabs. Is there a way to suppress these tabs or exclude them from the output?

If I have a dashboard gridview of Stage table data, is it possible to execute a drillback to a source system directly from the gridview?

I'm trying to use the DataBuffer.GetFilteredDataBuffer() function which returns a DataBuffer.  This function takes two parameters as follows: 1. DimTypeForFilter as DimType;  If I'm filtering for accounts this is DimType.Account.  DimType.UD1 for UD1, etc. 2. Now I'm having trouble with the second parameter.  memberIdsInFilter As Dictionary(Of Integer, Object) I find no examples on this.  Please help with an example.  

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