Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. A format-binding element is ignored in a multidimensional database in SQL Server

A format-binding element is ignored in a multidimensional database in SQL Server

Symptoms

In Microsoft SQL Server, a format-binding element is ignored in a multidimensional database. Therefore, the formatting is not applied when the dimension is processed.

↑ Back to the top

Cause

The use of Using a format-binding element in a multidimensional database is not supported.

↑ Back to the top

Workaround

To work around this issue, create a calculated column in a data source view, and then bind the name of the attribute to the calculated column.. For example, a dimension has a column of data type DateTime. The name of a member from that attribute is displayed as follows.

Note This value is displayed by using the default format.

2012-05-15 00:00:00.000
The following code sample shows how to change the format:

DATENAME(mm, [Ship Date]) + ' ' +DATENAME(dd, [Ship Date]) + ', ' + DATENAME(yy, [Ship Date]))
After the formatting is applied, the name of the member is displayed as follows:

May 15, 2012

↑ Back to the top

Keywords: kbsurveynew, kbprb, kbtshoot, kbentirenet, kb

↑ Back to the top

Article Info
Article ID : 2635199
Revision : 1
Created on : 1/7/2017
Published on : 5/26/2012
Exists online : False
Views : 206