Recent Discussions
Questionnaire Scroll Bar
The Question Text Column scroll bar in my Certification Questionnaire is not working. I have a long question text which does not fit the default cell size. The scroll bar is not clickable/draggable, so my reviewers aren't able to view the entire question during certification. The workaround I have is just to expand the column size so that the text fits into the cell. I am wondering if anyone has the same user experience or has a solution to get it to work? My current software version is 7.1.3.bjornliow23 minutes agoNew Contributor III30Views3likes1CommentBest practices for handling overlays with varying dimensionality in OneStream
We are designing a planning solution where overlays will be used across accounts with very different levels of dimensionality. For example: Some accounts have minimal dimensionality (straightforward base members for input). Others require navigating through multiple UDs before reaching the base intersection. Ideally, I’d like users to be able to choose their drill-down path until they reach the correct base intersection for data entry. Has anyone implemented a design pattern or approach that balances these differences effectively?6Views0likes0CommentsMeta Data UD2 DIM
We have some group of base customers under different parents with text property, and we are planning to block input to those customers in all the input forms if we use dimension property Allow input 'false' then it will block input but after that update during close FPA team should do adjustments for those Customers. Can we do it with irrespective of that dimension property false update. Is there any option that without updating input forms (CUBE VIEWS) with customer (UD2) parameter or with the help of business rule can we override that dimension property Allow input 'True' by running DM Step for certain customers when we give them in DM JOB and revert again to false after inputs through DM step. Please suggest your solutions.Guru_Prasad2 days agoNew Contributor11Views0likes1CommentSupplied Parameters and Embedded Dashboards/Dialogs
If I have a dashboard made up of several Embedded dashboards, all of which need to have access to a Supplied Parameter, do I need to include it as a component of the top dashboard only OR, do I have to include it for all embedded dashboards (that require the related parameter) also? SteveSolvedSteveK3 days agoNew Contributor III22Views0likes2CommentsBI Viewer / Calculated Fields
Hi all, is there some documentation about BIViever's Calculated Fields ? I cannot find info/examples about: aggr filter joinRule I need to compare values against the value of a specific row, but I'm not able to find a solution. Do someone faced the same challenge ? Do someone have more info about the above mentioned functions ? TIA regards FabioGFabioG3 days agoContributor26Views0likes1CommentCombo box cell type not working in Excel
I am working on in OneStream V9. I have a workspace cube view with a combo-box cell type. The cube view works fine in the application, but when I open the same cube view using the Excel add-in the combo-box drop down is not active. Any ideas on what I should check? Thanks.RandyThompson3 days agoNew Contributor III44Views0likes2CommentsData Management Step Service documentation missing ?
Hello, It looks like the data management step service in assemblies is currently not documented in the online Help. Does anyone have experience, snippets to share in order to leverage this service? How is it triggered? What can we do with it ? Regards,SolvedSergey8 days agoOneStream Employee72Views0likes6CommentsXF Dimensions Template - Update properties by scenario type
In the metadata XML file, if there are multiple values by scenario type, it splits into two rows and there is no easy way to generate two rows from the XF Dimension template. Is there any way to update member properties varying by scenario type via the upload template? I have to manually update, copy, and paste hundreds of times in order to have that property updated for the accounts. Using the standard metadata builder template, the other properties are getting overridden.jaideepk8 days agoNew Contributor II15Views0likes0CommentsWhere are journal attachments stored in OneStream?
Hi all, Does anyone know the physical storage location for journal attachments in OneStream? I found a table (table name: Attachements) with file names and related text but couldn’t locate the actual folder or path where I can extract it using a BR. Thanks in advance!SolvedAnusha_MP9 days agoNew Contributor II24Views0likes1CommentHow to get two decimal places in Member formula
Hi Everyone, I'm trying to write member formula (not dynamic calc), below is the syntax Dim Var1 as Decimal = Math.Round(api.Data.GetDataCell("A#630000").CellAmount, 2) api.Data.Calculate("A#520000 = A#430000 "*" & Var1 & "). after that getting error "Double is not valid, input string was incorrect format".uvrao3310 days agoNew Contributor II59Views0likes7Comments