Discuss the features and functionality of OneStream.
Recently active
Has anyone else run into the below issue related to Excel Freeze Panes and/or found a solution for it?Unlike exported cube views to Excel, OS does not automatically create frozen panes using Cube View Connections. We have determined that we can apply certain Excel formats over top of the Cube View connection. We did this with Freeze Panes setting at the corners of the first row and last column header. However, when we refresh these Excel template files a second time (i.e. after responding to parameters), the frozen panes seems to relocate up above the first header row. This happens even though the cube view connection itself does not change in terms of it's starting position.For example:Cube view connection is set to start at cell $A$4.Freeze panes setting is at $E$7Above is saved to the Excel template which is then uploaded to OS as part of a File component. File component is attached to a button on the dashboard that user selects to open the CV connection
Is there a way to have nested column headings centered and merged when exporting a cube view to excel? I have nested columns and want the top column header to be centered and merged over the bottom columns. It does this automatically for a pdf export but the excel export repeats the top header for each column.Excelvs. pdf
Is there a way, in a member formula or Finance BR, to write annotation data back to the database in bulk?In OneStream rule writing, it's best practice to limit the number of times you are writing data back to the database (ideally only one SetDataBuffer at the end of your code). However, it does not appear that you can include annotation information in the DataBufferCell objects that are used in a data buffer.Is there an alternate way to be able to set a large quantity of intersections at one time (like a SetDataBuffer), but for Annotation information instead of values?
I'm looking for a solution to create a parameter that would allow users to select from a drop-down list current and next period's scenario. I'm trying to avoid having users select the incorrect scenario for data submission via the excel add in.
It appears we can not use workflow event handler to automate an activity which has the same event operation type. Anyone has similar experience?We need to automatically unlock a workflow when a sibling workflow is been manually unlocked. We wrote the rule under the BREventOperationType.Workflow.WorkflowUnlock event. But the process always fail with the below error. The same code will work if we changed it to run from the BREventOperationType.Workflow.WorkflowLock event. It seems to me we can not trigger same type of events."The underlying connection was closed: An unexpected error occurred on a receive. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host (Socket Error Number 10054)"
Hello,The data I am loading have a lot of wrong account/IC combinations and my load fails because of those.I want to create an expression rule to say:if the 'Is IC Account' property for target account in OneStream is not set to True; then map to IC#NoneElseDo normal mappings.Any help appreciated
Getting below error in Data Explorer for Cube Views, can someone please help me to resolve the below error. User Interface Stack Trace: Server stack trace:at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)at System.ServiceModel.Channels.ServiceChannelProxy.InvokeEndService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]:at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)at OneStream.Client.SharedUI.DataExplorerServiceReference.DataExplorerService.EndGetDataCellsCompressed(IAsyncResult result)at OneStream.Client.SharedUI.DataExplorerServiceReference.DataExplorerService
Hi All, We have a cubeview that is taking much longer than we would expect. It can take up to 4 minutes to run or, in some cases, it keeps going forever and we have to logout and abort. The cubeview has time periods in the column (from a BRString) and Accounts and UD3's in the rows (also a BRString). Replacing the BRStrings with hardcoded values doesn't really improve the performance so I have removed BRStrings from consideration. We have also built a clean version of the cubeview to ensure there aren't old ghosts and hidden issues building this on the back of a previous cubeview used for a different purpose. This cubeview is as clean and lean as it gets and still slow. The part that really strikes me is that if I recreate the cubeview in a quickview in Excel, it takes just a few seconds. So a 4 minute cubeview can be a 10 second quickview. And looking at the report, 10 seconds feels right....4 minutes seems way too long for this repo
Hi,I have an import step in a workflow profile, using a connector data source.For the current Scenario/Year there is no data. This is causing an error when I run Load and Transform.I know I can manually set the step to "Completed" using the complete workflow button, but is there a way to set the import step so that the Load and Transform does no fail in the first place when there is no data?Thank you
Hi all,Referring to an old post: "Advanced" graphical content in dashboards.In a graph (created using the report component) I would like to add a trend line. Please see the picture below for clarification. This graph links to FX data (USD/EUR) retrieved in a cube view. Is there anyone that knows if there is any possibility to add a trend line in here? Maybe someone that has experience with trend lines? The things I thought of:- Adding a trend calculation in the cube view that will be added as a separate series in the chart. Problem: need to find calculation for trend lines which is very complex.- Data aggregation options in the chart component. (Under Series --> Properties --> View) Problem: this doesn't seem to do anything. Not sure how to work with the 'custom' setting. - Calculated field in the field list. Problem: I cannot seem to find the right function for the trend line (relates to problem 1).&nb
Hello,I am trying to find a way to have my variance % follow my dollar variance value. If a favorable variance, then the % variance should also be a positive percentage. In this example I'm looking at variance in an absorption account. Any thoughts on how this could be done?
Hello,We have a user who is experiencing intermittent instances. Her CubeView connections, via the excel add in, are displaying a #Logon instead of retaining the last value retrieved. See below.Her preference is set to "Invalidate old data when workbook is open = false". Is there another setting or preference that needs to be enabled to ensure the user sees the last value?Note: there are multiple cubeview connections in the same excel file.
When using the minimum range value in a waterfall chart, e.g. (10) that excludes all series values that are lower than 10. Is there a way to keep those values under (10) while using the minimum and max ranges to make the chart show the small value variations with a decent scale for the eye? thanks!
Hi everyone, Is there a way to use more than the 4 offered Row/Column Overrides? Here is my problem:For a customer I have to create a report, in which among other things the sales figures of different business units (UD1) are to be seen later on an Excel sheet. Since, as far as I know, it is not possible to loop on an Excel sheet in a report, I wanted to create a cube view and list the different UD1s under each other. However, a dynamic calculation with the following formula is included: GetDataCell(Divide(CVC(ColA, 1), CVRC(RowA0, 1, ColA, 1))):Name(%) The value A0 should then be changed to B0 for the next BU. However, since there are a total of 12 BUs and 12 columns for each month, the 4 overrides are not enough. Is there a way to increase them? Or another way to get the calculation right for all BUs?
We have a logic that makes a multiplication of Transfer for Tax by Grouping Regime by Tax Rate (38,007 *0,1). It works for all entities, except one (here it always show 0): Do you have any idea why?Thanks a lot!
You can use Excel Import Templates to load data into OneStream via a Workflow Question Credit: Parker Laabs Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Hi everybody,Below you can see a graph created for a client.A question coming from them is that they want to align the 0 points (highlighted) of both the primary (left) axis and the secondary (right) axis. I've tried (amongst others) to change the visual and whole range, scaling options but it doesn't seem to change anything. Does anybody know if it is possible to align the 0 points? Thanks!Floris
I am trying to see the last changes were made to an intersection. Currently I am using a UD8 to join a couple tables together and can see the last time a section was changed but my issue is run time. It will run in about 2 seconds for one account but times out if I try to run it on all accounts. It is being used in combination with an XFBR that pulls a rolling list to select days after a date is selected from a date selector. Is there an easier way to see if changes were made to a certain intersection that would run quicker?
Hello,Our Business Operations team provided us the plan in an offline copy of a cubeview in Excel.When the FP&A user opens the offline copy it shows #LOGON instead of the numbers.How can the FP&A user see the actual values instead of #LOGON?is there any setting that will need to be set to view the values before submitting into the application?Thanks
Has anyone ever seen odd results from a user canceling a Forced consolidation, and subsequently running a normal consolidation? A later Forced consolidation seemed to have cleared up the issue. I maybe on a wrong path to what happened, but that's the best I can figure that happened.
Hi, I have an Advanced Chart where I am displaying dates. The values, however, are stored as ticks(Long). This is great for the bars and points, however, I need the Axis labels to be displayed as date (not Long see below). I've tried a few versions of {V:MMM-yyyy} however, that doesn't seem to work. I do have a business rule to work with as I'm using a secondary axis, but not sure how to target the data labels in the rule. Any suggestions? thanks,Greg
Is it possible to test if a consolidation or a data management job is already running before running it again ? Ex: I run a consolidation (about 10min) but another people run the same consolidation the same time Thank you for your help
Hello - I am working on a cube view where I would want the resulting values (variance amount) to sort with the highest value first. The complication is, my users are used to reports from Hyperion that enabled expansion drilldowns on these members. The Hyperion reports retained the sorting even when using expansion. I can't seem to figure out how to do this in OS - or if it is even possible - when selecting a member expansion (.Tree or .Base). Wondering if anyone else has attempted this. Thanks,Cody
Hello,I have InUse for default time and scenario = TrueI also have InUse for default time and scenario for 2023M5 = False.Note that the period could also be different.Now, how could I reset the InUse settings to disable the False or True on ALL time for default Scenario?In my example above, I am expecting the property for 2023M5 to be deleted. What brapi would you use? can you show me an example?Thanks
Hi experts, I have a group of GL accounts that I need to map to either an expense / revenue based on the sum of the balances.I thought this would be easy enough with a derivative rule; first create an interim rule to aggregate the accounts and then create a final rule to check if the balance is greater / less than 0.Finally, I have used the final derivative rule in my target account mapping.But, this is not quite working as expected.It seems to just add the negative balances of the individual GL accounts under the "_N" rule and the positive balances under "_P" rule, therefore both my expense and revenue account in OS ends with a balance.Could you please suggest what I am doing wrong?Regards,S
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.