OneStream Platform Forums

Is it possible to use the linked navigation to pull a dashboard based on a scenario? I have 2 separate dashboards that are pulling 2 separate BI Viewers for 2 separate Data adapters. One pulls data from a relational table based on actual data and the other pulls timestamp information based. What I want to be able to do is if the column is actual then pull the dashboard that has the Bi Viewer with the actual detail. If the scenario on the column is Working, then pull the dashboard that shows the timestamp info. The scenarios on the dashboard changed based on the date selected using a date selector. Currently I have both dashboards linked to each column and when you right click you have the ability to select either dashboard but I only want the user to have the ability to have one predetermined selection based off the scenario.

All - The below extender rule will be able to delete multiple member from Parent Hierarchy.  1. Provide the Dimension Name & Top Parent Name in the Hierarchy - See highlighted in Red. 2. I want to make a point here the While Count > 3 because the it takes the current parent and other member ENtityDefault1 & None. Since we will not be able to delete it so it should be 3 or loop will be infinite.  3. You can use as an input Variable for Dimension and Top Parent and attach to the dashboard but this is a good starting point.   Dim dimensionPK As DimPk = BRApi.Finance.Dim.GetDimPk(si,"Dimension")Dim nValue As Integer = BRApi.Finance.Members.GetMemberId(si, dimensionPK.DimTypeId,"TopParentName")Dim objList1 As List(Of Member) = BRApi.Finance.Members.GetAllMembers(si,dimensionPK,nValue)Dim objList2 As List(Of Member) = BRApi.Finance.Members.GetBaseMembers(si,dimensionPK,nValue)Dim mbrct As Integer = objList1.CountWhile mbrct > 3For Each mbrbe As Member In obj

Hello,Is it possible to refresh XFGETCELL (excel report) automatically through OneStream and save report as offline? i was trying to achieve this by uploading excel report as .xfdoc.xlsx but i want the output as paste special values. thank you 

HiDoes anyone know if it is possible to create a 'Read only' column in a SQL table editor?I have set the column format 'AllowUpdates = False' which almost gives the correct functionality. However, the field is still editable when you insert a new row.I currently get around this by completely ignoring the value in the field during the SQL Table Editor Save Data Event, but I wondered if it is was possible to ensure that it never appear editable to the user?Regards,Mark

Originally posted by Matt Grundey 11/6/2017 Hi, has anyone any examples of using Cubeview extender rules to change the logo displayed in a report based on the entity selected. I'm aware that this wouldn't work where entities are shown in rows or columns. I can't see any examples of passing in parameters into these rules that could identify the entity, nor can I see from the reference doc how I can get the entity that the report is using. 

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.