I have a cube with 107 fields all together. I have to load data from this cube to another narrower cube with ~15 fields.
Classic solution: I generated export DataSource, created all the necessary objects to send the data to the new cube. While doing so, I moved unwanted fields in the transfer structure and to the right side table control (and the text for them changed to black color). When I started the data load, I noticed that the SELECT statement was only selecting pertinent fields (~15).
DTP: I have taken the system recommended mapping. However, there is not way for me to remove the unwanted fields from the left side table. I executed the DTP and noticed that the SQL was selecting all the 107 fields. Obviously, this took much longer than the load from classic solution.
My question is whether I did something wrong. Is there a way for me to tell DTP to remove unwanted fields from the SELECT statement?
(The real project is not just a simple load, so, please don't suggest aggregates and other solutions.)
Thank you very much for your time. I appreciate any discussion on this topic.