What's the best way to pull 16M+ rows of data
Hello! I have a user group who needs a specific set of data pulled just after close every month in order to populate other reporting tools they use. Here's the formatting they require: I'm ...
Forum Discussion
You can use this function "BRApi.Import.Data.FdxExecuteCubeView(si, cubeViewToExtract, entityDimName, entityMemFilter, scenarioDimName, scenarioMemFilter, timeMemFilter, nameValuePairs, includeCellText, useStandardFields, filter, parallelQueryCount, logStats)" to retrieve the data into a DataTable. Then, using a StreamWriter to a CSV.
Hope it helps!
Thanks - is there more instruction somewhere that you know of which I could review to see if this will allow the flexibility I need?