Shape the Future of OneStream Training with our Quick Survey (Gift card available!) Take Survey
Notification
Recent Activity
Data Import Step - Load validated records
We are looking for a load into a financial cube. Mappings are already done in the source system. Is there a way to load records that pass the validation and write the other records to an error protocol. The idea would be that not the whole load is rejected but only records that contain errors, those being written to an error protocol. Many thanks for your support
Cannot reference member expansion 1 from member expansion 2
Hi, I have a cube view with a straightforward requirement. Below is an example of my requirements using the Golfstream app. My rows are set as follows: Member filter 1: U2#Clubs.ChildrenInclusive:name(UD2: |MFUD2Desc|) Member filter 2: T#2011Q1.ChildrenInclusive:name(Time: |MFTime|, UD2: |MFUD2Desc| The below screenshot shows what this returns. The issue is that I need to reference the member filter 1 member from member filter 2. When I use |MFUD2| from member filter 2, it reverts to my top UD2 member rather than reading my UD2 member from member filter 1. I need this to do a more complicated loop through members, and that loop must take the row's UD2 member into account. Any advice or workarounds? User-created parameters and |CVUD2| do not return what I need.Tech Talks After Hours: Data Buffer Manipulation
In this After Hours edition of Tech Talks, join Jon Golembiewski and Tom Linton as they dive deep into advanced data buffer manipulation techniques in OneStream, revealing powerful strategies for optimizing performance and reducing scripting complexity. To receive OnePoints for watching this Tech Talk video, please visit the link below: Tech Talks After Hours: Data Buffer Manipulation
Button Excel and Report in the Cube View Advanced
Good afternoon, I have a question and I can't understand the system's behavior! In Genesis, I created several Advanced Cube Views, but some show the option to open Excel and Report, while others don't. I want them to show up in all of them. How can I do that? This image has what I want, the Excel and Report buttons. This image hasn´t what I want, the Excel and Report buttons. Thanks :)
GetDataBufferUsingFormula
Can someone check if there's any mistake in the below 2 lines. I am unable to execute the BR Dim sourceBuff As DataBuffer Dim srcED As String = args.CustomCalculateArgs.NameValuePairs("sourceEffectiveDate") Dim selectedScenario = args.CustomCalculateArgs.NameValuePairs("selectedScenario") Dim dmTime = api.Pov.Time.Name Dim account = args.CustomCalculateArgs.NameValuePairs("account") sourceBuff = api.Data.GetDataBufferUsingFormula($"FilterMembers(T#{dmTime}:S#{selectedScenario}:U4#Approved_Status:U6#Total_Audit:U7#{srcED}, [A#{account}.Base])")Split hierarchy into 2 dimensions to ensure retroactivity
Hi everyone, We are currently developing a planning solution in OneStream for a client who has requested that the Cost Center dimension (and its related nodes) be updateable every year, while still maintaining full retroactivity when users need to view reports for prior years. We have considered two possible approaches: OPTION 1 Each year, load a new Cost Center hierarchy associated only with that specific year. When users want to analyze historical data, they simply select the hierarchy corresponding to the year they are reviewing. The main drawback of this approach is that, over time, multiple versions of the Cost Center hierarchy will accumulate, which could potentially impact maintainability or performance in the long term. OPTION 2 Separate Cost Centers and their nodes into two distinct dimensions. Introduce a technical member in the Account dimension and use a data entry form (maintained annually) where users enter a value of “1” at the intersection of each Cost Center and its corresponding Node. Source data is initially loaded only at the Cost Center level (using a dummy member for the Node dimension). At the end of each cycle, a Business Rule is executed to populate the Node dimension based on this mapping. This approach avoids unnecessary data duplication, but it introduces additional process complexity and reliance on manual maintenance. Does anyone have experience with similar requirements, alternative approaches or feedbacks on this topic? Thank you in advance!How to read csv file from Documents/users folder?
Hi, I have been trying to read a csv file that is in Documents/Users/userxxxx folder. Not able to make it work. Getting an error. Below is the code Dim FileName As String = args.NameValuePairs.XFGetValue("Param1", String.Empty) Dim sourceFolder As String = $"Documents/Users/{StringHelper.RemoveSystemCharacters(si.UserName,False,False)}" Dim fullPath = sourceFolder & "/" & "abc.csv" Below is the error Could not find file 'P:\Program Files\OneStream Software\OneStreamAppRoot\OneStreamApp\Documents\Users\userxxxx\abc.csv'. Any idea why this is not working? Thank you, MikkiData Adapter SQL Query to view data submitted through Excel
I am here with one of my typical requests to see if anyone has (SQL query) code I can borrow 🙂 We had an issue with two users who discovered how to submit data through Excel and circumvent the workflow forms. As a result they are inputting data to intersections where we do not want forecast data. I would like to have a dashboard I can run where I can select a specific scenario and it will return a list of intersections that were modified through an Excel submit. Or just a list of users and then I can run the ONC application report User Data Entry Detail to get the details of the intersections. I know the data lives in a table somewhere but I am not sure the table name and the fields to filter on and return. In the ONC User Data Entry Detail report I am able to select a scenario, WF time and user name and can see data they changed via forms and data that was changed via Excel. But, there is no option to see all Excel edits for all users and I am trying to catch the rule breakers 🤫. Any help with a SQL query would be greatly appreciated so I can create a data adapter, and display it via a grid view in a dashboard. Thank you, Denise
Mapping IC based if account is IC
We want to set the IC value to none if an account is not IC. We are currently doing this in the IC dimension in the datasource and looking up the account, getting the target and then checking If IC. If it is not IC we pass None as the source value. This works fine unless they upload a new account because it has not been mapped yet it doesnt know its IC and maps to None. The user has to reupload the same file after they map the account so that they get an IC value in the source. I was thinking that I could put a BR on the IC transformation rule but the problem is it reads the 1:1 (where I have the None->None) before it gets to the section for BRs. I guess I could remove the 1:1 None rule and then in the BR check to see if the account is IC and if so then get the IC target. I am just curious if there is a better way to handle this that I have not thought of. We have a similar issue as we store function in a user field but we only want it populated for specific expense accounts otherwise it should be none. When they have a new expense account we have the same problem that they have to reload the import file after they map the expense account.
