Recent Discussions
SIC w/ v9
Does anyone know if the Smart Integration Connector is FedRamp complaint with OneStream v9? Thanks.Dwight3 days agoNew Contributor5Views0likes0CommentsHow to reopen a closed workflow in v8.4.1?
I am the admin for the application. I dont find any button to closed/reopen workflow at v 8.4.1. BUT we do have a workflow closed without any reasons and I cannot reopen it. Anyone have any ideas on this? Thank you.michaelkeung4 days agoNew Contributor III17Views0likes1CommentEntity Dimension Maintenance via Workday Integration
Hi all! We're looking at creating an integration from Workday for automatic maintenance of our Entity dimension - including new member creation, hierarchy creation and movements, and text fields updates. Wondered if anyone else is doing something similar? Is it a complex integration, does it seem to work relatively seamlessly? Any best practices to share? Thanks in advance!BWHITAKER4 days agoNew Contributor III23Views0likes3CommentsWorkflow Lock / Unlock Dashboard
Was asked to create a dashboard that gives the HQ admin the ability to lock and unlock Workflow profiles. Found bits and parts to use the user POV and descendants. Unlock descendants isn't working but.. Was looking at member tree and some of the other tree functionality, but couldn't get it to work for profiles. My thought is the profile hierarchy then they would select what to lock or unlock. Was curious if anyone had any recommendations or solutions they could share? Appreciate it in advance!Solvedjayaleck4 days agoNew Contributor II54Views0likes5CommentsExcel Data Incorrectly Suppressing
I am trying to load stage data via Excel and having an issue I am not sure how to fix. I am loading data, including for attribute values 1 and 2 (AV1# and AV2#). However, if there is a zero in either AV1 or AV2 the row is suppressed, even if there is a non-zero value in the other attribute dimension. Is there a way around this behavior with a special token I can add or some other change?Sweez5 days agoContributor13Views0likes2CommentsAnyone doing planning at a proxy member?
Hi all, I'm just trying to get a feel for how common this use of proxy members is these days. I've worked for multiple organizations and typically, if we were planning at any level higher than the most granular level of data, we would plan a number representing a group of members, at some 'proxy' member created specifically for planning purposes. That is, we would not use some random existing base member that held actuals. For example: If our dimension hierarchy looks like the one below and we were planning at the Region Level: I would not plan for the entire RegionA by loading my planning data to "South3". Instead, I would create a unique member (say, "RegionA_Plan") and load my data there. Wondering how many companies out there would use the first method rather than the second method and what advantage there would be to this? Thanks in advance for your thoughts on this. RegionA North North1 North2 North3 South South1 South2 South3 East East1 East2 East3 WestSolved28Views0likes4CommentsIs there a way for a general user to view the time stamp of last GL load/import that is user friendly and is it possible to see that information in a cube view or dashboard?
Originally posted by Nick Tracy is there a way that a users can see when the last load for an entity is? Is it possible to present that in a dashboard or a cube view (cubeview would be embedded in our various internal worksheets). This is just so during our close process someone can know look at OneStream and know if they are using the most recent data. Sometimes management updates the GL fast and furiously during the close and OneStream may not always reflect the GL. I would like an easy way for a User to be able to easily view when the last load was. An example was a User knows the GL had updates at 9:30 am, requests the system to be updated, at 10:00 they "think" it is and use old data while the Admin updates OneStream at 10:07 or something (some people are impatient). I would like them to be able to see there hasn't been any new loads since their request and so they know they aren't using updated data.OSAdmin9 days agoValued Contributor II1.6KViews0likes3CommentsDerivative rule based on time
Hello all, I am looking to spread budget data across 12 months evenly, however my source is only designated one time. I am looking to split time into all twelve months of the year and divide the amounts accordingly. Is this possible?Jacob11 days agoNew Contributor1.1KViews0likes2CommentsSmart Integration Connector remote query failed.
I am trying to query the data from the client source database through a Data Adapter, but it is returning this error: Is this an issue with our setup on the OneStream end or something with the database configuration on the client side?danszczepanski11 days agoNew Contributor III25Views0likes1CommentAccount Reconciliation Status Codes
I am trying to write some custom reports off of the RCM tables. Does anyone know the translation of the number in the status column from the table to the name that shows in the UI? Or does someone have a nifty way to retrieve that from the code? Thanks, ScottSolvedssmith-nova19 days agoNew Contributor III26Views0likes2Comments