OneStream Platform Forums

We would like to combine two of our cubes into one.  Some of the UD dimensions will change in the new combined cube.  Is it best to start with a new application?  Any suggestions?

Hello, I hope someone can help me out with the following issue.   We are trying to add the Report Header/Title to a report, but we would like to have it dynamically adjust to the width of the CV or Report itself (so also fill the yellow highlighted space). When I try "-1" (how you would do it in the CV settings) it becomes very small.   Furthermore, I would also like to remove the light blue line under the header (or make it the same color, dark blue). I tried to adjust this in 'Application | Application Properties | Standard Reports' but with no luck.   Thanks in advance for your help!      

When using a Parameter to specify a member in a CubeView, how do I specify which Workspace the Parameter is in?  

I am trying to create a Cube view report that should show English Description of Entity members istead of default Description. Is there any XF member property function to do the same or any other solution?   Thanks, Neha

Hi,   I'm trying to setup a variance account under UD8 that will calculate the variance between the current year last 12 months and the prior year last 12 moths. Any suggestions on how to write this formula? Thanks.

I have heard that Onestream supports ad-hoc queries and reporting. But I haven't yet found an easy way to send ad-hoc queries to our OneStream cubes. I'm searching for some sort of query interface like SQL, MDX, or DAX.   So far I've discovered that there is a REST API which allows me to retrieve data from an existing "cubeview". This is a helpful API for extracting data programmatically. But this certainly isn't considered "ad-hoc" since it requires that a cubeview be prepared and deployed in advance. I had also seen that the REST API supports SQL statements but I have been warned against using those; since it circumvents the logical definitions of the cube, and these queries might become fragile and break over time (eg. after future upgrades to the onestream platform). Besides those two options, what mechanism is available to send "ad-hoc" queries to OneStream, and immediately retrieve the results. Our CPM data is very valuable to client processes, and we've been able to accompl

Hello All, Need assistance in getting the USD Override amounts to populate Local Currency Parents in USD values.  The USD Parents are working correctly when data is retrieved in Local or USD. Example Local Curr Entity CNY (rate .800) - 2000, USD Override - 3000 USD Parent Entity (USD) - 3000 Local Currency Parent (CNY) -  CNY - 2000, USD - 1600

Hi all, I've created 6 separate cube views to replicate a pdf report that we send out monthly to the Board. The CV's themselves are not too big - say 10-15 columns by about 15 rows. In the report, we previously combine the 6 tables into 1 pdf across 2 pages - normally a cut and paste job from Excel.  Now that I have built the cube views, is there a way to combine all of these onto one or 2 pages in a Report Book? I have created a book now with them, but the CV reports print to separate pages. Because of this, they only take up 1/4 of the page, so there is a lot of white space and would then push the report out from 2 pages to 6 pages - not ideal to present to the board.  Alternatively, is there a dashboard layout where you can combine and export multiple CV's on the same page? My current dashboards are in the Tab layout with the CVs separated by tabs.  I know an easier option would be to create a large cube view and separate the reports with blank rows, but this isn't po

Hello, I need to create an advanced chart which shows two data bars, each bar is taken from a different cube view. I have tried to add the two Data Adapters which are each based on its own cube view, but the chart is displaying only data from the first cube. Is this possible by using the cube views data adapters or is it needed to create a business rule or something else?   Thank you.

Hi Everyone, In our system - Profit Center is in the Entity Dim and Cost Center is in UD1. Only specific Cost Center(s) are valid per profit center, and this mapping is stored in a SQL table in the system.   The need is to be able to enter data for 1 specific account, against all valid CC and PC combinations.  In Cube Views - if we have Entity.Base in rows, is it possible to get the valid UD1 in the row using the mapping table?

My client needs me to capture foreign characters apart from regular English as part of Account Metadata. Some of their ERP(Account/Entity) data is in chinese characters and the question was will this be brought in to onestream in their local language or do they first need to translate it to english?    

Hi, How to get 4 quarters data in one year like Q1+Q2+Q3+Q4= 2023?  what is the use of Scenario View-SV in View Dimension?   Can anyone help me with above questions?   Thanks in advance.

Hello, The customer reporting format includes data from both cubes that are currently set up in the application. How can I create a cube view that results from a combination of the two cubes? Thanks!

