EPM Blank Suppression on Local Member

[Former Member]

I am trying to suppress an EPM report which has a local member attached to it. The requirement is to suppress all rows which do are blank values in the report and also in local members.  In the attached example, I would want only the last row to be suppressed.

What I have found is when I select the options "Remove Empty" for rows the EPM Tool does not consider the balances in local member.

Appreciate any insights how this could be done in EPM.

[former_member186338]

"In the attached example..." - sorry, but where I can see a screenshot of the example?

Vadim

[julio_cesar_castillo_hern]

I solved a similar issue with VBA, In order to don't break the report, I use the "hide" excel function rather than remove members.

Example;

Dim i As Integer

'firstRow wher you have data

Dim firstRow As Integer

firstRow = 11

'B10 is the first cell with row headers

range("B10").select

'if you 100 members

For i = 0 to 100

     'change the G and L for your data columns to evaluate

     if WorksheetFunction.Sum(Range("G" & i + firstRow & ":L" & i + firstRow)) = 0 then

          ActiveCell.EntireRow.Hidden = True

     else

          ActiveCell.EntireRow.Hidden = False

     end if

activecell.ofset(1,0).select

next

Message was edited by: Julio Cesar Castillo Hernandez

[former_member193143]

Hello Roja,

can you please explain your business requirement, what is the need of only last row suppression...?

As far as I know its not possible to suppress a single row by using standard function.

we can remove either empty or empty and zero values containing rows.

if you want hide a specific row/ last row in your case, I will suggest need to use VBA code.

Thank you ..

Regards,

Saida Reddy Gogireddy