"All" Hierarchy in BPC

Former Member · ‎2015 Apr 29

Hello Everybody,

I have a doubt about updating a hierarchy in SAP BPC, and I need your help.

I'm working with SAP BPC 10.1, and I need to create a hierarchy in a dimensión that is not hierarchized in BW, so I can't import it.

I remember that working with BPC 10.0, I created a hierarchy with a transformation file, making a mapping for all members to "All" in this way.

------ TRANSFORMATION FILE ------

*MAPPING

NODENAME = ID

HIER_NAME = HIER_NAME

PARENT = PARENT

ORDER = ORDER

IOBJNM = IOBJNM

VERSION = VERSION

*CONVERSION

NODENAME = CONVERSION_HIER_CECO.xls!HIER

------ CONVERSION FILE --------

EXTERNAL INTERNAL FORMULA

* All

I have tried this option in SAP BPC 10.1, but it doesn't work. Somebody knows why this method is not valid?

Since this way is not working, I have tried to make a script logic to fill the hierarchy, but I've never made a script logic. The one i've made is:

*WHEN P_DEST_MER

*IS DISTINCT (All, Dummy)

*REC (Parenth1 = All)

*ENDWHEN

It seems so simple, so I think i'm doing several things bad, Could somebody help me?

Thank you in advance

Best regards

former_member186338 · ‎2015 Apr 29

Hi Antonio,

Please read the basics!

You can't use script logic to update master data...

Vadim

Former Member · ‎2015 Apr 29

Hi Antonio,

Are you sure it worked in 10?

To my knowledge what you've suggested will not work at all in BPC 10.

2 options, create a hierarchy in BW, or use start routine to build a hierarchy.

Andy