OneStream Community

NAS · 01-31-2024

Hi, All! I am unable to submit (cubeview form) from an Excel workbook which contains many unrelated sheets. Leaving the workbook as is, I enter a new number in the form and click submit, but nothing happens...No error message, but it doesn't overwrit...

NAS · 11-22-2023

Hi, All Just wanted to share a SQL query I wrote to retrieve base members and parent of a given hierarchy from within a dashboard grid. (Note that the parameter supplies the member ID of the top member in the chosen hierarchy.) Any thoughts on how to...

NAS · 08-28-2023

Hi, I am loading periodic data and in some periods there are derived amounts (due to no periodic data for some periods). The YTD values appear as derived data. However, the parent entity isn't rolling up correctly because the parent is not including ...

NAS · 02-28-2023

Hi, AllWhat's the best way to ensure a specific tree within the account hierarchy has only one member within it. Would like to have a "count greater than one" alert or a report we can run, as inadvertent accounts affect data integrity.TIA!

NAS · 11-27-2023

I love these additions! There is one main distinction. My version allows the user to choose the particular hierarchy member and descendants, but not the entire dimension. (I also need to supply the ID within the parameter which is a flaw I need to ad...

NAS · 11-22-2023

Excellent!  Thank you so much!

NAS · 08-30-2023

Thanks so much, Marcus! In light of the need to create a lot of zeros, I am exploring either stage or possibly a BI Blend solution which (hopefully) will eliminate the need to store zeros. I appreciate your input.

NAS · 03-03-2023

Thanks! I would love the BR option, but I may be able to come up with that myself. I wanted to see if there were any other options before going down that road, but sounds like there's not too many other than what you described. I will give it a try w...

NAS · 03-01-2023

Hi, Nicholas! Yes, I do mean base member, not parents, although I wouldn't mind including them as well. For example, in a net income hierarchy, you would not want a rent expense base member to appear more than once or you would be double counting it....

OneStream Community

User Statistics

User Activity

Excel Add-In Not Submitting Form Data

SQL query to retrieve base members of a hierarchy

Change derived data to stored

Hierarchy validation

Re: SQL query to retrieve base members of a hierarchy

Re: SQL query to retrieve base members of a hierarchy

Re: Change derived data to stored

Re: Hierarchy validation

Re: Hierarchy validation