EVDRE Format Range Criteria and &rdquor

[Former Member]

Experts - A few questions and request for clarifications on Syntax for EVDRE Formatting.

Has anyone compiled a complete list of "Criteria" that may be used in the Format Range section of an EVDRE report? The help file lists a few "Examples" but doesn't go so far as to finish the job and provide a complete list. For example, I have entered the word "Formula" in the criteria, and it will apply formatting to any cells that have a formula in it in an static EVDRE - but I haven't seen anywhere in the Helpfile that this is a valid criteria! Has anyone else found any others that work??

The helpfile lists four "Examples" of Criteria you can use for EVDRE Formatting. One of the examples it lists is:

{dim.property}= ”u201D

What does "&rdquor" mean - is this just a typo or does this mean something?

Further down in the helpfile it shows this syntax which makes more sense: Account.ACCTYPE="INC". Then in an example it uses "LOCKED" as a Criteria as well.

So to compile, it appears that the following are suitable "Criteria" for EVDRE Formatting:

DEFAULT

CALC

INPUT

LOCKED

[Dimension].[Property]=[value] Example: Account.ACCTYPE="INC".

FORMULA

Does anyone have any others to add?

[PatrickFavre · Accepted solution]

Hi,

This is the list of possible parameter to use inside the CRITERIA column:

- DEFAULT

- CALC u2013 Calculated members

- INPUT u2013 Base-level, non-calculated members

- DIMENSION.PROPERTY=u201CValueu201D u2013 Members that contain specified member property values

- KEY = « String »

- HEADING = « String »

- FORMULA u2013 applied to cells containing Excel Formulas

- VALUE = |<>|<|>|<=|>=

- CHANGED u2013 applied to cells being modified by a data entry action and the workbook as been set as an Input Schedule.

Hope this will help you.

Best Regards,

Patrick

[Former Member · Accepted solution]

Thank you - This is exactly what I was looking for. Perhaps someone can clarify since there is a bit of conflicting information on this subject. The document "Usages and Considerations of EVDRE in BPC 7.0M" on the "How To" wiki page - http://wiki.sdn.sap.com/wiki/display/BPX/EnterprisePerformanceManagement%28EPM%29How-to+Guides

Indicates on Page 29 that the following items are "not supported" - Do you know what "not supported" means in this context?

The following advanced format range is not supported:

1. Criteria

a. Status=n

b. LOCKED

c. KEY="" d. HEADING=""

2. Evaluate In

a. PAGE

b. CELL

c. ROWCOL

This How To document may be found at this link:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70758bd3-8686-2b10-ea85-cc7c5052...

[Former Member]

Hi Greg,

The possible values for Criteria were already listed. The &rdquor stands for " . This is just a mistake in the typo.

Hope this helps.

Regards,

Shoba