OneStream Platform Forums

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

Is it possible to assign a page break in a cube view? We have a report when exported in PDF, the header of a section is appearing on page 1, but the lines under that section are pushed to page 2.  

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

We have a client that does a lot of prior period adjustments so they go through the workflow for the whole year a few times. We have automation set up to assist, however they would like a report that shows the workflow status for the whole year and not just one period. I know the application reports are out of the bos that shows a particular month throught method queries. That works great but has anyone ever created one that would pull the whole year? I was looking for a sub variable that does that but cant seem to find one or has anyone done anything different.  Much Appreciated!

Hello - I created a dynamic UD8 calc for a cube view that shows 12 months of actual, forecast and budget periodic amounts. The calc is designed to show zeroes in the actual scenario column for a period if its POV time is greater than than the global time. I added it to the cube view and it works perfectly when I run it for 2024M12 - the actual columns are all zeroes, while it displays the budget and forecast numbers. When I run the CV for 2023M12, since our global time is still 2023M11 I'm expecting zeroes to be in the Actual column, but I'm still getting the opposite sign YTD "no data zero view" totals instead. Below is the formula in the UD8 member - let me know what changes I need to make. I appreciate the assistance. Dim gbTimeName As String = BRApi.Workflow.General.GetGlobalTime(si) Dim gbTimeID As Integer = BRApi.Finance.Time.GetIdFromName(si, gbTimeName) Dim gbYear As Integer = BRApi.Finance.Time.GetYearFromId(si, gbTimeID) 'Get pov year Dim pvYear As Integer = api.Time.GetYearF

Is there a way to export a list of the members in the Accounts dimension to Excel? I'm interested in downloading:NameDefault DescriptionParent

Is there a way to log messages to the Error log within a Smart Integration Function that is running on the Local Gateway?  I notice when a new SIF is created, none of the OneStream libraries are available.   I did find an example where the OneStreamGatewayService library was included.  Is there any documentation on this library? Thanks, Scott

I think I may have found a bug with workspaces but wanted to see if anyone has encountered this issue before.  I am displaying a dashboard with an embedded Cubeview that has a link to a dashboard in a non-default workspace.  When I launch the dashboard, I see the drill link but nothing happens when I click on it.  However, if I add the same dashboard to either the Default workspace, or the workspace where the dashboard resides that I am launching from, the link works without issue.  It seems that if you want to follow a link in a Cubeview in a dashboard it either has to be in the same workspace or in default.  I guess it might make sense because when adding the link in the Cubeview there is no option I am aware of to specify a Workspace so OneStream might get confused as to where to find the dashboard.  Has anyone else had a similar issue or know if I am missing something?

Hi Everyone. I am performing a conversion in a SQL query using currencies; I relied on this other post for now. Where is stored the Currency Name ?  The problem I have is that I have some SourceCurrencyId in the FXrates table that don't appear there, so I want to know if there's a way to get all possible currency names through a business rule.

Hi, is there a standard IRR calculation that can be shared? thanks, Greg

Does anyone know how to get the Year for the time function below to display as the name in the row?  T#YearPrior2(|GlobalTime|)

Would like to check if Quick View in excel can extract/pull - Annotations/Audit Comments/Variance Explanations from "View" dimension. Please assist. Thank you.

Hello,I made a Grid View containing all WF Profile statuses for the current period & cube: I am struggling to do one little trick, changing the column 'Status' icon accordingly ... In the Grid View, I am under the impression that it only recognises 'Status = 2' as green circle, 'Status = 10' as red circle and 'Status = 1' as Blue circle and 'Status = 0' as Empty circle. My question: How can I add 'Locked WF' image, 'Locked, Not Started' and all other states ? Is it possible to put an image of our picking in the grid view's status column ?Temporary solution:I Used the 'Report Designer', since it is the only component I found that enables me to choose an image of my picking but It's not as satisfying as having it in a BIViewer/GridView. Image below  

As the subject line writes, is it possible to disable/hide confirmation rules without deleting them?  I'm revising our current budget work flow and changing the confirmation rules required.  I'd like to keep the prior rules in case they are required in the future.

How can I print DataManagement Sequence name? I have Consolidation email BR but within that email I want to print which Sequence consolidation is running for?    Saurin

I am altering a cubeview that is pretty basic, one column and a handful of rows. This CV had a parameter to dictate the scenario. However, I have deleted the parameter from the cubeview rows and set the POV to my desired scenario. When I go to run the CV, I still get the scenario selection has a pop up. How can I get rid of these selection if the parameter is no longer being utilized in the CV?

Hello, I am looking to build an Input Parameter and additional rule (if necessary) in which the User will be prompted to input the beginning of an Entity (eg. A123) and the Cube View will return all Entities in the rows which start with A123. (eg. A123_400, A123_500, A123_600). Has anyone created something similar to this? Thank you!

I have an input sheet in which data can be entered for an override of another number.  The Cell Status "Is Real Data" flag is used in a rule.  If an override is entered in the early part of the monthly year but not later parts a derived amount of 0 is shown and it's "Is Real Data" flag is false.  My problem is when I use the Data Management step Copy Data to copy to a new scenario.  The 0 cells after the initial user input are now "Is Real Data" = True and "Is Derived Data" = False.  My rule now treats these 0s as if they were entered by user and so doesn't work.  This seems very wrong to me that the Copy Data step can't get the details of the Cell Status right.   Can someone explain what to do here to preserve the cell status after a copy?  Thanks.

I have a delimited data source as matrix data to fetch opening, debit and credit flows. The credit amount comes in as absolute, and I need to factor it with *-1, but opening and debit flows must remain unaltered. As I need the data for RCM, it needs to be converted in Stage so I cannot use a Composite TR to flip sign on A#*:F#Credit.   Any recommendations on how I'd be able to achieve this in the data source?