Hi, is there an ability to change the Classification field in the Cell Detail right click from a combo box to a freeform entry?

Hello All, I am trying to use the Global Time to pull reporting columns using the UD8 dimensionality but the values will not return.   Dim ScenarioMth As String = api.Pov.Scenario.NameDim gbTimeName As String = BRApi.Workflow.General.GetGlobalTime(si)Dim objTimeMemberSubComponents As TimeMemberSubComponents = BRApi.Finance.Time.GetSubComponentsFromName(si, gbTimeName)Dim gbMonth As String = objTimeMemberSubComponents.Month.ToString If gbMonth.Length < 2 ThengbMonth = "0" & gbMonthEnd If Select Case gbMonth Case 1If ScenarioMth = "FCST" ThenReturn api.Data.GetDataCell("U8#None")ElseReturn api.Data.GetDataCell("S#FCST12:U8#None")End If End Select

Hello,While trying to import data through a workflow from a *CSV file I am getting the error from below when performing the Load step of the workflow: These are the only details of the error, in the Task Activity there are no relevant details for this error.This seems to be a generic error. Could this be related to the workflow setup or is it something else?Thank you. 

Hi All!,  My team and I have placed a JE event handler with restrictions for preparer and approver (where preparer can't approve his/her own JEs - Approve/reject/post & Unpost) along with JE email notification.In this Scenario where a user has both Preparer and Approver access, submits JE through excel, his/her JE is getting directly approved without considering the restrictions we have placed in the JE event handler but when done manually it's working as expected. below is our BR. any help will be greatly appreciated.    Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As JournalsEventHandlerArgs) As Object Try Dim returnValue As Object = args.DefaultReturnValue args.UseReturnValueFromBusinessRule = False args.Cancel = False 'Evaluate the operation type in order to determine which subroutine to process Select Case args.OperationName 'SUBMITTED - Notifiy Approver Case Is = BREventOperationT

Hello, Is it possible to remove user defined dimension association from cube (Application>Cubes>Cube Dimensions)? We've an unused dimension initially created but now we'd like to remove it, as all data is loaded at None member. But when we try to change that UD7 dimension setting to default (RootUD7Dim), it throws below error: "Error updating cube. Unable to modify cube 'CUBENAMEXXXX' dimensions because the cube has data."   I know that error is because we've loaded data already but just wondering if there's a way to get rid of this dimension from cube.   Thanks, Gaurav  

Hi, I have a requirement to report on transaction currency. Is there a way for me not to use any UDs to hold the transaction currency? May be  using the alternate input currency in flow? Any suggestion is appreciated . Thanks

What alterantive solution you have build for Workforce Planning. I don't want to use People Planning Market place solution. 1) Run calculations inside the cube by storing all employee information. 2) Relational Table + Cube. Can you give me a top level design where i can start with ? Thanks!

Hi All! We had gotten an ad hoc request to give certain access and restrictions to Preparer Users and Approver Users. Where the Preparer can complete workflow and revert workflow and the Approver can only certify in the Workflow profile. We have been able to successfully achieve restriction on completing workflow for the Approver but not able to restrict them from stopping the Revert workflow. Even after placing conditions to stop the revert workflow the certify is also getting restricted for the approver.below is the code without any restrictions for Revert workflow for now.  if anyone has resolution for this it will be greatly appreciated.  

Originally posted by Jill Balke I am looking to do a conditional formatting that would return a result based on a cube view showing both a variance dollar amount of over $4m and over 5% which are in two different columns of my cube view, and I haven't been able to figure out how to look at data in more than one column for conditional formatting yet.  Would this be possible?

Hi All,In HFM we can extract data from one application/Instance and load it into another application using the data load option (.dat file). Do we have a similar feature where we can extract data from one OneStream application and load it into another application/Instance?Thanks,Anand Thota

Hello,I have a very peticular situation, where the parent workflow is validated and finalized, while the children are not !Now, I can't validate any children workflow, because the parent is already validated...Do you have anything that would help re-initialize the workflow, whitout having to remove all data ?Regards,

Hello, I have a calculated column in a cube view, using CVC referencing another column.    This works and is showing the number from the other column.    Rows are a dynamic member expansion. I would like for the calculated column to only show a value in rows that have a specific member name. So I'd like to add conditions to the CVC  Any ideas?