I have a matrix source file with cost centers (UD1) in different columns. As I see it I run in to two problems. First one is that I extract a separate file for each entity, and different entities have different amount of cost centers. The second problem is that a file can have more than 100 columns and I want to avoid to create that many source dimensions, if it is even possible at all. So is it possible to create a dynamic data source that checks the number of columns in a delimted file?
This is a very interesting question, and to the best of my knowledge there is no easy answer, and this is because the DataSource settings would need to be able to be changed on the fly, which is not currently doable.
However, if the files that are generated have some macro functionality for this, or other form of automation, would it not be a possibility to just have the records be pivoted upon finalization, so that you get the CostCenters as part of the rows instead?
Where are you exporting the files from? If its from a Database using some sort of query then there should be a pivot function that can be leveraged.