Thanks for the feedback. I'm pretty certain the issue is with #2. It is a consistent slowness, rather than something that may come up as a result of being on the wrong server.
My understanding is that there was another project within my company where this issue was encountered as well. I don't have the details. They are out of the office at the moment, but I think they said it was a well-known issue. I was hoping to find an explanation and a work-around here in the forums. But google is not my friend right now.
You have a lot of checkpoints for security to get through before the final results of data are shown in a Cube View.
Yes it sounds like a complex problem. Is there any elevated logging or diagnostics that might help troubleshoot something like this? Should we run SQL profiler and look for certain types of queries against the security tables of the database? Is there any way for onestream itself to track & measure the proportion of time that is spent on security calculations? Are there any onestream perfmon counters on your middle tier?
I'm a developer and I don't have direct access to the onestream servers or these databases . But I think it would help to have a discussion about the general concepts that we would need to understand before we started troubleshooting. And perhaps you could point us to the tools that you would use to start digging into that issue #2. I suspect that the platform team at my company could begin the process of investigating/troubleshooting, and then open a case with you if/when things get overly technical.
This is a valuable discussion for the community. Since this came up in independent projects at my company, then other customers will probably encounter it as well. My experience with performance issues is that the are never "solved" (except perhaps if you made everyone an admin). Rather than hoping for the perfect solution, I was only looking for a community discussion of the tools and techniques to help with the optimization of our security groups.