OneStream Platform Forums

I have a SQL Table Editor on a dashboard, I would like a row to be "pre-selected" from code instead of through a user action (manually clicking on the record).Is this possible? 

Hello - I have a cube view that currently has two columns. The first is just base members of an account hierarchy, and the second is a dynamic calc UD8 that retrieves the text 5 value for each account stored by scenario type. The UD8 is working and pulling the correct text 5 values, however some but not all of the stored item text is delimited by semicolons. How can I split this text by semicolon into separate columns in the cube view?

Originally posted by Henri Roest5/4/2018 Can we pull a parameter in Spreadsheet which is in a Dashboard ?

Hi All, I have created a Cube view which has  negative values in few cells with parenthesis format in OneStream, when i try to export the repot to an Excel am not getting the same format in Excel instead am getting "-" in Excel. I need the same format in excel while exporting. Can anyone suggest the formatting settings how to get that. Please find the below snaps for reference.     Thanks in Advance.

Dear Community, We have a requirement to calculate the sums of two rows total for every month we run. We have a time parameter that is helping us to select the desired month. We used GetDataCell formula to calculate it for the particular month.for an instance if Jan period is selected - GetDataCell((Divide((CVR(Row1) + CVR(Row2)), (1)))*12):Name(Total)  will be the formula to calculate the sum total for Jan. If Feb period is selected in the parameter - GetDataCell((Divide((CVR(Row1) + CVR(Row2)), (2)))*12):Name(Total) this should be the formula. The bolded part should be dynamic upon selecting the months selected in the parameter. If it's June the bolded value should be 6, If it's July it will be 7, and it goes on. When we are switching the periods, we notice the totals are not matching and the values remain constant. We have a requirement to make the totals dynamic when selecting the periods in the parameter. How can we achieve this? Are we need to w

How can we  pass the selected row key using a bound parameter? I am trying to capture the selected row to a BR for further processing. I also have a supplied parameter to collect the bound parameter but it does not seem to work as a delimited list. The active selected items will be passed to the defined Bound Parameterfield as a comma delimited list. The Bound Parameter format will be as: item1, Item2, Item3. Please advise.Thank You,Indu 

Hi all, I wonder if I can use the following code in a Cube Cell Format.        "XFMemberProperty (DimType=Account, Member=|MFAccount|, Property=AccountType)"The idea is to flip value sign in case AccountType is 'Expense'. -----------------------------------------------------------------------------------------------------------------------------  If ('XFMemberProperty(DimType=Account, Member=[RowE1MemberName] , Property=AccountType)= 'Expense') Then               FlipSign = TrueEnd If-----------------------------------------------------------------------------------------------------------------------------  

Hi,We are trying to automate the Workflow to import, Validate, and Load data to the cube using the Business rule. Please let us know how to proceed as I am new to Business rules. Thank you.

hi , Am getting mutiple values from the databuffer for the same intersection. Database has  Status1 ,Value1  then up to ...Status 12 ,Value 12...  I beleive that only the Staus 12 and Value 12 combination alone has to be used but am not sure how it can be pulled in the rule , others are the past values which are stored for that particular intersection..Based on this value further calculation of  % on UD 8 needs to be made. Rule:  Thanks

What I have found is that using the BRApi.Finance.Members.GetMemberInfo or Metadata.GetMember calls with True for includeProperties or even the first call to BRApi.Finance.UD.Text(...) all incur an average of just over 2 seconds and we are looping through 27,000+ projects so 15 hours to check and update the text fields. It seems that it gets cached either in OneStream or the SQL server so a second call done in the update function is no additional cost. The Dimension Library object obviously does this a much faster way, maybe by specifying the individual properties wanted in one of the optional objects versus all properties?   There has to be a faster way.  When using the Dimension Library and setting Grid View's Settings to NOT display parent child relationships, you gain access to the Text# fields.  You can update a lot of these at one time FAST.   I have even updated a function I used to add calling the GetMembersUsingFilter with the option to include All properti

I need to build a cube view that shows my closing & average FX rates in my row set. Which dimension has these options? 

Workflow, journals Hi all, So our client wants the end users to be able to create journals but not post them. Group finance team will review and approve and post all the journals created. I think the security bit can be done using the workflow profile settings. The question is: Is there a way for the group finance users to see all the journals created by end users and go through them instead of navigating to every workflow to approve the journals. Is there a way to do this? Thanks

Hi Team,I am using Excel Column width option in cubeviews to reduce the width of Blank Columns in Excel but it's not working,Please provide me any suggestions

Hello OneStream Infra Experts, I would like to know if we are customer to OneStream and bought the cloud Onestream application, Can't we download and setup an Onpremise Onestream server like Hyperion Onprem version. Please let me know the server details and configuration to Install the OneStream. Thanks

Guys, There is a requirement to reverse the signage of all Revenue Accounts, So we have a Code that gets all The Revenue Accounts and Multiplied it with ' -1' , And the data is getting Flipped . But when we try to Consolidate that flipped Data , It is getting Cleared . Also When We try to run The rule 2 or 3 times , then also the Data is Getting Cleared. Any idea why this is happening. This is the code that does the flipping :Dim accountDimName As String = "Financial_Statements" Dim mFilter As String = "A#[4.00.000.000].Base" Dim lstAccounts As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, accountDimName, mFilter, False) 'filter on revenue accounts Dim lstRevenueAccounts As List(Of MemberInfo) = lstAccounts.Where(Function(x) BRApi.Finance.Account.GetAccountType(si, x.Member.MemberId).Equals(AccountType.Revenue)).ToList() For Each MemberInfo As MemberInfo In lstRevenueAccounts Dim nMemberId As Integer = BRApi.Finance.Memb

