OneStream Platform Forums

Hi all, Could you please advise what formula is better to use in cube views member filter, when I need to add column with calculated differences between U1 base member at time POV and the same UD1 base member at time PovPriorYear?  

Rolling Quarterly Forecasts- to Import 12-month flat files- Several times daily during a cycle- 12-month Matrix Data Source 1. Forecast Q1 '25 flat file- Columns Q1-Q4 '25 = amounts 2. Forecast Q2 '25 flat filea. Columns Q1 '25 = blanksb. Columns Q2-Q4 '25 = amountsc. Q1 '25 to be refilled with actuals- using a DM Job after the initial Import 3. Forecast Q2 '25 flat file - Columns Q1 '25 = blanksa. Direct Import/Load- Wiped out refilled actuals in Q1 '25 = blanksb. Standard Import (Import, Validate, Load)- Kept refilled actuals in Q1 '25 4. Blank Columns - Q1 '25, etc = Prior Periodsa. Why do Direct and Standard process blank columns differently?b. How to make Direct process blank columns like Standard?- Keep actuals in Q1 '25/prior periods in OS Data Cubes TY.

I'm using attribute members, unfortunately on the entity dimension, so the associated data is stored and not dynamically calculated on Parent Entities. These attributes members do not translate to foreign currencies during the consolidation process ! I'm using a 'Custom Translation', and when I execute the method 'Api.Data.Calculate()' or 'Api.Data.CalculateForTranslation()' the attribute cells do not translate.The only way I was able to actually convert them is by using Data Buffers and forcing the conversion.Is there a reason why ADC methods do not translate attributes ? Is there a hidden property to activate in order to take these members into account ? Should I use 'Api.Data.Translate()' instead of ADC ?Thanks

I would like to return a sum of all rows in my cube view but using the 'sum of rows' is only returning the first result for every account under the main hierarchies I'm calling. This is the literal statement I would like to sum -GetDataCell(A#BALANCE_SHEET.Base.Remove(A#32000).Where(AccountType DoesNotContain 'Liability') - A#BALANCE_SHEET.Base.Remove(A#32000).Where(AccountType = 'Liability') - A#32000:F#BegBal - A#INCOME_STATEMENT.Base.Where(AccountType = 'Revenue') + A#INCOME_STATEMENT.Base.Where(AccountType DoesNotContain 'Revenue'))Has anyone done something similar through an XFBR string? 

Dear all, Could you please advise what type of scenario is better to use for FastClose (first version of actual financial statement numbers, which we want to keep separately)?  

