Skip to Content
avatar image
Former Member

Data Validation on a cell in EPM 10

Hi All,

I wanted to know if there is a way to apply Data Validation in EPM 10. In 7.5 we were setting the memberset of dimensions to self applying the required data validation and later expanding the report or input form based on the requirement, but unfortunately this is no more possible in BPC 10.

Is there any way to apply data validation on a cell.

Thanks,

Sumanth

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Feb 07, 2013 at 02:25 PM

    Hi Sumanth,

    Can you be more detailed about your requirement?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2014 at 04:40 PM


    Hi Sumanth, Please disregard my first post. I have found the location and steps to use "Data Validation" in conjunction with dynamic formatting for BPC 10.0 Netweaver. Data Validation is one of my favorite tools, so I am glad to find the solution. šŸ˜Š Here it is.

    On the ā€œEPMFormattingSheetā€ youā€™ll notice that ā€œData Validationā€ is greyed out. Yet, it is an option under the ā€œUseā€ Column of the ā€œEPMFormattingSheetā€. See image 1 below.

    Image 1

    Here is where ā€œData Validationā€ for the EPMFormattingSheet is located. See image 2 below.

    1. Right click on the Data Cell as shown.
    2. Choose ā€œEPMā€
    3. Choose ā€œData Validationā€ and the normal excel
      Data Validation prompts will appear.

    When the worksheet is refreshed with dynamic formatting the cell will now have data validation on it.

    Image 2

    Again, if this answered your question, then please mark accordingly.


    Imag01 Dv.jpg (209.1 kB)
    Image02 DV.jpg (121.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2013 at 01:28 PM

    Hi Sumanth,

    Did you try Excel validation?

    There is also UJ_VALIDATION in BI system. You may try there.

    - Ashwin.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ashwin,

      There are couple of problems with excel validation in BPC 10NW. I cannot apply data validation in the Format Sheet of the input form and also the data validation applied on a cell in your input form disappears once we refresh the sheet.

      UJ_VALIDATION is obsolete in BPC 10, is UJ_VALIDATION_RULE_LOGIC an alternative for this? I feel that we can handle the issue at sheet level itself without going in for BADI implementation.

      The basic problem which we are facing is whenever ever we enter #N/A in the input form the record is accepted by the system and the value which will be saved is -2146826246, we want to apply a excel rule to stop sending this #N/A.

      Thanks,

      Sumanth

  • avatar image
    Former Member
    Sep 17, 2014 at 11:41 PM

    Hi Sumanth, I encountered a similar issue and am using =EPMCopyRange. It will copy a cell with Data Validation on it to the data grid. I found it most simple to use EPMcopyrange for the entire row.

    Note:

    1. Remove Data Values from source cells. If you have data values in the source cell remove them, otherwise they are copied into the cells and you cannot see what is retrieved.

    2. Keep formulas. If you want to keep the formula on the cell, then keep it on the source cells.

    3. I am seeing that data is saving, but on refresh I don't see the value in the cell, but it is there. Change the formatting or retrieve in another column without the datavalidation and you will see it.

    If this answers the question, then please mark the response as such.

    Add comment
    10|10000 characters needed characters exceeded