How to include Member IDs in data export
We are using an extender business rule to run FdxExecuteDataUnit and write the data (with dimensionality) to a file. The file generated seems to be a standard format with a column for each dimension...
Forum Discussion
I often use a CustomCalculate Package to export or extract larger amounts of Cube data, as it gives me far greater precision as to what I output and how. Run the CustomCalculate DM Package for the desired Data Units. For each Data Unit, fetch a DataBuffer of the Cube data to be exported, then cycle through the DataBuffer outputting whatever fields you like and in whatever format you want. If you need to export data from all the data units into a common data file or data table, you will want to output each Data Unit's data to a common Global variable with locking or bulk insert to a common local SQL table so that you don't have multiple parallel threads headbutting. Since you are invoking this from an Extender rule, you would have the Extender rule grab the final Global variable or SQL table and output it as desired. But you could just as easily launch all this from a Dashboard Data Adapter, or whatever you want.
rhankey do you have any sample code you could include here? I have business rules today that use data buffers but they are always for performing calcs and not using them to export data to file. (I edited this reply to take out the question about the data unit. I forgot, if I call the BR through a DM Custom Calc then I can define the data unit there).
I am not an IT person. My skills are limited to taking what we have (and was built by integration partner), reusing code and extending it :)
Thank you
Denise