how data is transferring from bpc to bi ?

[Former Member]

Hi friends......

I have small doubt regarding Dimensions in SAP BPC related ...

How many maximum Dimensions are created in a model ? And we have 16 maximum dimensions .

if we transfer data bi to bpc how they are merge?

Thank you

Regards ,

Surya

[Former Member]

Hi Surya,

You can load data normally, by designing the transformation file. Maximum number of dimension per model is 20. If you have more than 13 dimension in your model they will be clubbed together  in the last dimension.

Regards,

Kalyan.

[former_member186498]

Hi Surya,

I agree with Nilanjan there isn't a limit of 13 dims in bpc.

Kind regards

     Roberto

[Former Member]

Hi Surya,

BPC can have more than 13 dimensions. I believe the limit was 20. I dont know whether its still there or not. For every BPC dimension, in BW, you will have one characteristic. This characteristic will be assigned to a BW dimension and then assigned to the cube. If you have 13 BPC dimensions, then you will have 13 BW characteristics, assigned to 13 BW dimensions, with the same name as the characteristics. However, once you exceed 13 BPC dimensions, then multiple BW characteristics are clubbed into one BW dimension.

Hope this helps.

[RamanKorrapati]

Hi Surya,

BPC model can have 13 dimensions if we need best performance wise.

BW Cube also have  13 custom  dimensions(chars).. while loading you may pass bpc dim = bw info object.

at BW Side there 3 sap defined dimensions which are not useful for BPC. So BW also have 13 custom dimension only.

But BW dimension is not the same bpc dimension. because bw dimension holds number char objects but BPC dimension itself is char object

Thanks