BPC : Export data not aggregated in the file

[UmaArjunan]

We tried to export transaction data from a BPC cube using transformation rules and end routine. the package actually hit end routine thrice , due to the fact it process 40000 records at a time,

Exported file has duplicate records, How to solve this issue in BPC ? is there a standard way in BPC to acheive this.

I have checked similar threads and SAP notes related to this. We don't want to store the intermediate results in BPC.

[former_member186338 · Accepted solution]

1. Simple! You can export PERIODIC Measure selecting parent members of some hierarchy. Aggregation will happened on BPC level. No aggregation in badi...

2. Custom logic badi is just a badi that can be launched from script logic. Using QUERY=OFF and WRITE=OFF parameters nothing will be read and written using standard processing. You can write your own code to read data and write it to text file. For example, I am using custom logic badi to export data to external MS SQL server. The benefit of custom logic badi is that I can use script logic with complex SELECT's to specify badi parameters.

[UmaArjunan · Accepted solution]

Hi Vadim,

Option 1 : even though select parent members , due to the limitation of 40000 processing records, i m afraid it might end in duplication again in the export file after the end rouotine .

thats why tried the second option, i could able to implement and got the desired output . It is very fast compared to option 1.

thanks very much for sharing the useful links.

[former_member186338 · Accepted solution]

bi.abaper

1. "i m afraid it might end in duplication again" - no issues!

2. Good option due to additional benefits.

[UmaArjunan]

For the option 2, Yes agreed , txt file can be generated and send to application server AL11 as a text file.

But the requirement is , After the run package is finished using custom logic , export data is to open the file in the presentation screen like an excel or CSV file.

[former_member186338]

Sorry, but instead of saving file in AL11 folder you can save the export file in UJFS - no difference with standard export to text file!

[former_member186338]

Look on something like:

https://answers.sap.com/questions/8374662/bpc-nw-75-save-file-into-the-server-bpc-by-a-abap.html

https://answers.sap.com/questions/12114942/problems-with-data-upload-bpc-101-nw-in-ujfs.html

...

[former_member186338]

P.S. But why not to use option 1???

[UmaArjunan]

I have to export YTD data with end routine . Have to apply account mapping , number formatting, currency mapping etc.

[former_member186338]

"I have to export YTD data with end routine . Have to apply account mapping , number formatting, currency mapping etc." - sorry, but how it's related to export of parent members?

[UmaArjunan]

Hi Vadim,

Could you pl. provide more details to explore on option 1 and option 2.

Usually custom logic BADI is designed to post the data back to Real time Cube..

[former_member186338]

Number of options:

1. Use hierarchy (may be new one) to aggregate and export with required measure.

2. Write CUSTOM logic badi to export data to file.