Forum Discussion
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...
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.