There was a question on the Network54 recently about formatted values in Essbase 11, so I thought I would post a little info from 'under the covers' with formatted values and how they relate to Text Measures and Dates.
First, Essbase does support formatted values in Essbase 11. You can see in this screenshot from EAS, the format string is a property of the member.
The format string is in MDX format and there seems to be no valid examples in the docs of how to actually do a format. Thanks to the beauty of the internet and the hard work of Venkat at RittmanMead Consulting, I found an example on their blog. In the screenshot below, you will see the result of the formatted value:
Under the covers, there is a setting at the API level that determines if the formatted values are retrieved from the database. Uses of Smart View control this setting using the 'Format String' option in the Options dialog.
The same setting also governs whether Date and Text Measures are returned as either the formatted values or as numbers (which are what are stored in the database). Here is a screenshot of how the Java API returns formatted values with both the formatted values returned and the the formatted values not returned:
The value circled in yellow is a formatted value; note that the number below is the numeric value (which can also be returned in the same retrieve at the API level). The value circled in green is a Date measure; I don't think my date values are valid though. It seems limited that the earliest date supported is January 1, 1970 (and I think I used Excel dates to fill the cell which starts at January 1, 1900.
The values circled in red and blue are Text Measures. Text Measures get their values from Smart Lists. Here is the EAS editor showing my simple Smart List:
OK, so it says 'Text Lists' in the dialog, but if you look at the API level, you see Smart Lists:
Now you probably know more about Formatted Values, Text and Date Measures than you ever cared to know.
We all need to thank Applied OLAP
1 day ago