Discuss the features and functionality of OneStream.
Recently active
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,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 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
Hello All, We had to make changes to our 2022 (Prior period) data as we identified some issues with it. We cleared the data and tried reloading a bulk file with Full year 2022 data (Split Quarterly). Previously, We used to batch import data in one period (E.g. March), all the other quarter end months would automatically get a green tick and show data for that period in staging table.This time when we loaded numbers to March (data included periods M3,M6,M9,M12 for 2022), we can only see the data in March (M3), we are not able to see data in other periods. Please find the below snap for reference. Any help would be appreciated.
Hi,I would like to remove the plus or minus symbol next to member names in a cube view. Is there a setting to do that?I am not sure why the CV is showing the expansion symbol since the members are all siblings (the cube view has A#Acc00700.Children in the pic above), but the cube view shows the symbol plus/minus on the row corresponding to the first sibling. Thank you
Guys , Any idea on how to write a business rule that retrieves a list of all Revenue Accounts .Thanks
Hi,I have an Excel template file to import via the stage. This Excel is using a matrix-style for the values (time in columns) and also one column with a text commentary.As I have to change the view to “Annotation” in order to import a text value, I was thinking about duplicating the rows by a derivative rule and change the view in that rule. The outcome shows the duplicated rows, but these are missing the text value. So this approch is not working.I also tried to duplicate one time column and use a parser rule to change the view. Doing so, I would need to identify, which time period I am in during pasing, as otherwise all rows are changed.Any ideas about that?Regards,Tobias
Hello,How can I change the POV for a Cube View I open in Excel? Is this possible? Regards,Ronnie Karpinski
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.