Discuss the features and functionality of OneStream.
Recently active
Hi, I have built a Finance business rule that users a data buffer to identify base level UD1 members with data at a specific intersection and sort the results. The user is prompted to select a parent level Entity and that is passed to the BR and used in the buffer. Note: The BR is called from a Cube View. What I need to do next is take the parent level Entity that the user chooses, pull in a list of base level Entities under that parent, and then loop through my data buffer for each of those base Entities, and then add the base UD1's to my list if they meet the Text# conditions I check for. How do I go about calling the base level Entities member list and pass them in one at a time into my Data Buffer so it loops through them? Thank You
Hi all, is there a way a flip sign can be applied to a mask account mapping that contains a complex expression? See screenshot below (partly), the customer created nearly 4000 lines of code in here.
Hi All, I'm looking for documentation on best practice to write and NCI calculation? If anyone could point me in the right direction that would be greatly appreciated. Cheers!
Scenario: I have a Sql Editor component, with a couple of date-columns. If the value in the belonging custom-table is value NULL, then the value in the editor will always be the minimum value of the sql datetime type. I just want to show a blank value instead of "1/1/1900". Anybody solved this? Cheers Frank
I am trying to utilize the UD2 and UD3 Default Member fields on UD1 members. For example, I have UD1 members that always go to a specific State. Nothing is showing up in UD2 for the State after transformation. Also, I'm not sure how to set up the Data Source for UD2 when utilizing this field since UD2 does not relate to the imported file. From the Reference Guide UD2-UD8 DefaultThis is the standard default Member that can be mapped for a setting and saves having to map toeach Member. If the setting says Default, the mapping will always go to that default. Any help on utilizing these fields is appreciated. thanks
Hello,Is there any way to load a PDF file to OneStream from the Data Sources? What are the steps required to convert the file to Txt (readable format) and can these steps be automated?Thanks,Priya
Hi experts. I have a query with regards to drill-down feature to locate the journals from 'AdjConsolidated' member. The entity hierarchy of the client has multiple levels and they post journals at each of this level (i.e at parents as well as base entities). When we drill down by origin from a top member and want to further analyze the balances under 'AdjConsolidated' member, we understand that drilling to entities won't give the desired results as the jnls were posted against Adjinput members. Hence, they have to start the drill down by entities from Origin 'Adjustments' Member and keep checking for each sub-structure below it to see if the jnl comes from an Adjinput / Adjconsolidated member. Is there a better way to directly drill down to the actual jnls that were posted. Regards, SC
Hello, I have a question about multiple applications. I know typically people think of OneStream as having everything within one application seperated by cubes. Thinking of an application where Planning activities are quite different than existing consolidation activities and I am a bit weary of trying to jam it all into the existing Consolidation application. I am wondering if it would be easier to organize in a seperate application altogether so there would be a planning application and a consolidation application and the planning data would eventually be loaded into the Consolidation Application after it's approved. There are a number of reasons that lead me to entertain this idea one of which is performance and that we may only ever want to 'Aggregate/C#Aggregated' the data in Planning and 'Consolidate/C#Local' the data in the Consolidation application and we don't want it to get confusing with what data to use for the users. Other reasons relat
Scenario Today I have a process where I can generate a Spreadsheet with an included Tableview object, and view the spreadsheet output in a dashboard. What I want to achieve is automate the process, so I from a BR function can fully automate the process of generating the spreadsheet, and then save the spreadsheet as Excel to a specific folder, with a given naming convention. Anybody have done something like this? Thanks and Cheers /Frank
Has anyone used Git or another version control / source control system with OneStream? Currently, we keep a lot of commented out code in our OneStream system. It would be a lot nicer to be able to only have to keep the latest in production, and have a version control system track the changes. By default ( not that I know how to change it) the OneStream app does only 1 XML document per type, so the changes aren't tracked at the individual object level, and you'll get a lot of changes to search through. Has anyone made it work, or are you aware of a best practices document or other doc for this?
Hello, Within a Cube View, I would like to store some "Comments" in a dedicated Row. For display purpose, I would like to adjust the height and the width of this specific row, so it does like a kind of "text box". I can't find anyway to adjust the height in the "Data Explorer" mode. Any tips, Cheers, Nicolas
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) &
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
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.
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!
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 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, we have 40-50 workflow nodes which makes the workflow assignment a large burden to complete. We are using workflow templates to manage these nodes. Is there a way to assign the workflow to the template vs each individual node in the workflow?
Hello, Is there a way to aggregate the result of an expansion within a member filter? For example, I have multiple entities that are Australian. I would like to aggregate the balances of all of those entities into a single row. I'm using the attached syntax which produces the entire list, but I would like all the results to be aggregated into one line item without all the underlying detail. Does anyone know of a solution? Thanks, Sean
Hi Fairly new to OS and i am looking for a solution/workaround on MemberName and Description in POV. To explain further, in Quick View when any dimensions is in POV (See attached Pic) then OS only shows the MembersName not Description. I need to see Description there as my naming convention for UD is Code - Description. Having code to be viewed in POV is tough to track and know what code means. Thanks in Advance...Sandeep S
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.