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…

The correct answer is B. Format string. 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…

Creating and Managing Cubes

Question

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:

Options

AText List
BFormat string
CText data type of a measure
DTrigger
ENot possible in an ASO database

How the community answered

(20 responses)

A
10% (2)
B
85% (17)
E
5% (1)

Explanation

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 isMdxFormat(IIF(CellValue() < 0,"Negative","Positive"))

Topics

#ASO#format string#text display#variance

Community Discussion

No community discussion yet for this question.

Full 1Z0-531 Practice