Hi All,I am trying to create a simple view using SQL in BR. it works if do it directly in SQL server so no issue with the syntax. When i am trying to do the same using a BR it gives this error: anyone seens this and know the reason and how to resolve it? Code:  

Hi,We are facing one issue where if we pass periodic entry then the next month it is automatically passing a negative amount of the same value but I need it to be zero only.Example-March =10000 (loaded at view periodic)April= -10000 (should be 0)Can anyone help me how to resolve this?

Hello, I'm in the early stages of building a long-term forecasting cube in our application. The initial requirement is that the business can load volumes, SSP, and product cost by product type to a single 'memo' entity, market, and customer, and then the model will allocate this across base members based on some % drivers.  The Entity piece seems the most complex as I need to translate the amounts to the local currency when allocating so that the business can perform sensitivity analysis on FX rate changes. I've managed to get something allocated across a few entities just using an ADC, however it is writing the amounts to local currency as well as GBP (group currency), which means that when the entities consolidate, they remain at their 'local' currency levels. I tried specifying the destination C#, but it seems to not allow this. Has anyone else done something similar, or knows if OS is capable of this?  

Dear community,  We build an Excel import template (XFDRange) for our client's planning process.  We understand it is possible to load Text Value into Stage; however, we need to retrieve the comments in a cube view for an overview, so the comments need to be stored in the cube. Currently, we set two different columns for the View dimension, one for Periodic view to import the data and the other for Annotation to import text.    We saw there were some similar questions raised in the community, but solutions are not applicable to our case.  Hoping to get some more suggestions regarding this!   Thank you in advance! 

When we are using shading in some columns we are losing the top line in our cells. There are total cells that we want that top line but when we use the shading it hides it, is this how it works or another setting? CVExtender?

In a cube view, the row and/or column sets can be set to Cell Type “Combo Box” or "Date" Time, if Date is chosen  a cool calendar and a time display will allow users to select a specific date and time in a data cell, however , the display format is not correct, cell formatting does not work  , this this bcs I am using the annotation view? 

Hi All, Does someone have a best practice regarding scope changes during the year or over the year? I'm already using Custom share so I could add logic which compares Current Period with Prior period relationship properties. Thanks in advance! Kind regards, Jorrit

Hi,Two questions related to XFSet Cell:1. Is there any audit trail to see who entered data via XF Set Cell?2. Is there any functionality where we can restrict specific users from entering data just into XFSetCell but allow them to enter data via other modes like Forms, etc.?

Hi, I have this loop that use multiply unbalance to get the UD3 member segmented in the accounts, this is the current rule but it's not delivering good performance:  I try to recode the rule like this but is not calculating as the loop:  Thanks for your time,

HI All,We are using Control m to trigger DM Sequence in OneStream with API call; we are able to trigger the job without any issues but now the issue is we are unable get response from OneStream to know whether DM sequence completed successfully or failed.Do you know the API, designed to provide success or failure?Thanks in advance.Thanks,Sandeep