Will no one rid me of this turbulent security?
No Archbishop of Canterbury will be put to sword in this blog post but what will be expunged is security that no one wants (heh, sort of like the TSA).
I recently imported an application into my local copy of OneStream and…
What went FOOM!?
And in a little more detail:
Bugger, there’s a security group named “S_ACT_READ” assigned to a member on a dimension as a read data group and I don’t have said group on my install of OneStream. I could add it as a security group but that would almost certainly be repeated many times as the import process hit the rows in the dimension import file that have security – not my idea of fun or I imagine anyone else. I could also go into the dimension XML and find it, figure out the open and close of the XML node, and then delete the security assignment it but I’d have to do that across all dimensions, Cube Views, etc. that have any kind of security – also not my idea of fun. Bummer.
Marketplace
Or, I could remember that OneStream has a nifty utility that
