OneStream Platform Forums

Hi all, I need to assign a value in a field, dependeing on an other. I can do it in Delimited Files using  "api.Parser.DelimitedParsedValues()" but I don't know wich function can provide me the string of an other field.So, in conclusion: how can I do this in a Connector Complex expression? Thanks!  

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?

I was looking for a  way to bind a .net list object to a gridview instead of using DataAdapters. Any examples in this direction are appreciated.

How does one write a calculation where the result needs to land at an intersection that includes C#Elimination. Ideally, I'd want to have a function such as:     Public Sub Book(ByVal si As SessionInfo, ByVal api As FinanceRulesApi, ByVal sourceCell As dataBufferCell, ByVal target As String, ByVal factor As Decimal)     And then call it as     Book(si,api,sourceCell,"U4#SOMECALC:C#Elimination",-0.3563523553)    

I want to run a simple calculation setting one account equal to another.  Account A = Account B.  Account A, the account receiving the data in the calculation, is set to at the member level to YTD for No Data Zero View for NonAdjustments.  The account with the data is set to Periodic. The problem is when Account B has data for some months and then has a calculated 0 in later months.  The Account A with the YTD setting just replicates the last period's data in the months with 0 in Account B which causes the two accounts not to be equal.   I am using the following calculation. api.Data.Calculate("A#AccountA = A#AccountB" , True) How is this normally managed?

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

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!!

Hello,I need to create an automation that uploads flat files with data, that are on a sharefolder, to OneStream.When uploaded into OneStream, those files should be removed from that sharefolder.Does anyone have any suggestion?Thank you!Ricardo

Happy Holidays/ Black Friday,Is there a way to lock downstream steps in a workflow, unless the first step in workflow is completed?As we all know, a workflow shows all the steps. For example, our first step is to load data. Our 2nd step will allow users to make manual entries. We don't want users to jump to 2nd step without passing / getting a green light on first step.It seems like a common request.Thanks in advance.

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  

We have many small controllerships that have to back each other up so they have access to submit and approve/post a journal but we need to be able to prevent them form posting their own journal.  This is an audit requirement

Hello, we renamed some companies adding a space and some text. For example company "64" was renamed in "64 TA" After renaming we started to have issues in the rules like if Onestream does not recognize the space. This is  a sample error message we receive. Summary: Unable to execute Business Rule 'WES_Rules'. Invalid script 'A#4028_02:O#Elimination:F#None:I#64 TA:U1#None:U2#None:U3#IC_Details:U4#INTERCOMPANY:U5#None:U6#None:U7#None:U8#None' near '64'.   Is there some hidden contraint in Onestream that prevents clients to create element with spaces? By the way, do you know if there is any workaround to overcome this issue in the rules? because I belive our custmer will not accept to go back to the simple company code.   Thanks in advance Marcello    

I want to retrieve data from a .csv file from Filestore\Everyone folder and later convert the data in to a a dataTable in an extensibility rule. Does any one has a sample BR.    

Hi, Is there a way where users can input From and To dates time members in a cube view? Currently, I am using a parameter in the time member field in POV section of cube view. I have a business rule with FROM and TO dates (2022M1 to 2022M4) and then extract all the periods within (2021 M1 M2 M3 and M4) that time frame in a dt.  And now, I want to incorporate this function in the cube view. feel free to drop your inputs.

  In an earlier post a user named Sam helped me find a way to find the value of a variable in a Custom Calculate job using the Parameter field.  Now, how can we access the value of the parameter in a regular Calculate job which does not have the Parameter field?   The variable is |CVYear|.  How can we access it directly in a BR (standard Calculate)?   Thanks, Chris  

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!

Can any one provide me with a rule snippet for updating Entity Percent Ownership. I have tried a few things using the SaveRelationshipInfo but it is not working.

Good Evening, It should be something simple but apparently I am missing something. I am trying to get the Value for the Text1 field for an Account Dimension member using a Business Rule. The Text1 value vary by scenario. I trying to use ".Options()" but can get it to work. Is this the best alternative? Would you know of other alternatives? Is there a BRApi function which already does this? Thank you for the help,  

In the monthly close process, we have a number of forms. All workflows have the same Form templates profile. Cubeviews refer to |WFtext1|. On wftext1 is Entity name (one entity per workflow).I have one form that is only applicable to a selection of entities.Is it possible (and how) to parameterise this, so the form will only be visible in a selection of workflows (I do not want to create  different Forms Template Profile for theses workflows)?

Hi I am getting some large numbers out of my confirmation rules and I am looking for ways to format the output so it is easier to read. Preferably commas between the thousands, millions, billions... etc but would also like to know what other formatting options are available as well.   Currently my output is the below and I am trying to make the 'math.Round(Acc1,2)' part easier to read.   Does anyone know of a resource that lists the different formatting options?  Or just how to add the comma seperators?   Thanks Simon