Skip to Content
author's profile photo Former Member
Former Member

Valid combinations for planning and filtering members based on excel values

HI Experts

I have few questions while designing an input form for opex planning:

1. when I create the form, how do I ensure that the data can posted only on the valid combinations, Earlier I was copying data from Actuals and by hiding the zero values rows, I used to get only the valid combinations to change the values. But now it is zero base plan.

2.With EVDRE, i had the option of dynamically filtering the values of one dimension, i.e. Cost center by using its property comp_code which used to get value from current view of company code dimension using EVCVW. How do I achieve this in EPM 10 using report creator, which refer to values in excel for filtering.

I tried using dimension property in member selector but it didnt work for me for this. could somebody explain the functionality of this feature.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 13, 2012 at 10:31 AM

    Hello Shikha,

    1. Sorry, I couldn't understand your question. Pls elaborate. If you are referring to Get Only Range in V 7.5, you have something similar in EPM 10 as well -> Read-only Data tab of the Report Editor

    2. Either you can use the filter button in the member selector window (if you want static expansion based on some property). If it is a dynamic expansion (i.e. based on a property in another dimension selected by user), you will have to use EPMDimensionOverride Function, refer to my reply in the below thread -

    Hope it helps!!

    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.