OneStream Platform Forums

I was asked today, 'Am I correct to think that Databuffers do not return Null/Blank cells and therefore you don't need to check whether the cellstatus is Not NoData?' The full data unit is in memory and Time is part of that.  The system needs it in memory so it can figure out impacts to the whole year.  When you can a data unit for a month you are calling only part of the full data unit. For future period the data will be there, but not in the prior months.  If the data was there in Jan, but not Feb - Feb would be derived zero. Only because period is part of the full data unit, it is possible that you could have a value in Feb, but NoData in Jan. In that case when call the Jan data and buffer only Jan, you might think you have a true No Data. That is why we have the function to check. Honestly though, if the value existed in Jan, you probably need to run it for Feb too though. Using Is Not NoData should NOT be a default, you decide if you need it or not.

Originally posted by Jerri McConnell3/25/2020 Somewhere along the way a while back, i was given a list of Essbase functions and their OS equivalents...I think it was something Celvin & Cameron put together when they were here...now i can't find it...does anyone have this and can forward to me?

Is it possible to use the where clause for the member expansion ".Tree", specifically filtering on the AccountDim.  There is a top-level reporting cube and a few merged cubes sitting beneath (using entity extensibility). There are also a number of  extensible Account Dimensions utilized... i.e., Level 1 (Highest - Forecast Accounts)                     Level 2 (Consolidated Accounts)                            Level 3 - #1 (Lowest - linked to lower-level reporting subsidiary cubes using base GL Accounts - the account dimension names for these cubes always include 'Base')                            Level 3 - #2 (base GL Accounts)                            Level 3 - #3 (base GL Accounts)         &

Hello- I have created a business rule that uses a buffer to bring back UD1 members that have a value against them, then they are added to a list like this: myList.Add(api.Members.GetMember(DimType.UD1.Id, curUD1)) Later on in my code I do a sort Ascending, and return the results back to a cube view: objMembers = (From member In myList Order By Member.Name Ascending Select Member).ToList() I'm encountering a problem with duplicate values in the results.  This is because a small number of UD1 members have activity booked against them across more than one of the entities I am processing. Are there any quick solutions to removes the duplicates in the add to list or sort steps? The only thing I can think of would be to check if the value exists in the list before I add it, but that would require more coding. Thanks

Hello, Backstory: We have some forecast cube views we embed in our Forecast workflows. These cube views also display under the cube view folder. The cube views are set to the workflow POV and I realized this means users can open the cube view in the cube view folder and if their  POV is Actuals, they can then load to Actuals. I want to prevent this.  I updated the cube view folder security to Admins and then no one could access the forms.  Question: Is there a way to remove specific cube views from the cube views folder, but still allow users to access them in a workflow?  Regards, Ronnie

Statement: You can move data or metadata between applications Question Credit: Peter Fugere   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases   Want more Fact or Fiction? OneStream Press Authors are subject matter experts... but do they know about the 80's, sports, movies, or other pop culture trivia? Are you able to tell if their knowledge is fact or fiction? If so, come for the crown, stay for the fun, and emerge the new Fact or Fiction Champion at Splash San Antonio. Prizes will be awarded! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!

Hi, We're currently expanding on our CubeView & Dashboard reports available in the application & would like to display our performance by Country. Our cost locations are housed in UD1 with the base members being the individual cities and/or states & the immediate parents being the Country. Is there a way we can call the parents of base dimensions of the current UD1 selection? Currently we're able to build out a set structure for countries but if a user doesn't have security rights for a specific location their report will display other locations as 'No Access'. Thanks!

Currently if a step fails the subsequent steps continue to execute

Hello Team,Is there any way to export DM groups and Sequesces & Ste

Hi everyone, Is it possible to set a search/filter option in the combo box where user can type in the value and it will be picked up from the underlying list?  Alternatively, another component that can do it? I have tried using the tree view with search and filter option but it does not display anything if I use member list as bound parameter. Any other parameter type should be used specifically for tree view to work?

Originally posted by Kris Waggoner I have a cube view that has a nested dimension in the rows.  By default, the nested dimension is collapsed and the user has to expand it.  Is there a way to have the nested dimensions expanded by default?  There is a setting for this in the pivot table in BI Viewer, but I don't see how to do this in cube view

I have five cube views attached within a dashboard that utilizes the tabular layout. The content dashboard where the cube views sit is redrawn when a combo box is changed. However, the dashboard always redirects to the first tab. Only the content dashboard is set to redraw when the combo box is modified, and embedded dashboards are utilized to build up to the main dashboard. The goal is to change the combo box without redirecting the dashboard to the first tabbed report. Has anyone else seen this behavior and has a solution to redraw the dashboard with the new combo box selection while maintaining the current tabbed report displayed?

I've extracted the formula file for all metadata formulas,  and have notepad++ installed as my preferred tool for reviewing. What language settings in Notepad++ do I need to use in order to replicate the colour and formatting of OneStream's internal formula editor?

