## Tuesday, September 29, 2015

### Named Calculation SSAS

A named calculation is a SQL expression represented as a calculated column. This expression appears and behaves as a column in the table. A named calculation lets you extend the relational schema of existing tables or views in a data source view without modifying the tables or views in the underlying data source. Consider the following examples:
•    Create a single named calculation that is derived from multiple columns in a fact table (for example, creating Tax Amount by multiplying a tax rate by a sales price).
•    Construct a user friendly name for a dimension member.
•    As a query performance enhancement, create a named calculation in the DSV instead of creating a calculated member in a cube. Named calculations are calculated during processing whereas calculated members are calculated at query tim
{"ft_lang_label":"__label__en","ft_lang_prob":0.9436345,"math_prob":0.96301275,"size":1295,"snap":"2021-43-2021-49","text_gpt3_token_len":235,"char_repetition_ratio":0.17583269,"word_repetition_ratio":0.6857143,"special_character_ratio":0.18378378,"punctuation_ratio":0.06726457,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.99226546,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-10-23T18:38:14Z\",\"WARC-Record-ID\":\"<urn:uuid:1147857e-df4d-47a6-a563-bd231c775b40>\",\"Content-Length\":\"35975\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:cda3eca2-f54e-46ff-82ba-7774b4ebb819>\",\"WARC-Concurrent-To\":\"<urn:uuid:6f50a93d-5c7a-492d-b2ae-7b7f25c42b2e>\",\"WARC-IP-Address\":\"142.251.45.115\",\"WARC-Target-URI\":\"https://www.sqlserverquest.com/2015/09/named-calculation-ssas.html\",\"WARC-Payload-Digest\":\"sha1:3GIQ7VI7MW34KMYJ5EZ6CS6MVQSU2YEP\",\"WARC-Block-Digest\":\"sha1:XJ5DPWMLO4PMVJQZKKTME72OL7FNDQ3C\",\"WARC-Identified-Payload-Type\":\"application/xhtml+xml\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-43/CC-MAIN-2021-43_segments_1634323585737.45_warc_CC-MAIN-20211023162040-20211023192040-00146.warc.gz\"}"}