Discuss the features and functionality of OneStream.
Recently active
Hi all,I am trying to find a way to set up a member filter where the member's text 1 field contains the name of an entity.My CV row setup is as follows:E#MyParent.base U1#MyU1Parent.base.where(Text1 contains xxxxxxx)in the above example, xxxxxxx should be the name of the current entity.So basically this CV should go through all the base entities and for each Entity, the U1 member(s) that display should only be those whose Text1 field contains the name of the particular entity.There must be a way to do this. The concept is simple. We use a lot of where() clauses here in our CVs but no matter what I try (i.e. where(Text1 contains |MFEntity|), where(Text1 contains |CVEntity|)); nothing seems to give that result. It either completely ignores the where clause and just returns all of the U1 member regardless or it defaults to the total U1 parent.This CV works perfectly if I select a single entity and ask for all of the U1 base members whose text1 field co
Hi,I have created a dashboard extender business rule that picks some CSV files from a server, save them in the File Share, extract some info from the file, then delete them.The issue I am having is to find the right folder to use to import and then delete the files.I initially used the Administrators folder in the File Share/Applications/Groups folder, but that folder is not visible to the not in the Administrators group, so the rule works fine for me but not for other users.Then I have tried using the Incoming folder, which let me import the files, but does not let me delete the files.Each folder in the File Share seems to have a different set of security properties, but that is not shown in the File Explorer. What is the purpose of each of the folders in the File Share (is each of them supposed to be used for a specific task?) and which one is better to use for my scope?Thank you
I am trying to get a stored value in Text1 from an Entity relationship:This is the code that at least does not give me an error when it executes but it does not return the Text1 value.Dim myScenarioID As Integer = brapi.Finance.Members.GetMemberId(si, DimType.Scenario.Id, "Actual")Dim myScenarioType As ScenarioType = BRApi.Finance.Scenario.GetScenarioType(si, myScenarioID)Dim myTimeID As Integer = BRApi.Finance.Time.GetIdFromName(si, "2021M6")Dim myEntityID As Integer = BRApi.Finance.Members.GetMemberId(si, DimType.Entity.Id, POVEntity)Dim myParentID As Integer = BRApi.Finance.Members.GetMemberId(si, DimType.Entity.Id, POVParent)' Get relationship Dim relationship As Relationship = BRApi.Finance.members.ReadRelationshipNoCache(si, DimType.Entity.Id, myEntityID, myParentID)' Get the propertiesDim memProperties As New VaryingMemberProperties( DimType.Entity.Id, myEntityID, myParentID )' Get the stored valueDim Text1Value As String = memProperties.GetEntityRelationshipProperties().Text1.G
Hello,Im wondering if there is a way to hardcode a fieldtoken value when loading data from a csv. For example, I am using the below code:Dim fieldTokens As New List(Of String)fieldTokens.Add("xfText#:[Account]")fieldTokens.Add("xfText#:[Entity]")fieldTokens.Add("xfText#:[Amount]")fieldTokens.Add("xfText#:[EmpID]") '<-- Want to hardcode this to '99999'BRApi.Utilities.LoadCustomTableUsingDelimitedFile(si, .......)But I want to hardcode the results of EmpID to value '99999' before I execute the 'LoadCustomTableUsingDelimitedFile' command. Any help on this would be much appreciated!
The Formula for Calculation Drill Down will impact consolidation performance. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Is there a way to filter a DataBuffer on DataType or StorageType? I'm running a business rule in T#2023Q3. This business rule gets a data buffer for an account. I was expecting the data to be for just the current period (T#2023Q3) which it does however it also brings quarters Q2 and Q1 which I was not expecting! I don't want this "IsDerrivedData" brought into my data buffer. How can I filter it out? ' ƒ WOW! - As we advance the Time we bring in the current and all prior periods. So 2023Q3 brings in data for Q3 AND Q2 AND Q2! ' Filtering by time doesn't work "RemoveZeros(T#2023Q3:A#A_BSRCarveout:C#None)"; IsDerrivedData, StoredByNoActivity dragged in, why?!?! Dim BSRCarveoutDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("RemoveZeros(A#A_BSRCarveout:C#None)")
Hi, Is it possible to pop up a message to all the active users of an application through a business rule? When the data load starts, we want to pop up a message that the process as started. Ragav.
I currently have a UD8 that pulls the current timestamp anytime a user updates an intersection and it works just fine. The issue I am having is that when I run a calculation to push an amount to an intersection, there is no audit trail for that. Is there a table where this calculated audit information is stored? I haven't been able to find anything and I would think that OneStream should be able to track the audit trail of calculated members.
Hey,So I have built a flow to push data from one scenario to another by pressing a dashboard button which start a data management job that execute a extender business rule.The extender business rule is executing import, validate and load with the file created through the referenced data management export data step/sequence. The export data step is using a literal parameter in UD1 that is being set before pushing the dashboard button.Above UD1 selection makes it possible to only push/seed data to the other scenario for just a portion of the total data. Over time there will be up to 10 button executions to push all data in UD1 to target scenario. Everything works fine for me except replacing data in destination scenario/workflow. Currently I use .append in order to load all 10 UD1 areas to one import step in destination workflow/scenario. If the user in this case whould press the button for the same UD1 selection a second time, I would have the data twice. What I wou
Hi,I would like to explore the way to update OpenApplication security role via Business Rule. Any help/suggestion would be appreciated.
Hi everyone, This is a new application and I cannot start OneStream using the shortcut. It gives me the error below. I am still able to open the app but needs downloading it everytime.I checked this note but it did not work:https://onestreamsoftware.service-now.com/sp_cloud?id=kb_article_view&sysparm_article=KB0011265&sys_kb_id=9aaf3adf1b136010b7ec8557624bcbe6&spa=1Also here is the error message in the details:ERROR SUMMARYBelow is a summary of the errors, details of these errors are listed later in the log.* Activation of https://*****.onestreamcloud.com/OneStreamWeb/ClickOnce/OneStreamDesktop/OneStreamDesktop.application resulted in exception. Following failure messages were detected:+ Your Web browser settings do not allow you to run signed applications.
Hi, is it possible to give someone access to the FileShare folder in OnePlace, without giving access to the System tab (from where, using File Explorer, it is possible to browse to the FileShare folder)?Thank you
Hi,I am in a custom business rule. I have a calculate formula like the following one, which works fine:api.Data.Calculate("A#Sales1 = A#Sales2 + 50”) Now let say I want to declare a variable instead of having the 50 typed in the formula string, and pass that to the Calculate, what is the correct syntax to do that? Is it possible?I would like to do something like this (the one below is not the correct syntax, but it gives an idea of what I am trying to do):Dim Growth As Decimal = 50api.Data.Calculate("A#Sales1 = A#Sales2 + Growth”) Thank you
Hi All, I have a combo box that is in the main dashboard called cb_OnMaindash. The combo box has a parameter linked to it (i.e., a bound parameter) this is delimited list parameter called dl_ComboBox_param. The display items (dash1, dash2, dash3, dash4) and value item (Dashboard_1, Dashboard_2, Dashboard_3, Dashboard_4). These value items are actual dashboard that I am trying to pull when ever a user selects a specific item from the combo box. Parametername: dl_ComboBox_paramparameter type: delimited listdisplay items: dash1, dash2, dash3, dash4value items: Dashboard_1, Dashboard_2, Dashboard_3, Dashboard_4Combo BoxName: cb_OnMaindash The issue is when i am testing this and select dash1 the dashboard is loaded but the item displayed on the combo box is wrong for example it would display Dash3 instead of Dash1. same thing if I were to select Dash2 and it will either display Dash1 or Dash3. it will only update the selected item if I click
how can you add calculations into a quickview. how can you add the input fields also? I seen both at splash so i know its possible
Hi dear contributors / members,I am trying to format the Cube View cells to final value divided by 1000.I have setup Scale = 3 for all rows and all columns, however the divided value appears only for the first column.Any suggestions please? Thanks in advance.Kind regards,Irina
I was curious to find out if there is a way to have Grammarly work with OneStream XF in order to get real time spellcheck and grammar check for narratives and annotations.
I am displaying a list of members in a listbox on a dashboard. With the format IsMultiSelect=False, the members with an underscore display correctly. When the format IsMultiSelect=True is used, the underscore in the member name is not shown. The listbox knows there is an underscore because I display the selections on the dashboard and they display correctly.Before I raise a ticket with support, has anyone met this before and has a workaround? Or am I doing something stupid?Thanks
Hi, I am loading periodic data and in some periods there are derived amounts (due to no periodic data for some periods). The YTD values appear as derived data. However, the parent entity isn't rolling up correctly because the parent is not including the derived amounts of the children. What is the most straightforward / best method to include the child's derived value in the parent value for the entity to correct this? (I am ok with storing the children's derived values, but not sure of best method for that, either.)Thank you!
Hi ,Can I use 'AdjInput' when loading through the Import channel in a WF? If yes, what customization is required?
Hi,Report Title is hidden in CV Extender but can it be collapsed?Using above code it is hiding Report Title, But it is consuming too much space, Is there any way to Remove / Collapse / Eliminate CubeView Report Title using CubeView Extender Rules. Any solutions would be Helpful.Thank you
Hello, I have a problem with a couple business rules running at the wrong times from within a dashboard. The background: I have a business rule that changes the formatting of the buttons on a dashboard to show which one was clicked last. The buttons function as "tabs," each linking to a report; the button linking to the currently selected report shows itself as highlighted. To do this, I have the name of the current active button stored in a literal parameter. When a button is clicked to launch a report, a business rule rewrites the value of this literal parameter. (An XFBR String rule then reads this parameter to determine how to format the buttons, and is output to button - formatting - display format). The problem: When I launch the dashboard from OnePlace, the highlighting works correctly, showing a set of buttons with the first button highlighted. When I click another button, the button works correctly by launching a report, but the first button remains highlighted. The li
Hi all, We have data coming into Import/stage that subtotals to zero when it validates/maps into the cube. We need to review this data in import/stage before the validation and the easiest way would be a QV or CV instead of having the user manually go into the workflow and export the data. I thought accessing stage data in a QV/CV was possible but I can't find specifics. Any direction would be useful - thanks!
Hey all,We are trying to creating a toggle button so that the dashboard will render based on the selection. We have 4 Scenarios and we want to compare those but the scenarios will be selected by the end user at run time and s/he can change the selection as many number s/he wants.I have tried to achieve this via Checkbox but that is not working as expected for multiple users as the literal parameter gets updated every time.I tried radio button as well but it looks like so many option (buttons) on the dashboard. Do anyone have any other suggestions on this? Below are layout images on both tries we done. Radio button (first image) looks best but as mentioned above not working as we want too.
I have a dashboard with a button component in which I have a XFBR String which alternates between two colors for the button's image background when clicked. Similary, I would like to be able to alternate between two images for my button when clicked. Is this possible with a XFBR String at all ? I thought I could return the image's file name with a XFBR String under Image URL Or Full File Name or can XFBR Strings only be used under Display Format ?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.