EPMOlapMemberO with Balnk member

[Former Member]

Hi,

I am trying to override the epmolap member with one conditional cell i.e Q2 , my formula is = EPMOlapMemberO(Q2,"[TIME_WK].[H1].[2015.WK.40]","2015.WK.40 - Week 40 FY15","","000"). it working fine while Q2 <> blank.

if Q2 is blank it retrieving the  2015.wk.40 , but i don't need the 2015.wk.40 values.

Can any one help to avoid the 2015.wk.40. values

Regards.

Surya

[Shrikant_Jadhav · Accepted solution]

Hi Surya,

If Q2 is blank then don't override it !

Kindly explain full requirement.

Shrikant

[Former Member · Accepted solution]

Hi,

my requirement is if the month having the more than 4 week i.e 5th week i have to display it.

my cell Q2 get value if the the 5th week in the month, then  Q2 fetch with epmolapmember,

(EPMOlapMemberO(Q2,"[TIME_WK].[H1].[2015.WK.40]","2015.WK.40 - Week 40 FY15","","000"))

its working fine.

when the month don't have the 5th week, then my Q2 cell is balnk and it fetch with epmolapmember , resulting is it displying the 2015.WK.40 values, but it has to show null values.

Regards.

Surya

[Former Member · Accepted solution]

Hi Shrkant,

Fyi...

Q2 cell is balnk here but it retrieving the 2015.wk.40 value

Regards.

Surya

[Former Member · Accepted solution]

Issue resolved ...

[former_member186498 · Accepted solution]

Hi Surya,

good that you solved, but please don't think only for yourself explain also what was the solution, assigning to this message the "correct answer" if the solution was given by another user assign him the "correct answer",  this will help other users with same issue to find quickly how to solve it.

Regards

     Roberto

[former_member183424 · Accepted solution]

Read the blog post to check how these types of reply can create a confusion

[Former Member · Accepted solution]

Hi,

when      Q2 <> " " IN EPMOlapMemberO(Q2,"[TIME_WK].[H1].[2015.WK.40]","2015.WK.40 - Week 40 FY15","","000"),  i applied if condition on Q2 , i inserted one column in report  and replicated the value when the Q2 <> " " in EPMOlapMemberO(Q2,"[TIME_WK].[H1].[2015.WK.40]","2015.WK.40 - Week 40 , and applied the conditional formatting on that column when it will be balnk.

Like that i resolved.

Regards.

Surya

[Former Member · Accepted solution]

Hi,

Sorry for the mistake what i have done.

I was in little busy, that's why i didn't share.

Next time it will not repeat.

Regards.

Surya

[former_member186498 · Accepted solution]

Hi Surya,

thanks for giving the solution now you can mark this as "correct answer" instead of "helpful" so for the other users it's clear what was the solution.

Thanks and regards

     Roberto

[Former Member]

As Shrikant suggested, you can create another cell with an IF formula, so that if Q2 is blank, the value is replaced with whatever value you want.

Then refer to this new cell in your EPMOlapMember formula instead.