I started learning SAP BPC recently. I am BI consultant.
I have couple of questions:
1) To Validate the data in BPC we have reference dimensions. But i see that we only have rules for only 4 dimensions where as in application we can have more than 4 dimensions and the remaining dimensions (apart from Account,Entity,category and Time Dimensions ) should also be validated ? My question is:
Why there are only 4 reference dimension rules even though we have more than 4 dimensions in an application
2) we use transformation files to update the data to BPC application.
For example when we are updating the data from flat file to BPC application, source file is mapped with Dimensions of the application and package is scheduled so as to update the data.
My questions is: Why we have transformation file when we can directly link the source fields to that of dimensions of the appliacation.
In other words, what is the significance of transformation files?