Inserting Totals after each row

[sree_ravinutala]

Hi ,

  I have a BPC10.0 Input template , I wanted to add Total after each IO , that is first column in the picture ,

I am using =EPMDimensionOverride("000","INT_ORDER","LBAS(10,"&$J$2&")") on this dimension .

This to make peoples life easy in validating the amounts for each IO .Is there any way to go about it .

Best regards,

Sreedhar .

[Former Member · Accepted solution]

HI Sreedharrao,

Make one local member attach to ID have look at below thread see my reply.

this will solve your problem.

[sree_ravinutala · Accepted solution]

Thank you , it works appreciate your help .

[sree_ravinutala]

$J$2 is nothing but selecting the Node in the Dimension 1  Hierarchy . Relation between Dimension 1 Dimension 2 is based on transaction  data .

My Io might have 50$ in Account 1 , In JAN , 50% in Account 2 in Dec . I keep all the account in a Hierarchy select that Hierarchy  as the default in the report .

[former_member186338]

Sorry, unclear!

[sree_ravinutala]

Sorry , i  will try .

Looking at the picture , for dimension1 I am using  Dimension override

with formula

=EPMDimensionOverride("000","IO","LDEP(10,"&$J$2&")"&","&$J$2)

and this brings the Hierarchical view on IO .

with my Total as local member i get Total for parents also ,

i just want Total for Base members .If it is possible ??

Best regards,

Sreedhar .

[former_member186338]

"=EPMDimensionOverride("000","IO","LDEP(10,"&$J$2&")"&","&$J$2)" - very clear? &$J$2-???

How you populate Dim2?

What is the hierarchy structure of Dim2?

Do you have root parent in Dim2?

What is the relation between Dim1 and Dim2

...

Vadim

[sree_ravinutala]

Is there any way to restrict this total only to base members .When i try the Hierarchical view

higher nodes also getting the total ( Which is already there, making them duplicate  ).

[former_member186338]

With hierarchical view - don't use local members, use real parents!

Vadim

[sree_ravinutala]

Thank you , My problem with that is i have Dimension 1 , Dimension 2  in the rows , I want to display Based on Hierarchy of Dimension 1 , there are cases for one Dimension 1 element there are multiple dimension 2 elements I want to show the Total by Dimension 1 element .Simply this is like subtotal in BW Bex .If i use total then My hierarchical view gets messed up .

[former_member186338]

Sorry, but the explanation is absolutely unclear

[sree_ravinutala]

[former_member186338]

And what is the issue? How do you manage members in the row axis??

Please, spend some time to explain your case clearly!

Vadim