ContributionsMost RecentMost LikesSolutionsRe: determining parent by hierarchy Hm... IsDescendant might actually be a more elegant way of determining which parent is the one I care about. It's still an extra step but it's better than the mess I was imagining up above. I don't k...Re: determining parent by hierarchy A few of you really went out of your way to offer some insight and I appreciate that. Ultimately, my "proof of concept" code is quite simple. It needs some extra validation and I'll build in an email...Re: determining parent by hierarchy The "tree traversal algorithm" I've seen used is a recursive CTE that just loops through the parent/child to build that "flattened" field dynamically in a view. That allows us ignorant mortals to wri...Re: determining parent by hierarchy Yes, I have built a better ACM. The problem is that ACM and my solution both require the ability to determine what the current parent is before a child can be moved. That data is not available in sou...Re: determining parent by hierarchy That would be lovely but the corporate metadata team and platform don't track/provide moves (or renames, but that's a different issue.) I only get the current state and it's expected that OneStream m...Re: determining parent by hierarchy Not quite. Let's say I have a management hierarchy and a geographical hierarchy. After some corporate restructuring, the member now exists in a new part of the management hierarchy but remains in the...Re: determining parent by hierarchy I dislike ACM for a variety of reasons but, even if we used it, it wouldn't remove the restriction of needing to know which parent to move it from. determining parent by hierarchy tldr: What's a performant, reliable way to determine a member's parent within a given hierarchy? I have been developing a custom extender rule to automate OneStream metadata updates based on our m...Re: OLEDB positional parameters with a WHERE IN clause It may be worth pointing out that this is basically a data type fix as the subselect using the string_split function is just turning a string into a data type that the IN clause can use. I still kind...Re: OLEDB positional parameters with a WHERE IN clause Ugh, I finally banged my face on the keyboard enough that I got a relevant search result. The missing tool was the STRING_SPLIT function. It can be used in the above example, like so: SELECT Fro...
