Question:
Hello everyone,
We are using Open Hub to create an InfoSpoke from Infocube and load the cube data into a file. In our scenario, we want to calculate monthly sales amount (for all months upto previous month) in our fiscal year. The flat file structure should have 12 columns representing 12 months. But we want to use a single key figure in our InfoCube and do the transformations (splitting 1 key figure into 12 key figures) using BADI in the Infospoke. Could someone tell me if this is possible using BADI. If so, how can we implement it.
Thanks a lot in advance.
Answer:
Go to Transaction Se19 and create a new implementation name and it will ask you to enter Definition name and you have to select the definiton name as OPENHUB_TRANSFORM and enter the short description and enter your infospoke name . click the interface name and double click the method Transform and wirte ABAP code for your requirement.
Hope this helps for you