Application Build

Is there a way to set the default application for all users? I would prefer it to always default to our Production application every time someone logs in.

Hi, Do we get to see the member updates made in Dimension Library in the Task Activity? I don't see a Task Type related to this in the Task Activity. It gets recorded when I use an XML file to update the dimensions, but not the manual changes made there. Is there any setting that needs to be made to get this information in Task Activity or should I be checking somewhere else? Please let me know. Thanks in advance, AK  

We set up OneStream approx. 3 years ago. Since then our user base has expanded a lot and we have facing issues in users accessing OneStream. Currently, in order to grant acess we have to add users who utilise different IT Networks as guests to our Azure AD. However, we have a number of smaller entities where we can't do this as they don't have a corporate IT network with an external facing IP we can whitelist. Has anyone come accross this issue and are there solutions we haven't thought of?

Hi all,  I am having trouble with a member formula that essentially subtracts interest expense from interest income: I'm sure I am missing additional dimensions/qualifiers in the member formula, but everything was the exact same except the account of course. Any direction would be greatly appreciated!

Is it possible to change these colors globally within an application?: 1. The application colors that are the Blue and light blue that we see at the top navigation and application header bars. 2. The highlight color that occurs when your cursor hovers and selects different cells such as within a grid view or a cube view.

Hi All, We are looking for a way to put a currency override on movement flow member (ex. dividends, redemptions, etc...). The current override logic which was provided was OneStream is leveraging the flow dimension to conduct the currency overrides so I am having trouble in determine the best way to work around this. If anyone has come across this before please let me know. I'm looking forward to hearing from you. Cheers!

Hello, Is there a way to export multiple pages of the drill down in a single csv?  It seems like each page of the drilldown must be exported separately, which is very time consuming.  Thanks!

Hello - Wondering if anyone has come up with a efficient way of providing visibility for end users into the calculation logic and/or equations that are being used by dimension members. For example: End user pulls up a Cube View The Cube View is a mix of base members, calculated members, and dynamic calc accounts How can they see the equations impacting the various members? I'm hoping there is a better way than manually documenting it during system set-up and updating with each change. Any input appreciated.   Thanks,Bil

Hello!  Looking for some feedback on how your company records and reports on both IFRS and GAAP standards. Do you use a UD as a sort of data type to record adjustments where they differ between IFRS and GAAP? Or do you use different accounts with an alternate hierarchy? Or something different?  Interesting in hearing from anyone with any suggestions - thanks!

Hi Team,   I'm wondering if there's a parameter that can be used in OS for a new line? I mean there's already a |SPACE|, which works perfectly, but I would need such parameter for new line (like \n in VB.NET), any ideas?   Thank you!

Hi all, In our OneStream environment, we have few hundred users and few thousand groups to which these users are assigned to for granular access. Want to check these with OneStream admin Gurus:1) Currently the semi-annual user re-certification exercise is done manually by extracting the OneStream user/group access reports and asking the approvers to re-certify. This is proving to be cumbersome exercise. How do you all do this in your environment?  Are there any best practices about this?2) Have you used or seen/heard about a third-party tool like SailPoint being used to manage OneStream user / group access and resulting re-certification activities? How difficult it was to build integration between a tool like SailPoint and OneStream?I would love to hear your experiences.Thanks in advance for any experience sharing.

Hello, I am looking to connect with folks who have implemented specialty cubes to manage data for sales, HR, Projects, Treasury, etc. We are exploring the capability of building a digital transformation roadmap using a cube approach, similar to how Essbase can be used. We are considering using the register to utilize larger data sets and other functionalities. Would love to hear your experiences. Thanks! Regards, Ronnie

Hi Everyone, I hope all are well.   I am trying to use the GetICMemberFilter function in a business rule but I don't know how to get the VarybyCubeTypeId.   Does anyone would know how to obtain the VarybyCubeTypeId using a XFBR?   Thank you for all the help.

Hi All, I am trying to find the best way to load my budget day. I currently have 22 departments, 207 accounts and 100 facilities that I need to load too. Do either of you have any suggestions on what's the most effective way to get my data loaded in OneStream that will take the least amount of time? I greatly appreciate your input.   

Hi,I wonder what's the difference between IsConsolidated member property and Aggregation Weight which is relationship property? When one's usually set IsConsolidated to False? I can imagine that it make sense for non-additive values (like KPI's), but I'd rather use for that Aggregation Weight, so not sure what for is that differentiation. Any tips, example use-cases?

Hi All, Is it possible to pass a member list, in my case flow members, as a list parameter in a cube view combo box? I know a delimited list would normally be used for this purpose however I need the list to be dynamic based on the dimension library and will be storing the selection to the Annotation view member. For context I am trying to allow the user to select a default mapping for an allocation rule which will require the user to select the lower-level default allocation member for a specific flow. Many thanks in advance. Nick

Hi All, We have a client who wants to exclude a subsidiary from their reporting rollup starting mid year in May 2022. Unfortunately the consolidation view is set to YTD so it appears that when we switch the consolidation percentage to zero then it reverses all of the YTD data for the whole year opposed to just excluding the data beginning in May.Is there a simple solution to resolve this? Or is a business rule required when divesting mid year? It seems like a requirement that should be pretty common and have a pretty straightforward solution like in Hyperion but we haven't had any luck so far.   Any thoughts or guidance is greatly appreciated.   Best, Joe  

This is probably quite a basic question. I have a vendor file with multiple currencies going to a single account. Can anyone advise the best way to do this as there is no option in the Data Source or Transformation rule to vary the currency. Do I use a separate member in the Flow dimension and set the "Flow Processing Type" to "Is Alternate Input Currency For All Accounts"? Appreciate the help - thanks

OSAdmin If we have multiple OneStream Environments, is there any Market Place solution or a way we can compare Security (Users/Groups) between environments and then Synch up only those changes that are required to be migrated. Note: - We are aware of .xml extract and load, but a utility to perform the same would help and avoid any error related to security

Hi I am looking for a way to restructure a part of our UD1 hierarchy but there over 1,600 lines to move so I don't really want to copy and move them individually to their new locations. Is there a way to upload the new structure and overwrite the old one, or a faster way of copy/move the base levels. Thanks Simon

We need to provide users the ability to review the error log within the system tab. I don't see anything in the Application>>Security Roles.  Can thjis be granted and how?

Hi  We are looking at inputting certain Balance sheet entries at Parent entities. Is there a way to get OneStream's intercompany matching tool to work Parent to parent (rather than either base to base or base to parent)  Ideally I don't want to substitute a 'proxy' base member when entering at the parent level  Thanks in advance 

TeamAm new to the Onestream. Can someone please guide me how to extract and load metadata in Onestream using flat files/Excel files.RegardsVarun

Hi    Is there a way to aplply user regional settings number format using Onestream client cube views, report... ? Or to apply the format user by user, or form by form? Thanks in adavnce for the help Marcello   ps I have noticed that the Excel addin shows the number with the specific user regional settings. So the question is related to the Onestream client only  

Hello  I made a mistake creating the  IC matching rules for several workflows related to the entities. Do you have any suggestion on how to bulk update the IC matching rules? Thanks in advance Marcello