OneStream Platform Forums

Hi everyone, I was trying to add drill down capabilities to a calculated flow dimension member but was having issues with the drill down formula. I entered the formula below but still wasn't able to drill down into the flow member at all. Does anyone have any ideas on why it's not working?   Formula:   Formula for Calculation Drill Down:  

Hello,Can someone please guide me to any useful document or link on Smart Integration Connector ? BR,Avijit

Hello all,I am building a planning application on which the end users interact via drop-downs for Entity and UD1 members, and click a "Save Inputs" button that saves input data and runs a custom calculation on the selected entity and UD1.This is done through a data management step that runs a business rule, and on which the selection of the UD1 and Entity impact the business rule to avoid recalculating all the application each time. There are 6 business rules, that respond to different functional models, activated by different "Save" buttons across the application.I want to create a button or data management sequence that will run all the business rules (the 6 models) for all UD1 members of the 4 entities, as an admin task. I have created a Data Management sequence that runs the 6 steps consecutively, with its corresponding button, but have not been successful to modify the arguments or the Data Management parameters to perform the calculation for all members, as I cannot input "E#All"

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. 

I have UD8 DynamicCalc members that calculate various Growth %s.  These work as expected when the Account dimension member referenced in the formula has a normal Account Type (e.g., Revenue or Expense).  It doesn't work when the Account Dimension member's Account Type is a DynamicCalc.Any tips on how to solve for this?  We can workaround this with some math in Cube Views, but would love to have a workaround for XFGetCell and Quick Views.

We have made the latest upgrade to 7.2.1. When I use the Excel Add and use the keep and delete buttons it suppresses all data in that field opposed to only keeping or removing the items that I selected. Anyone else have this issue. The other members of the team don't have this issue and we have the same settings in place.

Hello, I've deleted several on prem databases from both SSMS and the Database Configuration Utility, however, when I access System > Tools > Environment the deleted databases are still listed under OneStream Database Server with a message "((Database Not Found #))".  There doesn't appear to be a way to remove these via the front end. Is there any other way to remove these?

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, I am currently working on creating a ParamHelper business rule to be used in a CubeView. The goal is to have the S#scenario driven by the time dimension parameter selected by the user, rather than by the workflow time. For example, if T# contains M1, the scenario that should be returned is S#Projection. I would appreciate any pointers or guidance. Thanks in advance for your help!

All Scenarios belonging to the same Scenario Type must have the same Formula assigned Question Credit: Janice Kirkbride 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 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.