ContributionsMost RecentMost LikesSolutionsCommunity Terms of Service The Following are the Terms of Service for The OneStream Community. Use of the OneStream Community Site indicates you accept these terms and waive any further objections to these terms or future m...Are there any updates on merge and center on headers for cube views? ...For example, center months across six columns. Answer: This is now available in PDF reports from 7.1 and in Data Explorer from 8.2. Is there a list of valid font families for Cube Views? Answer Standard Microsoft supported fonts are utilized in OneStream Source: Office Hours 2020-05-17 Partner Enablement Update 07/02/2024 Note that one can use any font that has been ins...Aggregating a tagged set of accounts (e.g. Balance Sheet only) This is an example to obtain values for a Cash Flow formula for all accounts tagged with a certain Text1 field. For every Account tagged CF_AR (Cash Flow - Accounts Receivable) and evaluating the ...Intercompany security issue across cubes Originally posted by Katarina Sterley We have 4 extensions to our main cube and now we have a problem with the standard intercompany matching reports. The end users do not see the transactions on...Re: The case is that for some groups the customer can have up to 9 plus users associated to a group but in the template, it is only planned for up to 5 children Originally posted by Sarah Park here's one that I updated that takes up to 14 users/groups. I tried extending it out for beyond that but the excel formula stopped recognizing my cell references, so...Can you sort entities returned by the WorflowProfileEntities Method query? Question The Method query WorkflowProfileEntities, available on Parameters and Data Adapters, returns an unsorted list of entities assigned to the WF Profile. How can we sort it? Answer There...Dashboard: Open Dashboard File Resource Open a Dashboard file resource and retrieve its raw contents. Note: This snippet is for OneStream 7.4 and above. Previous releases can use similar logic, just without the WorkspaceID machinery. ...Finance: Return on Capital Employed This formula calculates a financial ratio that measures a company's profitability and the efficiency with which its capital is employed. The main financial logic in the formula is EBIT / (Total A...Finance: Annualized Revenue This Dynamic Calc formula calculates Annualized Revenue, by taking 3 months of Total Revenue, dividing it down to a monthly amount, then multiplying it by 12. ' "Prior Scenario" must be stored a...