Skip to Content

Repetitive local members

Hi Friends,

Env 10.1/7.4

I have a requirement to create a report which has lot of calculations. These calculations are kind of repetitive for every set of profit center nodes.

currently we have 4 top nodes of the profit centers

sample layout

Profit center node 1 (we will have 5 sets)

actual Plan

CY PY LM1 LM2 CY PY LM3 LM4

GL Account

LM - local member (calculation)

These 4 local members would repeat for 4 sets of profit center nodes and the parent node, In total I am having around 20 local members.

This report needs expansion on GL Account, so i have created local members based on position (as columns will not need any expansion)

like LM1= sum(epmposition(1),-epmposition(2)) ... etc and attached it the column axis at position(3) , 4 etc

this requires careful detailed work.

I was checking if there is an easier and elegant way to design a report.

Thanks for your time

Ed

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 20, 2016 at 07:27 AM

    epmposition is not bad option...

    Vadim

    P.S. Or you can use absolute column reference 😊

    Add a comment
    10|10000 characters needed characters exceeded

    • I could understand Vadim, the column are not arranged well. But this is how the client has been publishing his data, from legacy and they want to use the same format in bpc reports too

      I could not change the ordering of the columns, but simplified the "if" statements.

      The values or the % they are looking for is, in comparison to the prior year.

      I was able to use the indirect formula that you have mentioned, attached it to the column axis, and did some work around hiding extra calculations.

      Its not an elegant solution, but cant reorder the columns.

      Thanks again Vadim and Jp for your inputs. Always valuable.

      Ed.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2016 at 03:39 AM

    Hi Ed,

    You can try using the member sorting and grouping function in the member selector column axis.

    Andy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2016 at 06:51 AM

    Hi Ed,

    Is CY,PY members of any dimension? If Yes..then you can add the local member after the PY member instead of position.

    What are the calculations done in the local member? 20 local members are too much too handle in a report....I don't think 20 members are required!

    Please share the screenshot of the report structure to understand carefully.......

    Regards,

    JP

    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.