How to enable SSAS Usage-Based Optimization in SSAS

By
roopesh.valluru
-
135
15463

Friends,

Usage-Based Optimization is a fantastic feature in SSAS to improve the most frequently used MDX queries of any cube database. This feature is used to design aggregations based on actual user queries using Business Intelligence Development Studio. But when ever you try to design Usage-Based Optimization you might have seen all the options disabled. Why is it so and how to enable it ? For the answers to these questions, continue reading the post.

This uses the technique of creating aggregations on FREQUENTLY USED queries in the given time interval. Options in Usage-Based Optimization wizard will be disabled because the queries executed on the CUBE database will not be stored anywhere by default and you c an see the same in below given pic.

 

When there is no queries stored then this concept fails and hence all the options will be disabled. We can change the settings in order to enable the STORAGE of queries that are executing on cube and hence we can enable the options in Usage-Based Optimization wizard. PFB the steps involved in enabling the storage of queries.

  • Connect to SSAS using SSMS (Sql Server Management Studio).
  • Right click on the server and select properties as shown below.

  • set CreateQueryLogTable to true.
  • Set the value of QueryLogConnectionString to any database where you wish to store your queries.
  • Set the value of QueryLogSampling to the appropriate value for your environment (the default value of 10 means every 10th query will be logged). The lower the value of this property, the higher the overhead of query logging will be on the system.
  • Set the value of QueryLogTableName property to any TABLE NAME of your wish. 
  • Click OK.

 

Everything set and now try to execute some queries on the cube and check the table(given in the above steps) in the database(mentioned in the above steps). It should contain the queries you executed on the cube database.

Once the queries started logging, we are all set to configure Usage-Based Optimization for the queries. In the below pic you can see all the options are enabled.

These are the pre requisites to configure Usage-Based Optimization and check the next post to see the steps involved in configuring the same.

Thanks,
Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

