OneStream Platform Forums

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 Just wondering if it's possible to format the page numbering when running books to ensure the output is based upon the page number and the total no of pages in the book.  For example if there were 30 pages in total in the book then I would need the format sequence as follows: page 1 of 30, page 2 of 30, page 3 of 30 etc........... up to and including page 30 of 30. With the current standard formula for suggested format : (i.e.) The output is currently as follows: page 1 of 1, page 2 of 2, page 3 of 3 etc............  (this isn't really useful for a book)   Thanks      

Hi All, I have UD1 and UD3 dimensions, here UD3 made as Is Attribute= True and linked to UD1 as Related Dimension Type=UD1, and i want to load and see the data in UD1,Account and UD3 combination, can anyone suggest how to achieve this scenario   Thanks in Advance.

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 am using a column override formula in my cube view and I have noticed that it doesn't work when I try override a column when the name has spaces in it, even if I surround it in square brackets. Am I doing something wrong? Regards, Mark

Hi,  I am trying to load a CSV file to OneStream through my Workflow. I have a few rows in my csv file where the IC column is empty. I am trying to map those IC lines to go in "None". How would you do this? I have tried through a one-to-one mapping; source: |null| and target: None, but it doesn't seem to be working. Thank you

We have an intercompany dividend we are trying to eliminate using a plug account. One entity is recording the expense the other entity is recording the dividend as an equity account. We are utilizing a plug account to match and have it appear on an intercompany statement.  Is it possible for the system to eliminate the amount using a balance sheet vs p&l account? I am seeing the consolidation top level hierarchy reporting out of balance in the balance sheet.   

Everyone, we are trying to create a data buffer using GetDataBufferUsingFormula where we would like to have the current entity or all the DU member's information included. Is there a way to do that? the idea is to get the buffer and then apply a filter based on the entity key. 

I currently have a cube view set up that allows the user to enter lines of text to serve as commentary on the overall dashboard. The issue I am having is that the cube view does not allow for multiple lines of text on the same row.  I have done some research to find using a grid view allows for multiple lines of text in the same row. But I am not sure how/if it is possible to configure the grid view to appear similarly to the cube view but allow for multiple lines of entry within the same row.  Is it possible to replicate the cube view shown below but using a grid view to account for the multiple line of text functionality? Any help is appreciated!

I showed it at Wave and share it with all of you: when you use JSON to log, you can log anything, not just strings, you can log a Dictionary, a list, a MemberInfo, even a Databuffer. First, you need to import JSON, add these 2 rows at the top of your rule: Imports Newtonsoft.JsonImports Newtonsoft.Json.Linq Second, when you want to log, use JSON! Dim stringobj As String = JsonConvert.SerializeObject(lCenterInfo,Formatting.Indented)api.logmessage(lCenterInfo.Member.Name & ", lCenterInfo: " & stringobj) When you use ,Formatting.Indented, your log will be correctly formatted. Thanks to Matt Ha for enlightening me with JSON and RobbSalzmann for sharing how to have the JSON string correctly formatted!

Hello Everyone,I am having issues retaining the previously selected parameter value in the dashboard, which is linked to a button component. I have a dashboard that has a parameter to pick an entity, and this parameter is attached to a button component in the dashboard. Let's say I run the dashboard and pick an entity X from the button for the first time. If I try to open the same dashboard again and again, the same entity X gets displayed by default, which is expected.Now the problem is when I attach this dashboard to a workflow. From WorkFLow, the entity that I picked for the first time in Dashboard is not getting retained when I open the same dashboard multiple times from through WorkFlow. Is this behavior expected, or am I missing something here? It would be great if anyone could help here.Thanks, Balaji V

Originally posted by Rich House4/22/2020 Hi, I have a query I'd like to solve. I have a data source where the Entity and UD5 are in general driven from the same column ""Profit Center"", column 6, in a delimited file. However there are instances when the ""Profit Center"" column is BLANK. Is it possible for those instances to use a different column i.e. use the ""Company Code"" column 1. If its possible, what is the best approach? Or perhaps, can I populate ""Profit Center"" with the ""company code""? I could then use 100 and 600 in my transformation rule

Hi All- we have a situation where we are receiving two separate ledgers, one in Local currency and one in USD. The USD ledger includes adjustment and revaluation effects on several accounts in addition to translation. For non-USD entities we are just utilizing the Flow dimension and a USD Override base member to store the USD value, with a business rule to override the USD translated value with the USD value from the second ledger. For USD entities this isn't working, and we get a formula error if we try to force C#Local to differ from C#USD. Is it possible to set the value of C#USD to a different value than C#Local for a USD entity?

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.  

Morning community,   A user is uploading information using the embedded spreadsheet, for some reason is getting the following error: "The size necessary to buffer the XML content exceeded the buffer quota" and we have no idea why is this happening. Adding a screenshot of the error.   Can someone please give me some light?   Thank you, Arion

Hello, does anyone know if we need to worry about this warning?  There aren't much details provided in the error log. Summary: SQL Blocking detected: Database Name: , Request Session ID: 72, Blocking Session ID: 12, Blocked Object Name: , Resource Type: FILE: 9:0, Requesting Text: , Blocking Text: , Request Mode: , Blocking Time: 12/2/2023 8:05:57 AM. Thank you,      

I didn't yet find a post about this anywhere so adding this here in case anyone else encounters the same problem. If a user has an Excel with a formula that references a cube and a scenario that is not valid for that cube (i.e. there is no CubeRoot profile for that cube/scenario combination), all cells in the Excel (not just the cell with the mistake) will show #REFRESH instead of the expected values. This will somehow corrupt the Excel so that the problem continues even after the cell is removed and the sheet is refreshed! The only way to get all the other cells to retrieve values correctly again seems to be to remove the cell with the mistake, restart Excel, and then refresh again.

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

Hello there, In an Import WF profile, I would like to duplicate all rows where the UD3 member is different than None. In the duplicated row, I need to change the UD3 POV to 'None' I know this can be done easily through 'Derivative Rules', however I am trying to do so in the Data Source through a 'Complex Expression' or 'Business Rule'. PS: This is bad practice since source data should NOT be altered to keep Audit trails, but in my case I am just exploring possible options