Announcement
ABC
Recent Activity
Navigation behavior
Hi everyone, I’ve developed a report using Cube Views and noticed the following behavior with keyboard navigation: The Tab key moves right and then wraps to the next row The Arrow keys move in their respective directions and wrap at the boundaries When navigation reaches the end of the report, it continues by jumping back to the beginning and starts again from the top. Is there a way to stop this wrap-around behavior at the report boundaries? Is there any property setting to control or disable this? Thanks in advance, Archana
How to round the result of a calculation?
Hi everyone, I would like to round the value for a calculation, I try wit this api.Data.Calculate("A#P_EBPPrct:O#Import:U1#D0000:U2#P0000:U3#CORP_ADJ:U4#PJ00000 = Round(Divide(A#433100, A#411000:E#" & strEntTx3 & ":C#Local:O#Top:U1#ALL_DEPARTMENTS:U2#PROMO:U3#CORP_RPT:U4#ALL_PROJECTS))") or this api.Data.Calculate("A#P_EBPPrct:O#Import:U1#D0000:U2#P0000:U3#CORP_ADJ:U4#PJ00000 = Divide(A#433100, A#411000:E#" & strEntTx3 & ":C#Local:O#Top:U1#ALL_DEPARTMENTS:U2#PROMO:U3#CORP_RPT:U4#ALL_PROJECTS)",AddressOf OnEvalDataBuffer) Private Sub OnEvalDataBuffer(ByVal api As FinanceRulesApi, ByVal evalName As String, ByVal eventArgs As EvalDataBufferEventArgs) Dim resultCells As New Dictionary(Of DataBufferCellPk, DataBufferCell) For Each sourceCell As DataBufferCell In eventArgs.DataBuffer1.DataBufferCells.Values sourceCell.CellAmount = math.round(sourceCell.CellAmount) Next eventArgs.DataBufferResult.DataBufferCells = eventArgs.DataBuffer1.DataBufferCells End Sub but didn't work, so, OS have a way to round values in a calculation?
Excel Spreadsheet Component Annoying Popup
Hi All, We are using a spreadsheet component on a dashboard to show a cubeview. When we enter text into an annotation field, it works fine and you just have to hit save afterwards for the data to be committed to the cell. However, if we want to attach a file to the cell, once we do that and click ok, we are prompted with a message box that says "Do you want to refresh OneStream data? All unsaved changes will be lost". Regardless, of whether we say yes or no, the file still gets attached. Is there anyway to disable this prompt as it really doesn't offer any value to us? Is this out-of-the-box functionality? Thx, MikeWorkforce Planning Express PV920-SV100 is Live on Solution Exchange!
1 MIN READ The Express Development team is excited to share that Workforce Planning Express (PV920-SV100) was released on March 17! What is Workforce Planning Express? It’s a packaged solution designed to help organizations plan and manage their workforce more easily. It includes leading-practice designs and ready-made configurations so teams can get started quickly. With this solution, you can: Plan position adjustments such as hiring, transfers, and terminations. Manage headcount across the organization. Monitor compensation, benefits, and other workforce-related costs over time. Want to learn more? Read: Review of the release notes and product documentation on the Solution Exchange. If you’re working with customers or prospects Here are a few ways you can guide them to get started: Access the Solution: Workforce Planning Express is available for download on the Solution Exchange. Training Opportunities: End-user training is now available in Navigator Have feedback? If you have feedback or receive it from customers or prospects, please share it with the team via this link so we can continue improving the solution.File Explorer Incoming workflow folders missing in copied applications
This post is to provide information about File Explorer Incoming workflow folders. Based on what we've seen in our environments, when an application is copied, the new application does not contain the folder structure located at: \File Share\Applications\<Application Name>\Incoming\<Cube Root Name>_Cube\<Workflow Base Input Name>\<Workflow Import Name> We noticed these folders were missing in our last application copy when we were trying to copy files through SIC and drop them into the workflow import folders since our requirement was to drop them there for users to manually import when they choose (instead of automatically loading the files through batch import from batch harvest). To fix this issue we exported the Workflows and re-imported them back into the copied application. This triggered OneStream to create the cube root folders and workflow folders for the workflows that were imported. Hope this helps someone else who might be running into the same issue.Unable to Post Journals to Locked Entity Despite Central Journal Input Step
Hello Everyone, I’m encountering an issue in OneStream when trying to post a journal via central workflow to an entity whose workflow is locked. Normally, central journal input steps are designed to allow journal postings even when the entity’s workflow is locked. In my case, I have configured a central journal input step within the workflow profile of the entity, so I would expect journal entries to still be accepted despite the lock. However, when attempting to post the journal, I receive an error indicating that the entity is locked. Has anyone experienced a similar issue where central journal input steps do not bypass the workflow lock as expected? Are there specific configuration points or workflow setup details that could explain this behavior?
Need to send data from OneStream to Snowflake using an existing SIC ODBC connection
Hello, What is the best way to send data from OneStream to Snowflake using an existing SIC ODBC connection? Currently I am using SIC ODBC connection to query data from Snowflake and now I would like to send data back to Snowflake.Dynamic Parameter on Bound List
Hi all, I'm trying to pass a Dynamic Parameter (from a repeater) to dynamically build the Bound List of a Combo. While (for example) ~!Text!~ and ~!Tooltip!~ params do correctly populate Text and Tooltip properties of a Combo, I'm not able to pass a Dynamic Parameter (eg: ~!DisplayMember!~ to the param (Bound List) beyond the Combo. It's not translated into its actual value. Since the repeater is Dynamic, and the number of repetitions is variable (unknown at design time), I'm wondering how would be possible to parametrize a single Bound List Parameter, without having to duplicate it 10 times (limiting de facto the power of dynamic components). TIA Regards FabioGPOV Action on OS 9.0
Hi all, I'm experiencing a strange issue on OneStream (rel 9.2.0.18004) that was working as expected under previous release (8.*) In a dashboard I have combos that let me select Scenario and Time, with a "POV Action" that set them back setting - respectively - WFScenario and WFTime parameters. Now, starting from the above mentioned release, whenever I change a combo, the focus moves from the dashboard, opening the selected Workflow. So, the User is experiencing something like: Launch the Dashboard Select Scenario System opens current WorkFlow Open back my dashboard Select Time System opens current Workflow Open back my dashboard Run the action In previous release, the POV Action didn't took the User away from the current dashboard. Have you experienced the same issue ? Is there a workaround to let the user stay in the dashboard ? Thanks in Advance FabioG
