cancel
Showing results for 
Search instead for 
Did you mean: 

Data should not come when EPM OLAP UniqueName1 = Blank member

Former Member
0 Kudos

Hello Team,

I need your input on EPM OLAP member formula. Generally, we refer manual member in UniqueName 1 and existing Unique value we shift manually to UniqueName2. I guess, UniqueName 2 is alternate OLAP member value to get data based on context member value.

In my scenario, In 3 dimension are on Row axis. UniqueName1 is based on cell value. If some condition is not met, then cell value is equal to blank member or space.  We don't want any transactional value when this reference cell value is Blank member or space. I observed that still it generates transactional data based on Unique Name 2. I tried many alternate things with help of SCN thread, but it is not working.

Do you know any solution? Pls guide

Accepted Solutions (0)

Answers (2)

Answers (2)

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Anil,

Can you explain your requirement in detail apart from that blank member issue?

Shrikant 

Former Member
0 Kudos

Any Solution?