2 Replies Latest reply on Aug 11, 2014 1:42 PM by TimG

# Two members with same formula producing different results. Is NONEMPTYMEMBER issue?

---------------------------
Problem Description

---------------------------
We have the same member formula on view member PER and PER_FY. But they are producing different results on the same POV.
Note: PER retrieves on base calendar years like Jan:Dec where as PER_FY retrieves on fiscal calendar like Apr(FY):Mar(FY)

Both members PER & PER_FY when have the NONEMPTYMEMBER condition  - They produce different result
If PER_FY has the NONEMPTYMEMBER condition  commented - It produces the same result as of PER, But takes huge time and is not acceptable.
For member PER, the NONEMPTYMEMBER condition if commented or uncommented - Always produces correct data

Please let us know if there is way Essbase works on member farmula which is producing wrong data.

---------------------------
Period Dimension
---------------------------

Period
|
|----YearTotal
|       |
|       |----Q1
|       |     |----Jan

|       |     |----Feb

|       |     |----Mar

|       |----Q2

|       |----Q3

|       |----Q4

|----YearTotal (FY)

|       |

|       |----Q1 (FY)

|       |     |----Apr (FY)

|       |     |----May (FY)

|       |     |----Jun (FY)

|       |----Q2 (FY)

|       |----Q3 (FY)

|       |----Q4 (FY)

---------------------------
Excel Template
---------------------------
JAN                FEB               MAR               Q1          Q1 (FY)
Account1     Entity1  5                  10                   15                  10           #Missing

• ###### 1. Re: Two members with same formula producing different results. Is NONEMPTYMEMBER issue?

Hi Vijayamahantesh,

That depends upon the member you are using alongwith the NONEMPTYMEMBER.

The defination and usage of NONEMPTYMEMBER is as follows:

NONEMPTYMEMBER nonempty_member_list

where nonempty_member_list is one or more comma-separated member names or calculated member names from the same dimension as the formula or calculated member.

Use a single NONEMPTYMEMBER property clause at the beginning of a calculated member or formula expression to indicate to Essbase that the value of the formula or calculated member is empty when any of the members specified in nonempty_member_list are empty.

Hope this helps.....

Regards,

Amit Khanna

• ###### 2. Re: Two members with same formula producing different results. Is NONEMPTYMEMBER issue?

Further to Amit's post... ...it might help to post the formulas.