OneStream Platform Forums

All rules in business rules page must be written in Visual Basic.. Question Credit: Andrea Tout 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

Hi OSAdmin  We have a use case where the existing base entity members will be removed from the parent entity and the data of existing base entity member or the parent entity member needs to be copied into the new base entity that will be created under it, is there a way we can achieve this within cube through Business Rules or Data Mapping after metadata updates are applied and without asking users to update/adjust manually  The above can happen with multiple parent child combinations.   Before Metadata Change Hierarchy A (Parent entity) - Data - 40      A1 (Base entity 1) - Data - 30     A2 (Base entity 2) - Data - 10   After Metadata Change Hierarchy A (Parent entity) - Data - 40      A3 (Base entity 3) - Data - 40 Orphans     A1 (Base entity 1) - Data - 30     A2 (Base entity 2) - Data - 10   Thanks, Vishal Pai

Hi,  There seems to be an issue when pulling members through GridView from the dimension library.  As shown in the screen shot below, when filtering on a specific roll up within the dimension using the parent child relationship reference the report includes duplicate members. This is because OS is pulling all the alternate roll up locations as well. We are wanting to pull just the main rollup so that we can see the members and parents in separate columns within excel. Does anyone know how to get around this or another way to pull this data from OneStream.        

Hi, I have a CV Form where the input is a "Date" Cell Type.  I need to use the date to translate to a OS Time Period.  I am struggling with using the Date value in a Business Rule.  It only returns an Integer and I can't seem to convert the integer to a Date in the BR so I can grab the Year (Dim strYear As String = Date.ToString("yyyy")).  Any help with this? thanks, Greg

When creating a loadable xml format for bulk user creation using internal authentication, we face issue while signing in using the created users (the password encryption and decryption might have caused it)Is there any way out to solve this?For eg. : We created a user TestOS with password as Welcome1 using xml, but when this user tries to log in using the same credential, the user faces sign-in issues.

Hi the community! Do you know the way to proceed to retriev in a cubeview a specific UD where the text of it is set on a specific value? For example I want at the finest level all my UD1 which contain as a Text4 "Long_Lines" I write this as a formula : U1#Shipping_Trade.Children.Where(Text4=Long_Lines) But nothing appears as a result. Did I missed something? Thank you.

Is there a good resource that people use to explain what is contained in each version of OneStream. I read the release notes but I am looking for perhaps a good blog to help explain these features in detail. I typically meet with our Finance users before we upgrade to let them know any features that may be useful to them.

We are trying to load txt file to custom table using LoadCustomTableUsingDelimitedFile but when it runs we receive a "Data load file is invalid or missing" error. The file is manually selected from a folder.  The file is correct, the number of fields in the file and in the table match, the values and the field type match and the field separator is correct. We are uploading the file from a Dashboard button component which calls a Dashboard extender BR. This is the BR code:   Dim filePath As String = args.NameValuePairs.XFGetValue("FilePath") Dim tableName As String = args.NameValuePairs.XFGetValue("TableName") Dim loadResults As TableRangeContent Dim fieldTokens As New List(Of String) fieldtokens.add("field1") fieldtokens.add("field2") ... fieldtokens.add("fieldn") loadResults = BRApi.Utilities.LoadCustomTableUsingDelimitedFile(si, _ SourceDataOriginTypes.FromFileUpload, filepath, Nothing, ";", _ "Application", tableName, "Replace", fieldtokens, False)

Is there a way to set the default application for all users? I would prefer it to always default to our Production application every time someone logs in.

Hi, Do we get to see the member updates made in Dimension Library in the Task Activity? I don't see a Task Type related to this in the Task Activity. It gets recorded when I use an XML file to update the dimensions, but not the manual changes made there. Is there any setting that needs to be made to get this information in Task Activity or should I be checking somewhere else? Please let me know. Thanks in advance, AK  

We set up OneStream approx. 3 years ago. Since then our user base has expanded a lot and we have facing issues in users accessing OneStream. Currently, in order to grant acess we have to add users who utilise different IT Networks as guests to our Azure AD. However, we have a number of smaller entities where we can't do this as they don't have a corporate IT network with an external facing IP we can whitelist. Has anyone come accross this issue and are there solutions we haven't thought of?

