Skip to Content
author's profile photo Former Member
Former Member

New to BPC


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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 02, 2012 at 08:45 AM

    Hi Simran,

    1. A reference dimension in BPC allows you to validate a property of your dimension with the dimension member IDs of a different dimension which is the Reference Dimension. As an example, the currency property of the Entity dimension is validated against the IDs of the currency dimension so as to identify the currency corresponding to each entity in the Entity dimension. This info will later be used in the currency conversion setup. About your question as to why these four dimensions are only supported. Firstly, I am not sure if there is any such restriction, restriction might be there for user-defined dimension but not very sure. May be those are the minimum dimensions needed for an application, may be.

    2. Significance of transformation files - Transformation file helps you to map your source data to the target data properly. Say, whether or not you want system to consider a header record in thesource file will be taken care by transformation file. There are lot many similar things that a transformation file is used for, it basically contains three sections -

    Options - An example of header record as discussed above

    Mapping - Mapping of source fields to BPC dimensions (say you don't have anything for the time dimension in source file as you know you are loading for 2012.JUL month, in that case you will specify *NEWCOL(2012.JUL) against time dimension and entire datawill go to 2012.JUL

    Conversion File - Any conversion file if it is being needed, say system has time as 2012.JUL and in your flat file you hae it as 2012.07, a conversion file will be needed in that case.

    See this link for more help -

    Hope it helps!!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.