OneStream Platform Forums

I've got a Tableview embedded in an Excel workbook and would like to be able to prompt the user to select an entity and period that is then used to filter records. Is this possible?

Hi OS Community,  Was wondering if anyone has visibility into or can point me in the direction to update the Environment Color in an application?   I know it can be done, thinking it might be the Config Utility or SNOW request, just having trouble finding documentation on the process to update.  The guide says all you need is admin access:  But I'm finding that not to be the case in multiple environments Any help would be greatly appreciated!      

I would like to set a transformation rule that particular account can be map to 2 accounts with condition +/- amount. Example, if positive go asset account, if negative go liability account. I had tried derivative rule is seem not working. After validate it become go to both accounts. Is there any missing caused the rule not work properly?        

Looking for function in the business rules to derive prior quarter based on the year and month value passed from parameter?

I am trying to create a conditional formatting code to convert a large percentage result in a percent variance column to replace it with text ("nm").  Can anyone provide the conditional formatting text that would replace the actual % variance with text?

In the D&R document it is mentioned "Using Extensible Dimensionality to extend Accounts used within the Intercompany Matching process is not a recommended practice".  is there any particular reason for this? or is there any documentation showing this as an example?

I want format the Cube view cell based on cell amountIf (CellAmount > GetDataCell(CVC(Col2)) )ThenBackgroundColor = Red, TextColor = WhiteEnd if This code is not working, Actually I am comparing actual amount with budget. how can we do this?  

Hello, I used to work on v7.4. When we worked on cube views, changes were saved in Cube Views. It worked perfectly. Recently I began to work on v8.0.0, I noticed that when changing a Cube View, OS opens a second window for the same Cube View under CV Groups of Workspaces. If we make changes in one of the windows without refreshing, and then we modify in the other window, it doesn't take previous changes into account. It's just like the issue when two persons work in the same business rule. Do you have a solution for this issue apart from updating OS version ? Many thanks in advance.

We have a client with a custom font that they would like to apply to reports that are exported to PDF. Has anyone come across this as an option? Thank you

The SQLTableEditor in question is used for user interactive CRUD pertaining to Rates used in a calculation.Use Case:I have a SQLTableEditor that holds rates.  When the table Save button is clicked, A BR saves the rates and runs a calculation.  The results of the calculation are displayed in an adjacent dashboard containing a DataGrid.  The DataGrid needs to be refreshed after the Save button is clicked.Question:How do I configure the SQLTableEditor to refresh the adjacent dashboard on clicking the Save Button, in a way similar to configuring the "Save Action" of other components?  

I would like additional information on the setting in Hybrid scenario for Use Input View for Adj in Calculations. This setting is currently set to True but some of adjustments booked in actuals are not flowing to the Hybrid scenario. However if this is set to False, the adjustments are reflected in Hybrid scenario.  

Hi all, does this 2021 OS community post by OneStream still hold true? I would like the cells from the FTE row to be formatted in a certain way (for example set the background to red) when the FTE check cell amount is not zero. Is there a way other than the XFBR they suggest (which looks like an overkill for what I need to do)?Thank you

Hello, Can we figure out sibling sort order for existing members and add the new members at a specific position in hierarchy through extensibility rule? Any samples would be helpful.

Hey everyone! Wanted to reach out and see if there was a simple way to include banded rows (every other row highlighted a different shade) into CV formatting within the application. Thanks for the help!

When i go to create time profile, i can see Months and weeks. Is there any documentation available how to create days?

Does anybody know in which table are Transformation rules mapping stored? Thanks

Is there a way to have a nested parameter with different dimensions? Example: If I select Year = 2020, the next prompt will ask me to select a Scenario The example I saw in the Design & Reference Guide used the same dimension, so I'm not sure if this is possible. 

Hello, I an trying to write a calculation to divide one number by another one and have it to flow into a new account. Below is the formula I am using, but I am not getting the date to calculate. Can someone assist on how to write it correctly.    Calculate("A#mpg test","Divide(A#33010, A#33005)",deptFilter)

I am trying to export Data including dynamically calculated accounts using a DataBuffer (Not just base members but all intermediate levels).I can do this by looping over Accounts+U1+U2 combined with GetDataCell()... but it is unbearably long and inefficientI am wondering if we can use a data buffer this way ? If not what would the best method be ?  Dim MFEntity As String = "E#TopEntity.TreeDescendants.Where(Text1 Contains 'myValue')" Dim lstofEntities As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "Entity_Dimension", MFEntity, True) Dim MFAccounts As String = "A#Root.Base.Where(AccountType = 'DynamicCalc')" Dim lstofAccounts As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "Account_Dimension", MFAccounts, True) Dim lstofAccountsStr As String = String.Join(", ", lstofAccounts.Select(Function(x) "A#" & x.Member.Name).ToList()) For Each myEntity In lstofEntities Dim mfDataBuffer As String = "FilterMembers(E#" & myEn

Hi, We are facing a strange issue with Excel QuickViews.  When a non-admin user tries simple quick view, user is getting below message. But when admin tries, he is getting all of the data in single page. We have tried changing all the settings on Max rows, Max seconds, almost 100s of combinations (from 1000 to Billion) but no luck.  Any thoughts on why this is happening? We are using slice security for users. Page 1. Use row paging buttons in Task Pane.

Hi, I have a workflow with a certification as the last step. I can change the status of the questionnaire every month except December. I am an administrator user.  Dec:     Nov:         Do you know how to activate the option in December? Regards, Sara.  

Hello, I am using a cube view that has the same rows, but it needs different columns based on the UD8 member. I built multiple template columns cube views, and created a parameter for UD8 members. I want to retrieve the column template CV based on the selection of UD8. I created the following XFBR: I then attached it to the main Cube View: When I run it, and select UD8, nothing appears: If I put directly the template name, the cube view runs with no issues, showing data as well. Any idea why it is not working? Thanks, Ioana    

Hi - Has anyone done WEBAPI through SIC ? I followed the document and I am not successful connecting to the endpoint. All I am trying to get the HTTP response. There are no issue from the firewall and thr port are open. We are able to successfully execute the endpoint from POSTMAN.   Any help would be appreciated.   Thanks    

Hi,Can OneStream consume Json data (retrieved with a API from 3rd party system) or must it be converted?Thanks

We have several workflows that for audit backup we have the users attach documents.  With employee turnover the next person didn't know they had to attach the document.  Is there something like an After Event rule you can do to check that something was attached or in a confirmation step?