The OneStream Community is currently experiencing issues with the IdeaStream and User Groups. Learn more.
Announcement
ABCFeatured Content
Recent Activity
POV 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
ONC - IntercompanyDetailAllPlugaccounts - Suppress matches
Hi, We have moved to v9, and the previously used IC matching methods are giving us issues. For this we have a ticket open with support, and they have pointed us towards ONC. We use something very similar to the intercompany all plugs, but then supressing any combinations that are matching. Is there a way to filter the IntercompanyDetailAllPlugAccountsGridView_ONC to suppress the matches? It seems to be working in our development environment, but would be great if we can supress the matches as this is something that will be required. We have tried this: {WS}{GetIntercompanyDetailAllPlugAccountsGridView}{View = |!Members_View_Numeric_ONC!|, SuppressMatches=True} But that does not seem to work. With kind regards, Tim
Text Box Component - Input Mask
Does anyone know if we can assign an Input Mask to Text Box components? Using version 8.5.4, I have a few dashboards that make use of Text boxes for data collection and I don't see a way to assign an input mask to the text box. An input mask is a string expression that constrains input to support valid input values. If the text box is expecting a dollar amount, the input mask would format the entry as number format #,###.00. For capturing a telephone number (North America format), the mask would be (000)000-0000. If this doesn't exist, can the dev team add this to future releases? Thanks, CosimoUpgrade from 9.1 to 9.2
Hi, I would like to know if any major changes need to be carried over from 9.1 to 9.2 version upgrade. As we had some changes performed when we moved from 8.5.1 version to 9.1.0: Winscp to SSH.net Marketplace solutions to be upgraded to latest versions also Navigation center replaced applications reports, security audit reports. so, we had to remove the existing AR, SAR solutions. We had .vb in the extension wherever the xfbr has been referenced that extensions were no longer supported in 9 version. Thanks in Advance!
Delimited file Import and normalization
Hi everyone, I need to set up a few transformations to normalize a delimited file that will be uploaded by the users, before feeding it to the datasource. I previously worked with FTP folders, and used a Connector BR to retrieve data and normalize it before the datasource step. I have never worked with delimited files loaded directly by clicking Import. It's not clear to me if I can still use a connector BR or if I need to use something else (a Parser BR?). Can anyone help me understand what is the best practice in this case? Thank you for the support!
How can I retrieve the name of the form template using a finance business rule?
Hello everyone, Thanks to this discussion: https://community.onestreamsoftware.com/discussions/WorkflowDI/forms-by-entity/13417 I can now show or hide the input cube views based on whether or not the group entity has been released, as stored in Entity Text6. However, by doing this, I lose the ability to display cube views only for the quarter, half-year or full year. Currently, I display the cube views every month if the entity is present in the group, so this does not apply to cube views that should be displayed quarterly. I would therefore like to retrieve the name of the form displaying each data entry cube view, so that I can define in the Business Rules whether each form should be displayed monthly, quarterly, half-yearly or only in December. This would allow me to use the settings provided natively by OneStream, which I have previously bypassed. But I am unable to do so. Is this feasible? The ultimate aim is to prevent accidental data entry into workflows that should no longer be populated. I have already removed accountants’ access to the workflow for entities that have left the group, but the central team still has access, and I would like to prevent them from accidentally entering data for periods when the entity has left the group. Thank you for your help
OS Genesis CubeViewTreeView
Hi All, When opening a cube view via OS Genesis cube view tree view, the content block can take a while to open. Even though there is no data, it is a simple cube view PnL. Opening it via cube view or dashboard takes only 2 seconds with data. Is there a way to improve the performance of the cube view tree view content? Appreciate your help on this.
Updating Time Zone from UTC in Dashboards
Does anyone know how to change the time zone used in OneStream Dashboards from UTC to a different time zone (e.g., Eastern Time)? We’re implementing for a client based in Eastern Time, and we’d like dashboard times to reflect that for end users. Any guidance or recommended approaches would be appreciated. Thanks!
loading from ERP
Hi Community :) We are currently in development with regard to loading sub-ledger data into OneStream, but the balance specifications are so granular that we currently have them split into about 10 distinct loads. Because of this setup, our end users are being forced to manually click "Load and Transform" 10+ times to get a complete sub-ledger balance loaded for the period. Obviously, this is tedious, creates a poor user experience, and introduces a lot of room for human error. We want to streamline this. What is best practice to do this?Debugging OneStream : Quelles sont vos alternatives au api.Console ?
Bonjour à tous, Tout nouveau sur OneStream, je commence à plonger sérieusement dans le paramétrage et la rédaction de Business Rules. J'avoue que je trouve la méthode consistant à passer par l'api.Console (ou api.LogMessage) particulièrement chronophage pour débugger mon code. J'ai l'impression de perdre un temps fou à multiplier les logs pour suivre l'exécution. Je souhaitais avoir vos retours d'expérience et vos "tips" d'utilisateurs chevronnés : Existe-t-il un moyen (via un outil tiers ou une config spécifique) de poser de vrais points d'arrêt (breakpoints) pour stopper l'exécution ? Comment faites-vous pour analyser le contenu de vos variables de manière plus dynamique et fluide ? Je suis preneur de tout feedback pour améliorer mon workflow de développement ! Merci d'avance pour votre aide,
