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
I'm assuming you are trying to pull data from OneStream to consume in external tools. I would say a combination of FDX and REST API might get you there.
You can use FDX to pull from a dataunit or stage. Since this works only on level zero, you might have to get creative with your rule to pull using functions.
Shameless plug, there is a chapter in our book that talks about FDX and external SQL database in our book.