Discuss the features and functionality of OneStream.
Recently active
Hi Team, The user unable to login into OneStream application. We have verified that all access has been setup. But, after clicking of "External Provider sign in " we are facing the below "500 internal server error" Thank you Regards, Praveen
Hello, If I wanted to build out a driver based forecast in OneStream, are their any trainings or webinars that can explain that process?
Looking for some guidance with using the attribute field. I think I found a limitation with using it, but I am hoping it’s a simple fix and not a legitamate limiation. Scenario: creating a cube view where the first few rows are drive by account, the next several lines are driven by UD4 and Account. UD1 (departments) are driving the columns, except for when it comes to the rows that are driven by the UD4. At this point we need to use the UD4, Text 5. To do this, we created UD8 members that pull in attributes based on the UD4, text 5. The cube view: Rows are the UD4 and accounts. The columns are UD1 but we have row overrides for the rows that need to be driven by the UD4 text field. The row override pulls in the UD8. This works for the first few UD4 attributes being pulled. Then it just stops after roughly the 4th parent member under UD4. I can force it to work but adding in a column override (I don’t know why this wo
1. I am trying to export as trx for the derivative rule with a business rule in it. 1a. Once it exports, the exported file doesnt have the business rule name in it. (OR)2. Exported the rule as xml via application export and then opened it in the excel file as XM table. However, once i add rows below it and then try to export the file -> It says cannot export. How to insert multiple lines in the excel and get tehm exported as xml for onestream input ?
Hi All, I am getting this error "The SMTP server requires a secure connection or the client was not authenticated. The server response was: Authentication required" while trying to Use BRApi.Utilities.SendMail using the ConnectionName as "OneStreamEmail" Thanks
Is there any way to create a Cube View or Dashboard which has the ability to drill through without logging into the Application? The non authenticated users should be able to access the artifact and view the data. Any help would be appreciated. Thanks
I am trying to get the description for prior year in my Excel header for cube views. There is a substitution variable for current year but nothing for prior year. Anyone have any suggestions? Instead of the format 2023M3, I want the header to bring in the description that says March 2023. Below is my current year variable.
Hi All,We're running into a few problems with an existing BR that is used to change the state of the current workflow. The current BR is used in the admin workflow & we haven't encountered any problems, however when end users attempt to run this rule on a child workflow, they receive the error message below.Business RuleIf args.FunctionName.XFEqualsIgnoreCase("WorkflowStatusUpdate") ThenDim strChangeType As String = args.NameValuePairs.XFGetValue("ChangeType")Dim selectionChangedTaskResult As XFSelectionChangedTaskResult = Me.WorkflowStatusUpdate(si, strChangeType)Return selectionChangedTaskResultEnd IfWhen an admin progresses the workflow the end users are able to execute the subsequent steps to complete their workflow. Is there something I'm missing in the current rule that needs to be changed or is this an issue with our security setup?Thanks,
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.
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.