Hi all,  I am having trouble with a member formula that essentially subtracts interest expense from interest income: I'm sure I am missing additional dimensions/qualifiers in the member formula, but everything was the exact same except the account of course. Any direction would be greatly appreciated!

Is there a way to get the list of components on the calling dashboard on load? Trying to use:args.ComponentInfo.Component.Name results in nothing, even though I have multiple components on my dashboard. I want to get a list of all components, particularly a label or 2, and based upon user settings/access/Text fields, set labels

Dear community, I am currently using FDXExecuteCubeView in order to get only data coming from a cube view that the user is selecting into a business rule data table. However, FDXExecuteCubeView need to specify the entity & scenario member filters which is a pain when these are parametric. --> So I was wondering if there are other way to get the data coming only from a cube view ? I was thinking of a data adapter component but it seems that the cube view passed in those can't be parametric (ie. the name of the cube view can't be a parameter). What are the other, possible better way, to get only the data coming from a cube view ?   Regards,

Hi, we have dashboard with multiple driver tabs.  if data is entered in one tab but not saved prior to switching to another tab that data is lost.  Is there a BR to check for unsaved data and prompt the user to save? thanks, Greg

Hello,  I am looking to  write a confirmation rule which pulls a value for a flow member across each account. An example would be we have a calculated opening balance and a loaded opening balance. There is a flow members which calculates the variance between the loaded and the calculated beginning balance.  If the absolute value within the validation flow member <> 0 I want the rule to return which accounts are causing the outage within the info1.  I'm looking forward to seeing if if anyone else has come across something like this. Cheers!  

Dear Community, There is a possiblity to retrieve parameters currently available in a dashboard using for instance :      Dim str_myParam As String = args.SelectionChangedTaskInfo.CustomSubstVars.XFGetValue("MyParameter")     However, this means that we need to know the names of the CustomSubstVars currently in the dashboard (in that case, I need to know that the parameter MyParameter is indeed available in the dashboard). In my use case the user can open several cube view hence the parameters will change from one Cube View to another.  Is there a way to list all current CustomSubstVars available in the dashboard ?    Regards,

Is it possible to change these colors globally within an application?: 1. The application colors that are the Blue and light blue that we see at the top navigation and application header bars. 2. The highlight color that occurs when your cursor hovers and selects different cells such as within a grid view or a cube view.

I have created a Dashboard Dara Set BR and I am attached in the data adapter. When I am trying to execute the rule am getting 0 data. See below the entity is always passing as None but when I add a log message in the code the variable is passing based on the selection and printing the correct entity. in My CV i also have the FDXentity parameter. Any Idea why it is happening ? Original Query  {FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=Data,entityDimName=E#|!FDXEntity!|} Substituted Query  {FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=Data,entityDimName=E#None}   Thanks Krishna    

Hi We are getting the following error message on a new data source load' Detail Cache summarization did not produce any Summary Data Rows.'Can anyone share any light on what this might indicate?

Hi All, We are looking for a way to put a currency override on movement flow member (ex. dividends, redemptions, etc...). The current override logic which was provided was OneStream is leveraging the flow dimension to conduct the currency overrides so I am having trouble in determine the best way to work around this. If anyone has come across this before please let me know. I'm looking forward to hearing from you. Cheers!

Hello, Is there a way to export multiple pages of the drill down in a single csv?  It seems like each page of the drilldown must be exported separately, which is very time consuming.  Thanks!

Hello - Wondering if anyone has come up with a efficient way of providing visibility for end users into the calculation logic and/or equations that are being used by dimension members. For example: End user pulls up a Cube View The Cube View is a mix of base members, calculated members, and dynamic calc accounts How can they see the equations impacting the various members? I'm hoping there is a better way than manually documenting it during system set-up and updating with each change. Any input appreciated.   Thanks,Bil

If I like to migrate a HFM rules file, is there an equivalent to the HS.con function?

I am getting an error while trying to access the file from the BR . The process cannot access the file '\\XXXXXX.file.core.windows.net\onestreamshareprd1\FileShare\Applications\XXXXXXX\Groups\Everyone\XXXXXX\File_XXXXX.zip' because it is being used by another process.