Non-file based export of text
Summary:
We would like to export data from a BSO cube in planning which contains text, without the export being a file.
Content:
Currently we have an interface running that export a data slice using a JSON request, Oracle documentaton. However, as stated and tested the Export Data Slices command cannot export data which is stored on members with the Data Type: Text. Which is our requirement. We can export smartlists and those show up as string values, but does not fulfil our requirments.
How can we export numeric and string values from planning in a JSON response (so, not file-based) other than using export data slices? We're also no looking in using native comments in PBCS, but perhaps we can write something in Groovy which stores the text data as a cell comment, which should be exportable using export data slices?