Application Build

I have extracted the security roles and users from prod environment to dev environment. i am changing the security role in dev environment. I have deleted all the assigned roles except open application role but still user have all the access as in Prod environment.  can some help to fix this issue?  

The SQLTableEditor in question is used for user interactive CRUD pertaining to Rates used in a calculation.Use Case:I have a SQLTableEditor that holds rates.  When the table Save button is clicked, A BR saves the rates and runs a calculation.  The results of the calculation are displayed in an adjacent dashboard containing a DataGrid.  The DataGrid needs to be refreshed after the Save button is clicked.Question:How do I configure the SQLTableEditor to refresh the adjacent dashboard on clicking the Save Button, in a way similar to configuring the "Save Action" of other components?  

Would a P&L account that had a balance in Period1 but was uploaded with a $0 balance in Period2 show as a $0 account in Period2 or the difference between P1 and P2 (a negative value)?

I would like additional information on the setting in Hybrid scenario for Use Input View for Adj in Calculations. This setting is currently set to True but some of adjustments booked in actuals are not flowing to the Hybrid scenario. However if this is set to False, the adjustments are reflected in Hybrid scenario.  

When i go to create time profile, i can see Months and weeks. Is there any documentation available how to create days?

Hi all, Does anyone know what's the command line to delete a security group using an XML file? equivalent to the action="delete" for metadata for instance. Thank you Regards p.s.: there's this way using an extender rule: Bulk delete security group 

Hello all, I'm repeatedly seeing a warning about "A virtual machine in your environment has maintained allocated memory over 85 percent full for the last 12 hours".  In your experience, what's the best way to chase down the root cause or contributing factors to alleviate this?

Hi,  Is there anyone who succeded copying attachment files one period to another period ? There is a getdataattachment function, however I don´t see setdataattachment.  Thanks in advance  Buket

Hello, I am working on a client that already had OneStream implemented.  I am now tasked with introducing additional functionality.  I am experiencing an issue I have not seen before.  When I am in the dimensions page, searching a dimension using the binocular function.  I can search the name and see all of the names pop up in a window.  I then am able to select one and when I click View in Hierarchy the wheel spins and spins, never taking me to the location of that member.  I did notice if I do those steps and the wheel starts spinning and I immediately close OneStream down and go back into the dimensions it opens up with that member I was searching showing on the screen.  So in this case it is faster for me to perform the search, exit, log back in and see the result.  Has anyone else experienced this?  And I have worked with clients that have much larger dimensions than the one I am searching on and have not experienced this. Thanks in adv

Is there any documentation available on standalone cube vs extensible cube? it can be pros/cons or functionality differences like data transfers

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?

Is there any known way to prevent a user from utilizing XFSet in Excel?

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.