Application Build

Hello! I need to use the same entity hierarchy in my second cube.  In my second cube "marketing" I need to use the same entity hierarchy that I'm using on the first cube "Business".  I need it because both cubes will be load entity information for the same company (same code) ,in additional the "Corpo" cube, If I want to have the total "spain" using this configuration I do not have it. Let me show an example:   Thanks!!

Hi, I have an Extensibiity rule which uses the "Imports WinSCP" command as is used to connect to an SFTP server. The rule works fine.   I have just made a copy of the rule within the same application because I wanted to try and make some changes, with the only difference between the two being the name of the rule, but it seems the "Imports WinSCP" command is not recognized in the new extensibility rule, despite being recognized in the old one.   Any idea of what I could might be doing wrong?   Thank you  

Generic Error Connecting after Upgrade from 711 to 722. Followed same process used to Upgrade from 681 to 711. Had no issues during Upgrade to 711. Server 1: Web & App Server 2: App Server 3: SQL DB Backed everything up. Stopped AppPools. Uninstalled OneStream 711 from Web & App. Installed OneStream 722 on Web & App. Upgraded backend Framework & App DB. Updated ASP.NET Config File. Updated Web & App Config Files. Updated IIS. Restarted. Everything starts up. Can browse to the Web & App Server resource folders in IIS Manager. Had to enable 'Directory Browsing" for each first of course. Had to "Allow unlisted file name extensions" for 'Request Filtering' for Web. Onscreen error: Unable to connect to server using address 'http://web-server:50001/OneStreamWeb'. Event Viewer Error: Inner Exceptions:Unable to access application server using address 'http://Web-Server:50002/OneStreamApp'.The content type text/html; charset=utf-8 of the response message does not m

Hi All, Hope you are having a great time with OneStream! I am trying to provide only View Access to some users but it looks like I can't.  I have set for a specific user the User Type as View and assigned this user to the group "View Only". I then placed the group "View Only" to the Security Role "DimensionLibraryPage".  The user is only able to see the DimensionLibraryPage, but he can still delete members in the dimension library. Any idea what of what I am doing wrong? Is it actually feasible to provide view access only?   Thank you very much!  

Hi, Is there any option to restrict some of the users to post unbalanced journals ? we are able to restrict it in the journal templates. But we also want to restrict when user try to create by clicking on "Create Journal". Using the event Journal rules, we are able to restrict for all the users ( Including admin). Need the solution to limit this to section of users.   Thanks.    

I know that there is the comparison utility, however I would like to compare extensibility in a cubeview. I am looking for a Dynamic Calc which gives me True or False if an account is part of the SummaryAccounts (compare the SummaryAccounts with the DetailedAccounts)In the cubeview rows I will retrieve the A#DetailedAccounts.TreeDescendantsInclusive. In the columns I would like to have the dynamic calc which gives me true or false (in V#annotation) if part of the SummaryAccounts.The result should look like this:Somebody who already made/tried this? Or has a better solution?Regards,Arjen 

Does anyone know the max number of characters when entering text into the annotation field?   Thanks!

Hi Community,Is there configuration available to restrict users such as administrators from having the ability to submit and post (their own) journal entries? In practice we would not do this but from a control perspective would like to be able to show that we can prevent it from happening. Thanks

Hi All - Every time I upgrade OS I have 4-5 people that when they launch the OS shortcut it does not auto update.  They have to reinstall.   It seems to be the same people each time but I cant see anything special about them.   Has anyone run into this and figured out what the issue is?   Our latest upgrade is  to 7.1     Note:  I always have them close any open windows and then try shortcut.  They have also tried rebooting.   Any ideas? Thanks

Hi All, I am trying data cell access security to block access to specific UD1 members. These are members that should only be visible by global people. I have applied this: For the UD1 filter, this is the filter: U1#Top, U1#G_HQONLYREC, U1#G_HQONLYADJ But, when I log in with a test user, who does not have the group mentioned in the data access security, I am still able to see data. What could I be missing?   With kind regards, Tim

We built only our different types of security (Data, WF, Access, Certify...) into Hierarchical structures. When using the SAR solution, it just lists all roles and does not say it is direct or indirect so for some users the list is very long.  This has our Auditor very confused and asking why they need all these different roles when they really only have say 4.  Anyway to run a report that would say this is direct (Parent Grps that Contain This User or Child Grps and Users) vs. indirect/Inherited (Parent Groups that Contain this Group).

All - I am working on Conditional Input rule and when I create a Finance rule & attach to the Cube business rule it is working but when I am trying to call the Finance rule or extender rule using DM job it is not locking the cell. Any idea? why it is not working? Any input is appreciated. Thanks   Case Is = FinanceFunctionType.ConditionalInput'If api.Pov.Time.Name="2022M1" ThenIf api.Pov.Scenario.Name="Forecast" Then'If api.Pov.Account.Name.XFEqualsIgnoreCase("ReadAccts")  ThenReturn ConditionalInputResultType.NoInput'End IfEnd If

