ExpertConnect - Mentoring & Discussions

You can join mentoring & discussions for Free Ask Question, Give Answer, Discuss IT Problems, Learn, and Grow

2017-10-20 14:26:02 5

SQL Server Analysis Services

Topic menu

2018-06-08 20:29:55 1
Profile picture of Clinton  Alvares
Posted: Jun 8, 2018

What is the use of property named non empty behavior when creating a new calculated member in a cube ?

Comment (1) ·  Like (2)
Profile picture of Sajid Ajmal

Sajid Ajmal Jun 8, 2018

For Ratio calculations, Non empty behavior is an important property. If the denominator is empty, the DMX expression will return an error just as it would if the denominator is equal to zero. By selecting one or more measures for the Non-Empty Behavior property, we are establishing a requirement that each selected measure first be evaluated before the calculation expression is evaluated. If each selected measure is empty, then The expression is also treated as empty and no error is returned.

Like

Write a new comment...
Ready to post? select an option: