OneStream Platform Forums

I have an Import Profile Type that includes a Workspace, Import, Validate, Process Workflow Name. The Workspace step uses a Dashboard that contains a SQL Table Editor component.  The table does not allow updates. When I run the same Dashboard from the Dashboards editor it allows updates.  I've also tried using a Forms Profile Type instead of an Import Profile Type and that allows updates too.   It must be something with the Import Profile Typet that is preventing the updates.  Is there a setting that I can change to allow updates in the Import Profile type?  

Hi,  I am using Derivative Rules in order to generate additional records in Stage. In this example, I have two derivative rules per I/C transaction. The account mappings will bypass the original source value and one condition will be met and therefore loaded to the cube. If the value is greater than 0, then the value will go to 40L1CA.001A_DER. If the value is less than 0, then it will go to 40L1CA.001L_DER. Derivative Rules: Account Mappings: IC Mapping:   The value shown below is $224,469.18 therefore the rule is correct. However, the IC is this case is mapping to None. I was expecting IC to map to IC partner 170 based on the IC mapping shown above. How can I ensure that the IC partner is mapped correctly to the cube? I want to ultimately tie out IC matching report.

Hi everyone. I have the issue that when clicking on a row in an SQL table editor, it doesn't open the view with the correct value, but instead, it displays the value from another table. I have 4 tables that use the same view to edit information, and each one has a different bound parameter, and that value is assigned in the SQL table editor section. Example: As you can see, it's set up in the same way, but where the DItemID value is assigned is where I'm having issues. ¿Any solution to this?  

Hi Everyone.I have a DataCell that ends with a comma, and I wanted to know how I can remove it. Example Etc. UD6Id: -999, UD7Id: -999, UD8Id: -999, My issue is similar to the example, where after the UD8Id there is a comma with nothing following.  

Hi, I have the following code that gives me an error: Object reference not set to an instance of an object. Dim listMbrEntityD As New List(Of Member) Dim dimpkEntityD As New DimPk(mbrEntityD.DimTypeId, mbrEntityD.DimId) listMbrEntityD.AddRange(BRApi.Finance.Members.GetBaseMembers(si, dimpkEntityD, mbrEntityD.MemberId)) I have debugged with errorlog but it doesn’t manage to print anything to see the values, any idea how to solve it?

Hi,  Does anybody know if it's possible to configure a Bound List parameter to show both the Name and the Description as the Display Member? It's valid for Member Lists but I get an error in Bound List parameters.   Lee  

Hi, how can I recover a member that I remove relationship without deleting? I can't create it because exists,  

I am building a donut chart in bi viewer. I am using my Geography UD2 as the arguments. My member names are long: 'United States Region', 'Asia Region', etc. I would like to rename them visually for this report. Is this possible? I cannot rename them in my dimension library, and renaming them in the cube view with the :name() member expansion does nothing. Thank you in advance.

Hello, Is it possible to get the user who completed a 'Form Input' step in OneStream ? To clarify, I am able to do so for 'Import/Validate/Load' steps but I'm under the impression that it's impossible for Forms or Journals. Anyone with a similar experience ? Thanks Here goes my desperate attempt: Dim wfstatus As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, mywfstep) Dim logusername as String = wfstatus.LastExecutedStep.StepLogItems(0).UserName ' (wfstatus.LastExecutedStep.StepLogItems is Nothing) = True    

Hi Community... I'm trying to extract data from CV using FdxExecuteCubeView method..So, if anyone give sample code for that with respected method query means... It'll be very helpful to refer...     I want to know how we are passing values in this method...By CV POV...?Thank You...!

I want to navigate to a workflow from a dashboard button and thougt I found my answer in selecting the open page action and using "XFPage=Workflow".  This works and when i click the button it takes me to the workflow page using my current WF settings.  I was hoping to get more granular and go to a specific workflow and found in the Design and Reference Guide this example which I was hoping to explore: "XFPage=Workflow:NameofWorkflow"  Has anyone worked with this succesfully as I just cant seem to get it to work and not sure if there is some syntax nuance I am missing.  Using GolfStream as an example I am trying "XFPage=Workflow:Houston.Journals" as an example but nothing.  It stops going to workflow at all.  

I need help with keeping some CV formatting when exporting to Excel. The current CV I've built works just fine, but when the client exports to Excel, some of the percent values are truncated to the whole number and the '%' is removed. EX: OneStream CV shows a cell value as "35.6%", but Excel shows "35" I've tried to mess around with the Excel formatting in the designer tab for CV's, but I cannot get the setting to carry over during export. Any advice would be much appreciated! 

How do you consolidate currency overrides using alternative currencies e.g. Base Entity and immediate parent are in EUR and ultimate parent is in USD. Client wants to view consolidated view of immediate parent in USD including the currency overrides. The same reverse is required for USD entity rolling up to EUR. We have created alternate flow members but the aggregation is a challenge.

I'm looking to add a formula that takes an account and subtracts the difference between two scenarios. So, something like this: GetDataCell(A#ProductionTCFacSTd:S#Target_FY24) - GetDataCell(A#ProductionTCFacSTd:S#Target_FY24_SC). Can you please help see what I need to do to make this work in my cube view?

Good Morning!  Does anyone know how to build upon the set up variables in OneStream?   For Example: |CVYearNext| - This gives me the following year of the CV.  What if I want the following Year and the next one? Does anyone know how to pull that data?  So, if the CV is 2022 this variable will give the following year 2023, if I need 2024 and 2025 and so on.  How do you expand on this variable?

