Ad-hoc cube queries from client processes
I have heard that Onestream supports ad-hoc queries and reporting. But I haven't yet found an easy way to send ad-hoc queries to our OneStream cubes. I'm searching for some sort of query interface li...
Forum Discussion
Sorry for the trouble with that API. It worked for us.
However the simplest form of "CubeView" REST API was unreasonably slow for me. We switched to using "data adapter" version of the API, along with a "BR" that relied on the "FDX" onestream-library to point (finally) back at the cubeview. It is sort of a strange, round-about way of getting to the data ... but this ended up being the only thing that would perform reasonably will. I'm not sure what black magic performance-powder they sprinkled into the "FDX" implementation ... but they should have put that everywhere else in the REST API as well.
As a side, I'd be willing to spend more time participating in programming-related topics if they were done in stackoverflow. I think this "one community" is probably not a suitable place for discussions about actual software development. IMHO, This is not really a place to geek out to the level of depth that might be necessary. I think onestream needs to start extending themselves outside these private/closed communities or it makes life very difficult for the average software developer. No developers wants to log into multiple private portals in order to perform their day-to-day tasks....