Exporting a Cube View with Dynamic UD8 Text
Hi all,
I have a cube view that is generated entirely by dynamic UD8 members, some retrieving text fields, returning static text/numerical data, parsing descriptions, etc. I would like to export th...
Forum Discussion
Could be a few different things causing this error. Could be the filter itself. May want to test the FDX with something simple just to see the FDX working. Then layer on the filtering. Could be the data being returned in the Cube View. For example, dates being returned. Not sure how you are testing this, but if trying to test this with the Stage tables, the Amount column is setup as Numeric data type and the majority of the other columns are set up as nvarchar. Neither of these data types are appropriate for dates. FDX route should work for you to stage this data. There is also a BRApi function called ExportCubeViewGridsToExcelFile
Dim objByte() As Byte() = BRApi.CubeViews.Process.ExportCubeViewGridsToExcelFile(si, custSubstVarsForAllCubeViews, cubeViewNamesAndVars)
Then convert from Excel to .csv programmatically. Another possible solution?