Hi, let's say I have a dimension with Member001 to Member020 being siblings. In a cube view I want to have rows with all members from Member001 to Member012. Using cube view designer, what's the syntax to specify the range, without having lo list all the 12 members? Thank you

I have CV - rows with Accounts as Expansion 1 , and three Origin-member as Expansion 2. I'd like to have the Accounts as suppressed if zero ( no problem) but when I open the +-sign to see the Origin members for selected account I want all three (Forms, Adj, Import) members to show without having to use insert member. User should input data on the O#Forms member which is suppressed unless previously used.  

Originally posted by Vivian ViljoenWe are using the TXM Transaction Matching Solution PV 530 SV 100Is it possible to perform a mass or bulk unmatch of matched data while using the TXM solution?Currently the user can select 50 at a time (max per page) and the un-match, however, in our situation we ended up with a few hundred pages that needed to be unmatched.

Statement: You can copy and paste dashboard components within a dashboard maintenance unit or to a completely different dashboard maintenance unit Question Credit: Chris Bielinski   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases   Want more Fact or Fiction? We’ll be hosting a LIVE game show at SPLASH San Antonio! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!

Has anyone had issues with cell reference links breaking in Input Forms after clicking Submit Sheet? Background:We plan to base level accounts, with our operating expense accounts planned between four departments in UD2. All other accounts are planned at the “None” department level. Example:611000-Base Salary account can be planned more granularly to Dept 100 (Customer Support), Dept 200 (Prod Dev), Dept 300 (S&M) and Dept 400 (G&A). A#611000:U2#Dept_100 = 5,000 A#611000:U2#Dept_200 = 2,000 In this example, we would have a total of 7,000 planned to the 611000 account. Issue:The cell links are only breaking on the 6xxxxx accounts where we are specifying UD2 as a specific department vs. all other accounts having U2#None. Additionally, the values input in the form aren’t going to the correct department. The 2,000 example above from Dept 200 would go to Dept 100 for the same 611000 account. Any advice would be greatly appreciated!

Good morning, We're configurating IC matching permissions. When entity A sells to entity B and there's a difference in amount, user X must conciliate and match transactions. X belongs to seller entity A, and he has permissions in A, but not in B. That’s why he can’t see any IC transactions, unless we give him permissions in B. My question is: what are the minimum permissions in OS to give X the ability to do IC matching between A and B, but no more.   Thanks in advance,     Ramon Odriozola

Happy inflation and food shortages <Not!!>Quick question. I have over 15 years experience in Essbase and find it confusing that we have multiple 1Stream cubes in one 1Stream application - but they all share the same outline!! I think I understand 1S extensibility.Is there an article that explains the differences of Essbase vs 1Stream? I would like to suggest to 1Stream developers to show cube name somewhere when I open a workflow. I don't see a way to tell if that workflow is for which cube!! very confusing.  

Dear Community -    Is there a way to know when the last load was completed? We have multiple cubes (account recs, mgmt, rept), and it would be helpful if our end user could know when the last  process-load was completed.  I know we have task activity manager, but if I could filter only the process load tasks, retrieve the time when data load was completed, and display in a table.  I'm wondering if I need to write a business rule, and integrate that into dashboard/cube. Any idea or examples will be appreciated. Thank you!            

Hi Everyone, We uploaded Track Record Data from 2022 January to 2028 December. But When we check data under Cubeviews- it only shows up until 2026 December. What could be the reason that the cubeview is not populated data for last 2 years. Help will be appreciated. Thanks

I am passing 2 Entities in the Data unit for Calculation as Entity is different in both the destinations  So what i was expecting is that it will run as a for each loop with both the entities so it will pick enitity1 and then run the Calc and then enitity2 and then run the Calc  what i was expecting was that the order will remain same every time it will run that is Enitity1 then Enitity2  but what is happening is that it is first taking enitity1 and then entity2 but when i run it again it is taking enitity2 and then enitity1 in that for each loop  to solve this i used 2 different DM steps but why it is running like this i want to know  Can anyone explain why it is running like this ?

I am trying to troubleshoot a performance issue when running cubeviews as a non-admin.   If a user is not in the "Administrators" group, then a simple cubeview might take a lot longer than it would otherwise (by a large factor, like 3 to 5.)  Is this a known issue?  Are there any tricks to avoid the massive performance hit?

Hi everyone, Can someone explain how the UD Member property "Is attribute member" works? I would like to assign to my UD5 members some attributes and be able to create CubeView base on the attributes. As an example, my UD5 could be Customers and the attribute I would like to assign to each Customer is the type of Customer (Retail, non-retail etc).  I thought I would use the "Text 1" property of my Customer members to input the type of costumers. I would then create a separate UD5 dimension "CustomerAttributes" and list all the attributes. Finally, enable the "Is attribute memeber" property of my "CustomerAttributes" dimension members and do a comparison between the value in the Text 1 of my Customer members and the value in the "Comparison Text 1"  of my attribute members.