Skip to Content
avatar image
Former Member

EPM Perfomance

Hello,

I got a quick question:

What are the most fast option or combination from EPM template, in ascendent order. hide/supress

1. Filter (by EPM  Report Editor - Filtering)

2. Rows Empty / Zero Values

3. Exclude Members.

I know everyone got different functionality, but, I would like to know the performance wise what would be the order, or combinations...etc... the best practices

See.. the exclude member is taking too much time when i'm doing CALC = Y or N for two Dimension... and I would like to replace it.

Thanks.

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 27, 2015 at 10:26 AM

    The question is - what do you want to achieve?

    1st and 2nd options can do more or less the same things but 3rd is absolutely different!

    2nd is fastest.

    Vadim

    P.S.

    Enable:

    User option -> Others -> Select Force Symmetric Refresh for Large Asymmetric Axis.

    Add comment
    10|10000 characters needed characters exceeded

    • The issue is that the combination of Region and Product - Supplier is not defined somewhere...

      Then the person responsible to prepare the input schedule has to create it manually - line by line.