EPM DIMENSION Overide

[Former Member]

Hi All,

Is there  a way to tell the system using EPM dimension overide to display account with member and descendant?

my formula is below:

=EPMDimensionOverride("001","ZAccount",C33)

C33 refer to :

Reports=1 and ParentH1<>"", Reports=12 and ParentH1<>""

above formula display the account without hierarchy structure. I need to display the account by hierarchy structure using EPMdimensionoverride.

Thank you.

[Former Member · Accepted solution]

Hi,

If you want to override members and it descendant  then you can use "ALL" keyword like All(2015.total) it will show 4 qtr and it's baselevel members like  2015.Q1,2015.01,2015.02...2015.Q2...2015.12

Can you explain exact requirement what is Report =1 ? is this any property that maintained in account dimension or report ID like report 001,012 something like?

if you want to overide multiple report in single override statement then use semicolon to separate report ID's

EPMDimensionOverride("000;001","category","actaul,plan|forecast")

or in one cell concatenate your member as per requirment.

EPMDimensionOverride("000;001","categoty",D1)

please explain your requirement with screen shot

[Former Member]

Hi All,

Thank you for the reply.

I have following hierarchy :

PARENTH2 :

A1 - Revenue (property report = 1)

100 - Domestic Revenue (property report = 1)

101 - Internation Revenue (property report = 1)

A2 - Expense (property report = 12)

200 - Salary Expense (property report = 12)

201 - Admin Expense (property report = 12)

I would like to display the above hierarchy using EPMDIMENSION OVERRIDE.

I tried following formula as per suggested, but it doesn't work (nothing is displayed):

=EPMDimensionOverride("000","ZAccount",C30)

C30 refers to : PARENTH2, DEP(PARENTH2)

or

=EPMDimensionOverride("000","ZAccount",C30)

C30 refers to : ALL(PARENTH2)

or

=EPMDimensionOverride("000","ZAccount",C30)

C30 refers to : LDEP(PARENTH2)

Btw,1 am Using Bpc 10.1 , are LDEP, All, Dep applicable for BPC 10,1?

Message was edited by: U-one U-one

[former_member186338]

Sorry, but I am talking about:

A1,DEP(A1)

Vadim

[Former Member]

yup...thanks.

My miss understanding.

[former_member186338]

Sorry, please explain the requirements with more details!

To show some parent account with descendants:

PARENTACC1,DEP(PARENTACC1)

Vadim

[Shrikant_Jadhav]

Hi ,

Try LDEP

For more details refer below link , page number 272

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

Shrikant