New Named Calculation in SSAS DSV

198
16367
New Named Calculation
New Named Calculation

Friends,

Named calculations are Virtual columns that can be added on tables in Data Source View(DSV). This named calculation acts as a Column in your table and this column won’t be reflected in your database. If you wish to extend the relational schema of a table or a view without modifying the underlying data source table or view then New Named Calculation is the correct option. One more and main advantage of “Named Calculation” is that these are calculated at the time of PROCESSING but not at QUERY Time and hence the performance will be good. The Named Calculation consists of the following things.

1) Name – Name of the Virtual Column

2) Description – Description about the Virtual Column(Optional).

3) Expression – Valid SQL Expression.

You can use one or more columns to define the expression for Named Calculation. For example to get full name as a new virtual column we have to use the below expression.

Title+’ ‘+FirstName+’ ‘+MiddleName+’ ‘+LastName

The above expression is using four columns to define Full Name Virtual column. PFB the steps to be followed to create the named calculation.

1. Right-click the table and select Create a named calculation.
2. Enter the calculation name as “Full Name” and enter a description.
3. Enter the following expression:

Title+’ ‘+FirstName+’ ‘+MiddleName+’ ‘+LastName

New Named Calculation
New Named Calculation

4. Once the OK button is clicked it will show if there are any errors in syntax. If there are no errors then you can see new Virtual column named “Full Name” with an icon “CALCULATOR” next to it as shown in below screenshot.

5. If you wish to test whether you are getting data as expected or not then you can you “EXPLORE DATA” option as shown in the below screenshot.

New Named Calculation
New Named Calculation

This is how you can use calculations. If you use the same expression which is given above to concatenate columns then you may not get desired result if we have NULLs in data. For example if Last Name is NULL for a column the <Some Value> + NULL is treated as NULL by SQL and hence we have to handle NULLs in expressions when we are working with String data. PFB the updated query which handle NULLs.

isnull(Title,”)+’ ‘+isnull(FirstName,”)+’ ‘+isnull(MiddleName,”)+’ ‘+isnull(LastName,”)

In the above expression I am checking whether the value is NULL or not and if it is NULL then I am replacing it with ‘BLANK Value.

Note – It is not mandatory that you have to use at least one column from table to create an Expression. The following are also Valid Expressions.

1) getdate()

2) 1 or any integer

3) ‘Dumy’ or any string

In short any valid SQL expression can be given as Named Calculation Expression.

That’s it and Happy Coding !

Regards,

Roopesh Babu V

 