I am trying to create a label which needs to display the gross profit in my dashboard. I have created a data adapter (when running the adapter, it's showing the relevant data) and attached the same in the label. But I am not getting any data in label. Can someone help/suggest what I am missing? 

Hi, I was wondering if anyone knew how to get an extracted list of all artifacts within an environment by artifact types such as business rules, transformation rules, cube view names. I am only interested in getting the names/metadata of each artifact and not the actual data from the artifact. I would like to put these in an excel workbook.  Thanks! Manuel

I have a home page that has a button that takes you to guided reporting. I want it to use guided reporting where the user left off - how it works when you are normally in guided reporting alone. When I click the button it keeps setting Guided Reporting back to having the choose the report group. Is there a step I'm missing when linking guided reporting to a home page?  

I've heard about org by period since my first exposure to OneStream but I see nothing in the docs and no clear discussion about how it works or what the limitations/requirements are. Where does this information live?

I am trying to build a cubeview wherein if i select actual scenario the comparative scenario come Budget Forecast and PY whereas if i select my comparison scenario is PY Fcst or PY. Is there a way with any business rule if i can do?  

Hi,Is it possible to map two account dimensions to two different columns in the fields in DatasourceThanks,Chandu

My team has a requirement for a CV report to show the last 4 trailing quarters and all 3 months of the current quarter.  I was able to achieve this, however when the time period is the first or second month of the quarter, I would like to show only those completed months.  For example, if the period is July I would want my months columns to be June & July.  Currently I am using T#Quarter(|POVTime|).MonthsInQuarter which is showing Jun-Jul-Aug.  Is there any function that is able to do this?  Thanks!

Hi All,I am trying to create the dashboard where I pass all dimension from combo box to button that triggers the DM sequence that has the Export Data step. I get the following error mentioned below.FYI  please see the screenshot of the export data step mentioned below.Can someone please help? Where I am going wrong?

Hi OS Community,Hope you are doing well!Out of curiosity, I wanted to check which approach is more efficient for clearing data: using api.data.clearcalculateddata or clearing combinations using databuffer?Few examples would be really helpful.Thank you!

Hello everyone,We are currently building a solution. Where we try to only pull the PlainText from a RichText component. Currently we got in our research two solutions proposed: Regex solution, which is prone to errors as we need to cather for various cases and exceptionsRichTextBox() functionality, that seems to do what we want as standard (see below) that but that throws an errorSeems this function is not used/available anymore in v8. Does anybody knows if it's possible to use this still in v8 via some additional set up in the app ? Or if we would have a corresponding similar rule in v8 environement ? Alternatively, would you have any suggestions as to how easily manipulate and extract plain text out of rich text object's code ?Thank you in advance for your help!

am trying to create a confirmation rule, to balance the balance, however when compiling the rule I get an error, in another version the rule was broken and no error is shown, any recommendations?

Hello OS CommunityI am trying to compile a BR associated with a transformation rule, but it shows me the following error:Do you know how to resolve this issue?

I have a dashboard where I created Parameter1 using bound list which is referenced in a combo box. A button then passes the data to the business rule. The issue I am having is that it only recognizes the first selected member and ignores all other selected members. How do you pass a multiselect list from combo box in Dashboard in order to loop through the list?

Hi community, For one of our clients we are looking for the following. - We create 52 weekly scenario with each their own start and end period setting in the workflow start time and workflow end time. For example we have the scenario CFF_2022W01 which has a workflow start time as 2022W1 and a workflow end time as 2022 W39. For example the scenario CFF_2022W02 which has a workflow start time as 2022W2 and a workflow end time as 2022 W39 etc.  How can we get a list of members of the range within the start and end time in the scenario. So for example based on the CFF_2022W01 scenario it should return in the list 2022W1, 2022W2 up until 2022W39. For CFF_2022W02 it should return in a list 2022W2, 2022W3 up until 2022W39.There is also the example when the periods run across years. So for example the scenario CFF_2022W27 has a workflow start time of 2022W27 and end time of 2023W13. The list should then return 2022W27, 2022W28 up until 2022W52 plus also 2023W1 up

Hello OS Community - We are in process of testing 8.5 version upgrade and running into below error on one of the BR, looking for solution any help is appreciated. Error at line 963:  Overload resolution failed because no accessible 'GetMemberInfo' is most specific for these arguments:    'Public Overloads Function GetMemberInfo(si As SessionInfo, dimTypeId As Integer, memberName As String, [includeProperties As Boolean = False], [dimDisplayOptions As DimDisplayOptions = Nothing], [memberDisplayOptions As MemberDisplayOptions = Nothing]) As MemberInfo': Not most specific.    'Public Overloads Function GetMemberInfo(si As SessionInfo, dimTypeId As Integer, dimNameOrEmpty As String, includeInheritedDims As Boolean, memberName As String, [includeProperties As Boolean = False], [dimDisplayOptions As DimDisplayOptions = Nothing], [memberDisplayOptions As MemberDisplayOptions = Nothing]) As MemberInfo': Not most specific.  

If a user is part of a security group with the below "Data Cell Access Security" filters, does that mean they would only have access to "Ent_3200"?  For some reason this user is still able to see all base entities however they are still restricted from TOP? Why would the "E#TOP" filter be correctly restricted, but E#top.base not be restricted?     

Hello OS CommunityI am trying to execute the "Run Confirmation" from a Workflow view:But it shows me the following error: Do you know how to resolve this issue?

Hi, I am trying to call Table view service from a spreadsheet. I tried to use the syntax defined in the reference manual. The above syntax is not working. The above syntax works with the Spreadsheet Business Rule Assembly. Anyone tried Table view service type? If so, what is the syntax to call the table view service from a Spreadsheet?  

What is the default state of IsDurableCalculatedData if left out of an api.data.calculate statement?  I'm assuming it's false but I just want to double check.I'm seeing an api.data.calculate statement which contains an "onEval" statement, then a comma, then False.  If I look at Intellisense, the first field after the "onEval" is userState, followed by the Boolean for IsDurableCalculatedData.  How should I read this statement?  Is the False referring to the userState or to the IsDurableCalculatedData Boolean?Thanks,Bob

Dear all, Could you please advise if in OneStream there is a tool, which we can use to automate preparation of consolidated financial statements in Word format based on OneStream and outside of OneStream data (combination of OneStream numbers from cube views and texts that can be manually corrected)?