Valid 1Z0-531 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-531 Exam! ExamDiscuss.com now offer the newest 1Z0-531 exam dumps, the ExamDiscuss.com 1Z0-531 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-531 dumps with Test Engine here:
You need to display a text value based on variance data in an ASO database. If the variance percentage is less than 10, users should see "Low Priority," if the variance percentage is between 11 and 25, users should see "Medium Priority," and if the variance percentage is greater than 25, users should see High Priority." The Essbase feature that supports this capability is:
Correct Answer: B
Explanation/Reference: Using format strings, you can format the values (cell contents) of Essbase database members in numeric type measures so that they appear, for query purposes, as text, dates, or other types of predefined values. The resultant display value is the cell's formatted value (FORMATTED_VALUE property in MDX). The underlying real value is numeric, and this value is unaffected by the associated formatted value. Format strings enable you to display more meaningful values in place of raw numeric values. For example, using a text based formatted value, you might display data cells as "High," "Medium," and "Low." To use a format string you just have enable types measures on your outline, then in the member properties for "Associate format string" use the syntax :- MdxFormat ( string_value_expression ) A simple example is MdxFormat( IIF(CellValue() < 0,"Negative","Positive") ) Incorrect answers: A text list In Essbase is an object that stores text values mapped to numeric identifiers. Text Lists enable the use of text measures.