Hi Onestream expects,I have a .xlsx file located on my local system's C drive that needs to be moved to the Onestream Harvest folder in order to import it into the workflow. Kindly provide an  Extender Business Rule code on this.It is really helpful to my requirement     

Hi Team, I am trying to create an Input CubeView with an expansion based on whether the 'Allow Input' setting is set to True for our UD5 Dimension Members.  To give a little bit of background, we are using the UD5 dimension for our Customer Codes. The setup is based on the different regions (which have their own cube) and the basis of the structure is captured under 'Customers'. The regions can have the flexibility to add more detail by adding members under this basis structure in their dimension: We have an Input CubeView that is currently set to .Base (from the dimension that belongs to the Cube we are inputting for). However, a member might be a Base member in one dimensions (however, we don't want and cannot input here), but a parent member in the other. That is why I am trying to create an expansion based on the Allow Input setting. However, when I try "Member.Base.Where(AllowInput=True) it is unfortunately not working.  Does anyone have any idea how we can solve this (

In OneStream cube views the features to either "Download Results And Save As A CSV File" or to "Download Results And Open" exists. Both features create CSV files with a comma as a delimiter. This is very annoying because when a comma is also used as thousands delimiter, so the CSV File does not get seperated in Excel columns correcty.Is there the possibility to change the delimiter fpor CSV files? RegardsMartin Gebhartl

Good morning, I am writing to ask if it is possible to prevent the graph labels from overlapping the data. The graph I am using is an overlapping column chart with very small percentages. This causes the data labels to overlap, making it difficult to read the chart. I have built this chart using a Chart (Advanced) component invoked in a dashboard; i have also tried to build this chart in a report component using the report designer, but i realized that i have the same problem with the labels. is it possible to control the position of those labels? Thank you    

Hi, I have a Bound List parameter with Command type SQL. 1. I have first tried to use an XFBR rule within the string of the Like condition. This works fine. 2. I have then tried to use the XFBR to return the full condition "cvi.Name Like..." (see below), but it looks like the XBFR is passed as a String to the SQL statement in this case, without processing the XFBR and returning its output (see error in the last picture). How do I force OneStream to process the XFBR before passing it to the SQL query? What is the right syntax? Note: things are commented out in the code below, but I have of course uncommented the lines as needed during the testing. Thank you

Hi all, I'm struggling to understand how the setting "Use suppression settings on parent rows" in cube views works.  I have this simple CV showing a list of accounts in the rows (1C205000 and descendants) and time in the columns: in the rows "Advanced" section, I set the following: my expectation here is to have all invalid, nodata or zero rows suppressed, except for the parent row (which I expect to be the row corresponding to the account 1C205000). However, when I launch it, also the parent row gets suppressed and I end up not seeing anything.  What am I doing wrong? Thanks in advance for any help!

Good evening, I would like to ask if it is possible to change the scaling from ##,###,###.## to ##.## in the Report Designer feature of the Report component. The data is read from a cube view with a scaling already entered. However, because I use an MD cube view in the data adapter, the scaling set is lost. Currently, by changing the setting in the Text Pattern, the desired result does not occur; I wonder if it is possible to change the Text Pattern so that it returns the desired result. Alternatively, if there is another way to solve this problem. Thank you        

Hi all,Trying to figure out how to position a component in a particular column (or give the appearance of that)It's a grid type and has 5 columns, 2 rows and 6 components (previously 6 columns, 1 row and 6 components but it's too wide for the screen that way) My hope was to put the 6th component on the far right of the dashboard (or at least to the right of the splitter) in a 2nd row.  There's no way in a Grid type dashboard that I can see where you can force a component to use a particular column, or is there and I just missed it? I've tried adding big margins to force it right but that doesn't work either.I'm thinking either this is not possible in a single dashboard and I will have to create a new 1 row dashboard to put that label component in.  But I would sure love to hear any ideas.  It feels like this should definitely be doable but I'm stumped.   I'm adding a diagram for better understanding of what I'm trying to accomplish Much thanks in advance for an

Hi I have got a list of member info and trying to do a simple loop through the list to get the member and it's parent using the following code, however ParentMemberId is always coming back as -1. Dim UD1DimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, "CostCentre") Dim listMI As List(Of MemberInfo) = BRApi.Finance.Members.GetMembersUsingFilter(si, UD1DimPk, "U1#Root.TreeDescendants", False) For Each item In listMI BRApi.ErrorLog.LogMessage(si, item.Member.Name & " | " & item.ParentMemberId) Next I've also tried to include DimDisplayOptions and MemberDisplayOptions using following but I have had no luck Dim cubeID As Integer = BRApi.Finance.Cubes.GetCubeInfo(si, "MY_CUBE").Cube.CubeId Dim scenarioID As Integer = ScenarioDimHelper.GetIdFromName(si, "Actual") Dim dimDisplay As DimDisplayOptions = New DimDisplayOptions(cubeID, scenarioID) Dim memberDisplay As MemberDisplayOptions = New MemberDisplayOptions(True, CultureInfo.CurrentCulture.Name, True, True, True, True, True, 0

Hi Can anyone tell me the name of the Market Place solution that contains a list of packaged UD8 Rep_Reporting dynamic Calcs?  Thanks Guy