I am taking a copy of an application to create a Sandbox for the users to test things. I have been using the document 'How to make a copy of a OneStream XF Application' which I found on ServiceNow. While the document explains how to take a copy it doesn't explain the options. I found I have to select the option 'Create a New Application Unique Id' when renaming the application: I can't find any reference to it in the 'Design and Reference' guide nor the Foundation handbook. I think it means that by renaming the application, you are creating a new application separate from the source application rather than simply changing the name of an existing application. Can anyone confirm or correct?   Thanks Marcus

I may have a requirement to filter a member list based on the project manager. Whenever data is loaded the PM assignment may change. I am thinking of potential ways to capture the current PM assignment, but don’t know if they are possible. Leverage a text field to input the project manager name.  Then use a variable like UserName or  UserText to create a member list. Is it possible to create a member list/parameter using |UserName| or UserText variables      U2#TotalProject.Base.Where(Text1 Contains |UserName|) Given the Text1 value on the project can change every time data is loaded, is there a way through a data load to update a text field? Load the PM into a data cell using the View member “Assumption” and None for most other dimensions.  Then trying to create a member list with logic..something like where Username=Assumption value of current period. This removes the need to update Text1.  If it could work, I think the evaluation time

An account can exist in multiple account dimensions. Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello! Can someone point me in the direction of the definitions for the status numbers on the Data Records table? I also submitted the question to OS support because I can't find the info anywhere. Here's where I mean:  Thanks!

We have several equity accounts with "USDOverride" entered for Text 1 in the "Vary by Scenario Type And Time" section of the member properties. Those accounts are not translating from local currency to USD.  Any ideas why that would be? Thanks!

Is there a way to enable Account descriptions in other languages like Dutch?

I need to move data between two mutually exclusive cubes. Cube1 (FinPlan) U3 dimension base level is ProductType, Cube2(SalesFcst) UD3 base level is SKU which rollup up to ProductType. SKU also has a Text6 field containing its ProductType Code.   I also have separate Account dimensions: Cube1 uses FinAccounts for Forecasting, while Cube2 uses the SalesFcstAccts dimension   To move the data from Cube2 to Cube1, I tried using a Business Rule using the api.Data.ConvertDataBufferExtendedMembers function Cube is an option:    Dim summarySalesFcstData As DataBuffer = api.Data.ConvertDataBufferExtendedMembers("SalesFcst", "Fcast1", dbSalesFcstData) However, it didn’t replace the SKU with its ProductType. Does anyone know is this function will work between mutually exclusive cubes with different account dimensions. The second approach I would like to try is to extract the data from Cube2 including the SKU Text6 value of ProductType, then I

Hi !I'm interested to get data from the AuditFXRate table, however this table is not giving the Currency names, but only its ID.The problem is that, the Currency names are nowhere to be find in the datatable of the application ( it is not in the "Member", "MemberProperty" or "MemberDescription" table). The only plase I can get a reference of these currency is in the "AppProperty" table, where all currency are stored in one row.Needless to say, the table "FxRate" is not showing the Currency Name as well 🙂 --> Where can we find the CurrencyID + CurrencyName information in OneStream ? Regards,

Hello I have built a workflow structure for a statutory application where every legal entity has is own workflow. In the entity assignment only 1 entity is assigned to the specific workflow. Data load and input forms work fine because Onestream blocks user to enter data on an entity <> from the WF entity. Inside each entity workflow we enabled the user to post adjustments.   But for journals Onestream behaves differently.  Because when creating a journal, Onestream propose the list of companies the user has access to regardless which is the company assigned to the workflow.   Here I am in the workflow of company 1.   But Onestream prompt with the list of entities I have access to. So I can post a journal on entity XYZ on "company 1 workflow". So I am allowed to post a journal on an entity outside the assigned workflow.   Is there a way to force the user to post a journal only to the workflow entity?   Thanks, Marcello      

Hello All, It might sound like a simple question but I could not find the code in snippet or elsewhere of how to grab in a rule a list of all groups a user is part of. Could someone share how to do that ? Thank you Matthieu

  I can change accounts and entities by scenario, just using scenario views Question Credit: Peter Fugere   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

A user must upgrade to the latest software version in order to continue using Onestream Question Credit: Nick Hymes   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello Team, We have IE and Edge browser on the system. Once opened the OneStream application when we do Windows shortcut as per below screenshot it is creating the Windows short cut on the desktop. And, then when we open the OneStream application using the shortcut , it is opening on IE browser. How to create a shortcut for Edge and the application should open on Edge Browser when we use the shortcut. Thank you, Praveen