ISMISSING (value)

Description:

This function returns true if the value that is checked in the function is of type "MISSING". This function is designed specifically to allow you to check if a particular value that is passed as parameter to the function is a value of type missing. The result of the function is displayed as a Boolean value. If the value that is specified in the function, is of type missing then the function returns "True" or else the function returns the value which equals "False". A value can be made into type "Missing" by using the MISSING function as explained under the topic for that function. The function takes as a parameter the value that is being checked for being of type "MISSING". This function takes just one parameter and it checks if the value that was passed to it is of type "Missing" or not.

Syntax: IsMissing (Value)

• Value : Enter any value that belongs to a database, and which is the value which you want to check for being of type "Missing".

Remarks

• The value can be a hard coded value or it can be a range which is referenced.
• The value may / may not exist in the database.
• The value can be already assigned to be a MISSING value.
• This argument is compulsory.

Example

=IsMissing ("range for a value")	-returns true if the value given to the formula is a value of type MISSING. (Value returned is: true / false)
=IsMissing ("Value")	-returns true if the value given to the formula is a value of type MISSING. (Value returned is: true / false)

Let us take the example of a cube in PowerOLAP which requires data that is the Boolean value for whether or not a value given as a parameter to the function is of type "MISSING" or not. If in the same dimension in another member or in another dimension in another cube, you want to display this accessed Boolean value for the parameter supplied to the function then it is appropriate to use the ISMISSING function to access this value. In this case we can write a formula in the cube in PowerOLAP to access this value to check for a value being MISSING or not. With this function one can write the Boolean value returned to another member that is supposed to hold this value as fact data or you can also write this value to a different dimension or a different member in a different cube.



The screen above shows a formula for the ISMISSING function.

The formula writes a value into the "MetaDataValues" dimension, into the "IsMissing" member. In the formula, the ISMISSING function takes just one parameter, which is the value that you wish to check for being "MISSING". If the value is of type Missing, meaning, if it has been assigned the MISSING tag by use of the MISSING function, then the function would return a value which equals "True" or else it returns "False". The formula accesses the value that is contained in the member "Missing" which belongs to the dimension MetaDataValues. The function above accesses this member and in the example above, the function returns "True" because the value given as a parameter to the function is indeed of type "MISSING".

In the example above, the first formula created tags all intersections of the member MathValues from the Version dimension and the member "MetaDataMeasure" from the "AP_TRans_Measure" dimension be equal to missing.

The second formula uses the ISMISSING function. In the given example, this second formula should return a value of TRUE into the "MetaDataValues" dimension, specifically into the "IsMissing" member, and in the "Check" member of the Version dimension.