OneStream Platform Forums

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    

Hello, I am building the Cube View.  As you can see below, I have Quarters in columns and now I want to add new rows for Qtr growth. How to achieve the formula for Quartly growth? I want to compare the current Qtr to the prior year's Qtr in New Row. Below is the formula.  Formula: (Current Year Qtr - Prior Year Qtr)/Current Year Qtr*100  

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 - I know the below code is not a good practice but is there is an alternative way to set the data =0 because I want to clear all Origin Base member and UD2 base. Any help would be appreciated ?    api.Data.Calculate("A#ACCT:F#EndBalInput:UD1#" & ud1Member & ":UD3#" & ud3Member & ":I#" & icpMember & ":C#USD:O#All:UD2#All:UD4#None:UD5#None:UD6#None:UD7#None:UD8#None = 0")    

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.

Hello, community! I'm not sure what the real difference between validate vs retransform would be. Look at my example: On purpose, I changed the IC to false, and I ran the retransform. It presented the intersection error, but the transformation and intersections are shown as valid when checking task activity. Thank you for your help.     Oliveira, Vanessa    

  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 

Hello! When we create a new DEV app copied from our PROD app, the Task Scheduler jobs need to all be disabled in the new DEV app. We have a static text file that we load which generally works fine but we need to remember to keep that file up to date as we add new tasks. Does anyone have a good way to disable all tasks? I don't necessarily want to delete them in case that's what we're testing in the DEV app but I'm open to hearing any suggestions you may have.  Thanks, Nicole

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

There are 2 Column Overrides that can be applied on a Row. Question Credit: Becca Speese 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

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.

  The Member Filter Builder provides examples of calculations Question Credit: Becca Speese 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

When trying to Drill down on a cell using ( Ctrl + Double click ) ,it works fine for Cube view in Desktop application but doesnt work in 1) CubeView in Excel 2) Quick view in Excel Any thoughts?    

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,  

The Workflow Status Reports show the status of the Import, Forms, and Adjustment items that are immediately under the Workflow slider. Is there a way to show the status of the individual Forms under the Required and Optional steps? Our Finance team wants to be able to run a report to see whether individual Forms are marked as Completed or not during the close process. Thank you for your help! Darrin

Hello,   I'm having an issue with some custom logos not being pushed to books when being exported as a pdf. I'm using a cube view extender business rule to point to a particular file path depending on the entity that selected. Although this is working when I export from a cube view directly, I get a strange white box with a red x through it and no data populating when trying to export the same cube view as a book. Has anyone experienced something like this? You'll see an example of it working and not working below:   Working:   Not Working:    

Hi is there a way to display account (or any other element desctiption) while entering journal entries? Thanks, Marcello  

Hi All, Is it possible to block a specific column of commentary for input in a cubeview? Our customer has a requirement to enter commentary on different levels (local, regional, global), but when for example global is entering a comment, they should be able to see the regional commentary, but not adjust it. Is this possible? In the design and reference guide it states that even if allow input is set to false, the update of V#Annotation is possible. Is there a workaround for this? With kind regards, Tim Vierhout

We have an entity that has been sold and it's last data load into OneStream was in October.  We need to load the same data into November and December.  I can do a Data Management copy job to load that same data with no issues.  This data contains local currency entities.  The issue we need to solve for, is this data needs to translate at the October rates for November and December so that at the top of the entity structure the data remains the same values, and not take into effect the November and December exchange rates.  Trying to figure out the best way to accomplish this.  Thank you!

I have a cube view set up with only Account in the rows that I am using the expansion as follows: A#PAT.TreeDescendantsInclusiveR   I would expect this to display as collapsed with PAT showing and the ability to expand the accounts shown, through the account hierarchy using the + buttons and - buttons to hide. Screenshot of actual behavior shown.    Is this a different setting? Am I using the wrong member expansion? 

Hi, is it possible to use time functions other than "WF" in cube view point of view?   For example, I have the time function "T#WFYearM12" (it takes the current workflow year and add M12 at the end to get the December month). The function works as expected if used in cube view rows or columns. However, if I try using "WFYearM12" in the cube view POV, it does not work.   I can set the time to "T#WFYearM12" for each row of the cube view. However, I was wondering if it was possible to use the same or a similar function in the POV.   Thank you