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 ...
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!
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
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...
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....