Essbase FIX and IF

[OkuMangalath]

Hi can anybody tell me ,how I can Use an IF command instead of a FIX statement in member formulas ? I know
FIX statements allow you to take a slice of the database and only perform an action on that slice. If you fix on a SPARSE dimension, then you are limiting the amount of blocks that you are performing the action upon. If you FIX on a DENSE dimension, you are not limiting the number of blocks, but rather just a portion within each block.

On the other hand, the IF statement is well suited to DENSE dimensions because it performs IF logic while the block is in memory.

Thanks in Advance