Database Reference
In-Depth Information
Tip
Analysis Services does not use the SQL data types. For more information
about the data types used by Analysis Services, refer to the following link:
For more information about how data types affect the behavior of Analys-
is Services, please refer to the following page:
10. Change the format to be of type
"#,##0;-#,##0"
(include the quotes in the
format string). This format string does not exist but is a custom format string
that you just created. It changes the behavior of some clients to include a
thousand separator of, (comma). If you connect to the cube through Excel,
you will see the changed behavior but not through the cube browser in SQL
Server Data Tools as this does not honor the format string.
11. Right-click on the
Sales Amount
measure and choose
Properties
. Change
FormatString
to
"Currency"
. This changes the behavior of the
Sales
Amount
measure to use the client settings of the Currency data type as the
formatting.
Tip
For more information about the different formatting options please refer
to the following page:
Now you have the first cube created with one single dimension. However, if you
examine
Dimensions
you can see that the
Date
dimension is actually used three
times.
Search WWH ::
Custom Search