Application Build

Can somedody help me on how to connect the golf database to OneStream 

Hi All, Does anyone have any good advice on what Workspaces should be created in the application dashboards screen beyond Default?  In reading the guide, workspaces seem to have a lot of focus on separating development activities or perhaps for partner place solutions(?).  I am struggling a bit to understand at what level to offer a different workspace.  We have been toying with the idea of having a separate workspace for Actuals and Planning but as 90% of our dashboards live in Planning, not 100% sure this is the best use of this split. Any practical advice on the kind of workspaces that people are setting up that adds value?  I want to make sure we are using them in their best manner. Thx, Mike

Is there a report or dashboard that will flag violations of Extensibility rules in dimensions?

Is there a way to report on translation status like the way we have it for consolidation status- calcstatus? what would be the pov in this case?

When an app is copied to a different environment, first we extracted & loaded the security XML (users & groups). Then the app copy was made to this new environment using Cloud Admin tool. Even after this the artifact level security on the metadata, workflows, cube views etc. did not move. All the security groups in the artifacts showed "Not Found". What did we miss? Appreciate your response.

Hi All, how to copy application in OneStream from front end as well as from DB side if any have performed these tasks kindly navigate the steps please.

Hi there, From other security related questions posted in the community, I understand there are templates for creating user and user groups in OneStream. I would like to know is there a similar template to assign user into their relevant user groups as well? Any suggestions would be helpful. Thank you. JC

Hi,  Could someone enlighten me on what happens if no currency is set for entities?

Cash Planning rolling forward, Capex tracking in OS: Anybody experience to share in this context?

I am trying to update a slice security line using sql. I have been able to update the table on the backend but when I go into OneStream Cube -  Data Access - Data Cell Access Security, it does not show what the table was just updated to. It seems to want an ISS Restart in order for it to update in the Cube Data Access Section. I have also tried using a literal parameter on the member filters and an XFBR to make the changes I want after a button is pressed. Is there a way to update the Slice security without having to restart OneStream besides manually updating it every time?

How do I see if my OneStream application has Drivers based forecasting? Is it a separate module or workflow profile?

Hello, We're building our Planning module and was wondering we have management fees that we get from our corporate office. They come in as USD. Is there a way that we can load in USD and translate them back in to Local Currency for the entities? This is a one time yearly load and didn't know if it was possible or if we have to calculate it to local currency and then load it? Thanks, Will

Hello everyone, We have a client that uses 13 period time dimension in their current system that we are moving to onestream at the moment. They use period 13 to load TB' post adjustments even input disclosures  currently.We first wanted to use a UD dimension to capture it but I'm more and more leaning towards having custom 13 period time dimension to cater that. I know that is something that needs to be set up during application creation so I'm guessing we need a new application. Is that something to be requested from OneStream to set up?I also would love to hear if any of you had a similar case and how you handled it. 

I have a question with the documents web.config how does that document needs to be configurated? So I can access onestream demo    

Looking for help to display Text data in a cube view.  I'm using the member filter below which works for every account type EXCEPT  DynamicCalc.   Account Type set under Settings in the Member Properties (see below).  U8#Acct_Text3:V#Annotation    

We are moving an entity to another parent.  Prior periods have been locked.  Will this cause an issue with reporting as the entity will roll up under a different segment.  Trying to determine if we need to create another entity for reporting purposes.

Thought this was cool and wanted to share so others have the recipe.  If you build a default landing Home Page for users upon login, this is where the XML sits for that Dashboard.   Then, (I was thrilled) to discover this) once you have a default Dashboard set for users, the OneStream logo is now a clickable button!  It returns you to your Home Page Dashboard.    

Originally posted by Sam Richards 6/27/2019 Slice Security Question: I have a cube setup with restricting all access from all of my UD1 members. For some reason when I pull a UD1 in spreadsheet I can still see the data. It is probably something small I am missing but here are my setups. The bottom picture is the quick view I am using to test

Hi, I didn't see anything in the Install/Config guide or in the Onestream Community search, so I figured I'd just ask.Is there documentation regarding installing a self-hosted OneStream setup into a cloud environment?Particularly regarding the registration/addition of new server instances (consolidation,staging, web, etc) into the config files:-- Web Server Configuration file\Application Servers-- Application Server Configuration file\Server Sets Between server lifecycle events and lambdas calls, I'm sure something can be hacked together, but just thought I'd confirm what is/isn't available. Thanks!

Hi,  Anyone has any idea how I can setup security to limit the users from seeing other entities but at the same time not impacting IC partner for IC Matching Report? The cube views are setup for all entities. When doing it via entity dimension - setting read access and read and write access, IC Matching report is affected as when performing intercompany, the user can't see their IC partner.

For example,  when a user creates a journal and wants to attach some evidence.  Is it possible to stop them from uploading a 40 gb video file or something equally silly?  

When loading a YTD feed for an entity, if that entity is terminated mid-year (possibly moved to a new entity due entity structure changes) the imputed periodic value translates at the current period FX rate causing there to be a residual USD value remaining in the first period where no balances exist.  This issue is discussed on page 77 of the Foundations book, however the explanation on that page seems to indicate that this is mathematically correct, and therefore seems to infer that it is therefore a correct accounting presentation.Has anyone found any combination of scenario, workflow, or cube settings that has prevented this from happening, or have you used a business rule or some other process to remove these values from periods where no activity or balances should appear?

Was making a application copy of which we do all the time. I have one environment. OS told us to download the new version of application copy and we did. Ran fine last week now we are receiving a failed error. I noticed that the iis reset is now not in the script.  This is my selection  

Dear all, I'd like to know how do you define a particular text for an IC member. I thought that once you define a text for an entity having a IsIC = True will transfer that information automatically to the same member in the IC dimension but it seems that it doesn't work that way. Given this, how would you set up the text for IC members? Thank you. Best regards, Carlos