198 COMMENTS

  1. dissertation editing help
    [url=”https://bestdissertationwritingservice.net”]help writing a dissertation[/url]
    help dissertation dissertation help

  2. dissertation write
    [url=”https://bestdissertationwritingservice.net”]dissertation assistance[/url]
    how to write a dissertation proposal

  3. best dissertation writing service
    [url=”https://customdissertationwritinghelp.com”]write a dissertation abstract[/url]
    writing a proposal for your dissertation

  4. phd dissertation help
    [url=”https://helpwithdissertationwritinglondon.com”]doctoral dissertation writing help[/url]
    doctoral dissertation help your

  5. proposal and dissertation help geography
    [url=”https://writingadissertationproposal.com”]dissertation vs thesis[/url]
    dissertation editing

  6. indy gay dating free
    [url=”https://gay-singles-dating.com”]busted for using someone’s photo in a gay dating website[/url]
    adam4adam gay dating hook up site

  7. Little is known about when, if ever, Dapoxetine will be available in the US cheap generic cialis Increase the dose to 40 mg once daily based upon individual tolerability see DOSAGE AND ADMINISTRATION , WARNINGS AND PRECAUTIONS and CLINICAL PHARMACOLOGY

  8. Mo Qingfeng thought about does cialis cure erectile dysfunction Shop Vitamins And Supplements the ordinary people in those stories who need to spend money to buy things, and now trimix cure my erectile dysfunction they I does cialis cure erectile dysfunction became a great practitioner, but I also need to spend money to buy does cialis cure erectile dysfunction things, so does cialis cure erectile dysfunction I nodded п»їcialis imatinib will increase the level or effect of tadalafil by affecting hepatic intestinal enzyme CYP3A4 metabolism

  9. I just had my second round of clomid 50 with my first ovidrel trigger and IUI. clomiphene goodrx coupon David alluded to this a little bit earlier, that if you look at the literature and you look at the registries, you would have to be a blooming idiot to not understand that Day 5 is far superior.

  10. You actually suggested this superbly!
    college application essay length [url=https://service-essay.com]https://service-essay.com/[/url] cheap dissertation writing services

  11. The investigators found, for example, increased androstenedione levels in all cases of adrenocortical carcinoma, while all ovarian hyperthecosis cases showed increased testosterone. what does clomid do 5 Low dose finasteride Propecia used in the treatment of male pattern hair loss.

  12. Incredible a good deal of terrific information!
    viagra online canadian pharmacy [url=https://canadianpharmacyonlinedb.com]cialis online[/url] prescription drugs canada

  13. With thanks! A good amount of information.
    writing an essay for college admission [url=https://quality-essays.com]how to improve essay writing[/url] assignment writer

  14. Eye creams are heavier creams, agreed. Because they’re in such close proximity to such a gentle, delicate area as your under eyes, most eye creams feel greasy. I’ve tried a few but have never been impressed. My eyes are also pretty sensitive and the heavy fragrances often make them water. What order you apply it in will depend on its consistency. Always start with clean skin and add on skincare from lightest to heaviest. Retinol serums tend to have a lightweight feel, so they should be applied before your moisturizer, while retinol creams can be applied after your serum or also on bare, dry skin. I have reported it to the BBB because deleting unsatisfactory reviews and only displaying the good ones in an attempt to sell their products is extremely unethical since most people, like me, rely on reviews to help them decide whether to buy or not. In my opinion, it’s a complete SCAM! http://sc.sie.gov.hk/TuniS/deepandnaturalbeauty.com/ When it comes to achieving your glass skin goals, it’s not a ‘one approach to suit all’ kinda-thing. It has to be tailored to you and your skin type, with the products that are best suited to your needs. A post shared by Glass Skin (@glassskin.india) on Apr 21, 2019 at 4:14am PDT Free shipping for prepaid orders. Flat ₹60 will be charged on all COD orders.  Subscribe to receive updates, access to exclusive deals, and more. (504) 581 8356 When it comes to achieving your glass skin goals, it’s not a ‘one approach to suit all’ kinda-thing. It has to be tailored to you and your skin type, with the products that are best suited to your needs. Free shipping for prepaid orders. Flat ₹60 will be charged on all COD orders.  Business Hours

  15. Very good facts. Thank you.
    international pharmacies that ship to the usa [url=https://canadianonlinepharmacybase.com]online pharmacies canada[/url] cheap viagra online canadian pharmacy

  16. Incredible a good deal of helpful facts!
    visit poster’s website [url=https://canadianpharmacylist.com]on line pharmacy[/url] buy prescription drugs without doctor

  17. The PCR were carried out using the following primers d2EYFP forward 5 acgacggcactcaagacc- 3; d2EYFP reverse 5 gtcctccttgaagtcgatgc- 3; PFL tTA forward 5 aaagcagctgaagtgcgagag- 3; PFL tTA reverse 5 gatggtgctgccgtagttgtt- 3; NO PFL tTA forward 5 acagcgcattagagctgctt- 3; NO PFL tTA reverse 5 acctagcttctgggcgagtt- 3. doxycycline 100mg acne Analgesics and anti- inflammatory drugs may relieve pain and swelling regardless of its source.

  18. You’ve made your point.
    international pharmacies that ship to the usa [url=https://canadarx-drugservices.com]pharmeasy[/url] prescription without a doctor’s prescription

  19. YOLOdice has a simple interface that delivers Bitcoin dice in an easy to understand yet engaging form. Whether you are a new player or an experienced bettor, the game provides you exactly what you are looking for. It also offers its support via live chat and a BitcoinTalk thread for easy accessibility. A few important notes about buying Bitcoin: While Bitcoin is expensive, you can purchase fractional Bitcoin from some vendors. You’ll also need to look out for fees, which are generally small percentages of your crypto transaction amount but can add up on small-dollar purchases. Finally, Bitcoin purchases are not instantaneous like many other equity purchases. Because miners must verify Bitcoin transactions, it may take you at least 10 to 20 minutes to see your Bitcoin purchase in your account. https://freefirsttest.com/home/community/profile/jeanette4065200/ Online real-money blackjack variants are designed in such a way so as to enhance the user’s experience even if they are still new to the game. Many online variations would offer hints on correct play and would display warning messages. For example, if you accidentally hit your hand with a two-card total of 19, the software would ask you whether you indeed want to make this move because there is a good chance for you to bust on the next draw. While states have the power to permit or prohibit commercial brick and mortar blackjack, as well as, state-regulated online casino gambling within their state lines, there remains no federal law that prevents US residents from accessing legally sanctioned, licensed, and regulated offshore online gambling portals. Unless a state passes specific laws to prohibit online gambling, such as Washington, then Americans can freely enjoy offshore casinos, poker sites, and sportsbooks.

  20. You actually suggested this wonderfully!
    buying prescription drugs canada [url=https://canadapharmacies-24h.com]canadian online pharmacies[/url] canadian prescriptions online

  21. Seriously a lot of wonderful advice.
    how to write a 2 paragraph essay [url=https://ouressays.com]how to write a case study essay[/url] custom dissertation writing

  22. You suggested this effectively!
    canadian king pharmacy [url=https://canadianpharmacies-24h.com]discount pharmaceuticals[/url] ordering prescriptions from canada legally

  23. Wow a good deal of awesome facts.
    admission essay writing [url=https://homeworkcourseworkhelps.com]how to write an argumentative essay[/url] writing homework help

  24. Whoa many of wonderful information!
    canadian pharmacies-24h [url=https://canadianpharmacylist.com]best canadian prescription prices[/url] ordering prescriptions from canada legally

  25. Incredible all kinds of fantastic material.
    how to write an descriptive essay [url=https://theessayswriters.com]best college essay service[/url] website copywriting services

LEAVE A REPLY

Please enter your comment!
Please enter your name here

− 3 = 5