OneStream Platform Forums

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.

Dear Community: I am trying to add a previous year M12 balance to a SCF report.  I can't seem to get prior year data to come over.  However, If I code the amount it does work. ' api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + A#33100:T#POVPriorYearM12") does not work ' api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + A#33100:T#2022M12") does not work ' api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + A#33100") does not work api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + -62225") ' Returns amount as intended   Thanks

Hi all, i need to buil a chart that it is easy to build in excel, but I don't know how to handle it using a chart in the report designer of the report component.  The chart that i have to build is the one in the attached picture. It is a waterfall chart in which you can see the delta between actual and budget distributed on the different line of business (for example delta between actual vehicles and budget vehicles is 31.5, delta between actual rail control and budget rail control is 13.3... and so on). On the other hand though the two bars representing actual and budget have the percentage distribution of the line of business (for example for the budget you can see that the total is 439.3 of which 57% is for vehicles line of business, 37% is Rail Control... and so on). Is there anyway the chance to build a chart like this one using the report component?   thank you in advance.

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?

Hi Everyone. Is there a way to delete accounts in a scenario that have a certain value, for example, 0?

Hi Does anyone know where all of the below information is stored?    Thank you, Mikki  

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, 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?