135 COMMENTS

  4. generic ed drugs [url=http://cheapdr.top/#]prescription drugs canada buy online[/url] ed products

  5. Superb forum posts. With thanks!
    [url=https://argumentativethesis.com/]psychology thesis topics[/url] 6 1 discussion supporting a thesis statement [url=https://bestmasterthesiswritingservice.com/]thesis statement meaning[/url] master thesis help

  8. Thanks. An abundance of material.
    new vegas online casino [url=https://bestonlinecasinoreal.us/]live casino blackjack online[/url] casino online gambling

  18. Fantastic material, Kudos.
    [url=https://domyhomeworkformecheap.com/]do my homework for me free[/url] homework 123 [url=https://domycollegehomeworkforme.com/]someone to do my homework[/url] my homework

  19. Cheers. Numerous stuff!
    [url=https://essaytyperhelp.com/]help me write my essay[/url] medical school application essay help [url=https://helptowriteanessay.com/]paperhelp[/url] help essay writing

  20. Truly all kinds of awesome data.
    [url=https://theessayswriters.com/]what i would like to do for my country essay[/url] what should i do my persuasive essay on [url=https://bestcheapessaywriters.com/]what website writes essays for you[/url] essay writing for hire

  21. viagra generico prezzo piГ№ basso [url=https://viasenzaricetta.com/#]viagra generico sandoz[/url] viagra 100 mg prezzo in farmacia

  23. Thanks a lot, Valuable information!
    [url=https://englishessayhelp.com/]essay writing service[/url] college application essay help [url=https://essaywritinghelperonline.com/]essays help online[/url] help essay writing

  24. viagra generico recensioni [url=https://viasenzaricetta.com/#]cerco viagra a buon prezzo[/url] siti sicuri per comprare viagra online

  25. Nicely put. Thanks.
    [url=https://essaytyperhelp.com/]custom essay help[/url] high school essay writing help [url=https://helptowriteanessay.com/]essays writing help[/url] writing helperessay help

  27. cerco viagra a buon prezzo [url=https://viasenzaricetta.com/#]cerco viagra a buon prezzo[/url] alternativa al viagra senza ricetta in farmacia

  28. Good data. Many thanks.
    [url=https://hireawriterforanessay.com/]how to write an essay about my dream[/url] essay writers online [url=https://theessayswriters.com/]someone to do my essay for me cheap[/url] essay writer helper

  29. Thanks a lot! Awesome information.
    [url=https://writinganessaycollegeservice.com/]best essay service[/url] professional essay writing services [url=https://essayservicehelp.com/]executive resume writing service[/url] trusted essay writing service

  30. Regards! Awesome information.
    [url=https://writinganessaycollegeservice.com/]professional paper writing service[/url] essay writing service uk [url=https://essayservicehelp.com/]best college essay writing service[/url] writing service essay

  31. You made your stand quite well..
    [url=https://writinganessaycollegeservice.com/]essay on service[/url] buy essay service [url=https://essayservicehelp.com/]custom dissertation writing service[/url] best college paper writing service

  32. Many thanks, Excellent information!
    [url=https://essaywritingservicelinked.com/]the best essay writing service[/url] reliable essay writing service [url=https://essaywritingservicetop.com/]application essay writing service[/url] online essay writing

  33. Seriously a good deal of great info!
    [url=https://phdthesisdissertation.com/]phd dissertation help[/url] phd dissertation [url=https://writeadissertation.com/]dissertation writing[/url] proquest dissertations

  34. With thanks, Ample advice.
    [url=https://essaytyperhelp.com/]cheap essay help[/url] write my essay [url=https://helptowriteanessay.com/]paperhelp[/url] paperhelp

  36. This is nicely put! !
    [url=https://phdthesisdissertation.com/]dissertation writing services reviews[/url] dissertation definition [url=https://writeadissertation.com/]phd dissertation writing[/url] dissertation def

  37. Amazing posts. With thanks!
    [url=https://bestpaperwritingservice.com/]professional paper writing service[/url] college paper writing service [url=https://bestonlinepaperwritingservices.com/]order custom paper[/url] paper help

  38. Reliable postings. Many thanks!
    [url=https://service-essay.com/]cheap research paper writing service[/url] custom papers [url=https://custompaperwritingservices.com/]custom handwriting paper[/url] professional paper writing service

  40. Thanks. I enjoy this!
    [url=https://phdthesisdissertation.com/]phd dissertation help[/url] dissertation writers [url=https://writeadissertation.com/]dissertation abstract[/url] dissertation data analysis help

  41. buy medicines online in india [url=https://indiapharm.pro/#]india online pharmacy[/url] indian pharmacy

  43. Thanks. Lots of information.
    [url=https://homeworkcourseworkhelps.com/]xyz homework[/url] xyz homework [url=https://helpmedomyxyzhomework.com/]should i do my homework[/url] do my homework for me

  46. canadian pharmacy sarasota [url=https://canadapharm.pro/#]canadian pharmacy[/url] legit canadian pharmacy

  47. Beneficial postings. With thanks!
    [url=https://hireawriterforanessay.com/]make an essay[/url] write my thesis for me [url=https://theessayswriters.com/]writing essays for money[/url] write paper for me

  49. medication from mexico pharmacy [url=https://mexicopharm.pro/#]mexican drugstore online[/url] mexican drugstore online

  52. You definitely made the point!
    [url=https://bestpaperwritingservice.com/]buy a paper[/url] pay for papers [url=https://bestonlinepaperwritingservices.com/]professional paper writing service[/url] research paper writing service

  57. You actually suggested it well!
    [url=https://payforanessaysonline.com/]essays for sale[/url] buy essays cheap [url=https://buycheapessaysonline.com/]pay for essay reviews[/url] pay for essay papers

  59. You said it nicely.!
    [url=https://dissertationwritingtops.com/]dissertation proposal[/url] writing dissertation [url=https://helpwritingdissertation.com/]dissertation writing[/url] dissertation uk

  61. You said it nicely.!
    [url=https://essaytyperhelp.com/]help with writing an essay[/url] writing help [url=https://helptowriteanessay.com/]cheap essay help[/url] essay typer

  66. Superb facts. With thanks.
    [url=https://writinganessaycollegeservice.com/]writing an analytical essay[/url] best essay writing website [url=https://essayservicehelp.com/]personal essay writing service[/url] online paper writing service

  72. With thanks, Loads of data!
    [url=https://hireawriterforanessay.com/]write paper for me[/url] do my essay for me [url=https://theessayswriters.com/]write my research paper for me[/url] write my research paper for me

  75. Point effectively used!.
    [url=https://essaytyperhelp.com/]help me write my essay[/url] help with essay writing [url=https://helptowriteanessay.com/]help with my essay[/url] help with my essay

  78. You expressed it exceptionally well!
    [url=https://argumentativethesis.com/]tentative thesis[/url] thesis creator [url=https://bestmasterthesiswritingservice.com/]writing a thesis[/url] thesis statment

  82. canadian pharmacy cheap [url=https://pillswithoutprescription.pro/#]certified canadian international pharmacy[/url] online pharmacies in usa

  86. the best ed pill [url=https://edpills.pro/#]ed pills for sale[/url] cheap erectile dysfunction pills

  88. Point effectively considered.!
    [url=https://bestpaperwritingservice.com/]custom paper[/url] pay for paper [url=https://bestonlinepaperwritingservices.com/]pay someone to write a paper[/url] pay someone to write a paper

  90. You actually mentioned it perfectly.
    [url=https://homeworkcourseworkhelps.com/]do my programming homework[/url] hire someone to do my homework [url=https://helpmedomyxyzhomework.com/]do my homework for money[/url] do my finance homework

  93. Amazing data. Thanks a lot.
    [url=https://argumentativethesis.com/]example thesis[/url] tentative thesis [url=https://bestmasterthesiswritingservice.com/]a thesis[/url] define thesis statement

  100. top 10 online pharmacy in india [url=https://indianpharmacy.pro/#]buy medicines online in india[/url] Online medicine order

  101. Incredible lots of excellent facts.
    [url=https://hireawriterforanessay.com/]write my paper for me[/url] essay writer website [url=https://theessayswriters.com/]write this essay for me[/url] write my resume for me

  102. You actually mentioned it effectively!
    [url=https://quality-essays.com/]buy essay papers[/url] buy essay papers [url=https://buyanessayscheaponline.com/]pay to write essay[/url] buy essays cheap

  103. Thank you. An abundance of advice!
    [url=https://essaytyperhelp.com/]the college essay guy[/url] essays help [url=https://helptowriteanessay.com/]writing helper[/url] paperhelp

  104. Awesome tips. Thanks!
    [url=https://essaywritingservicehelp.com/]cover letter writing service[/url] online essay writing services [url=https://essaywritingservicebbc.com/]which essay writing service is the best[/url] pro essay writing service

  107. Tips well applied.!
    [url=https://essaytyperhelp.com/]write my essay[/url] free writing assistant [url=https://helptowriteanessay.com/]best essay writing service[/url] cheap essay help

  108. Incredible lots of awesome tips!
    [url=https://hireawriterforanessay.com/]essay writers online[/url] write me an essay [url=https://theessayswriters.com/]writing a persuasive essay[/url] help me write my essay

  117. Truly loads of helpful knowledge.
    [url=https://helpwithdissertationwriting.com/]dissertation abstract[/url] dissertations [url=https://dissertationwritingtops.com/]phd dissertation[/url] dissertation writing services

  122. You actually mentioned this effectively!
    [url=https://essaywritingservicelinked.com/]cheap assignment writing service[/url] college essays writing [url=https://essaywritingservicetop.com/]cheap research paper writing service[/url] best essay writing website

  124. With thanks, Valuable information!
    [url=https://essaywritingservicelinked.com/]cheap essay writing service[/url] essay service [url=https://essaywritingservicetop.com/]my essay service[/url] research paper writing service

  125. the canadian drugstore [url=http://canadiandrugs.pro/#]canada drug pharmacy[/url] reputable canadian online pharmacy

  128. cialis without a prescription [url=https://cialiswithoutprescription.pro/#]Cialis without a doctor prescription[/url] cialis cost in nz

  135. i need cialis [url=http://cialiswithoutprescription.pro/#]cheap cialis[/url] buy cialis online free shipping

LEAVE A REPLY

Please enter your comment!
Please enter your name here

11 − 5 =