How to enable SSAS Usage-Based Optimization in SSAS



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.

Roopesh Babu V


  1. generic ed drugs [url=]prescription drugs canada buy online[/url] ed products

  2. Superb forum posts. With thanks!
    [url=]psychology thesis topics[/url] 6 1 discussion supporting a thesis statement [url=]thesis statement meaning[/url] master thesis help

  3. Thanks. An abundance of material.
    new vegas online casino [url=]live casino blackjack online[/url] casino online gambling

  4. Fantastic material, Kudos.
    [url=]do my homework for me free[/url] homework 123 [url=]someone to do my homework[/url] my homework

  5. Cheers. Numerous stuff!
    [url=]help me write my essay[/url] medical school application essay help [url=]paperhelp[/url] help essay writing

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

  7. viagra generico prezzo piГ№ basso [url=]viagra generico sandoz[/url] viagra 100 mg prezzo in farmacia

  8. Thanks a lot, Valuable information!
    [url=]essay writing service[/url] college application essay help [url=]essays help online[/url] help essay writing

  9. viagra generico recensioni [url=]cerco viagra a buon prezzo[/url] siti sicuri per comprare viagra online

  10. Nicely put. Thanks.
    [url=]custom essay help[/url] high school essay writing help [url=]essays writing help[/url] writing helperessay help

  11. cerco viagra a buon prezzo [url=]cerco viagra a buon prezzo[/url] alternativa al viagra senza ricetta in farmacia

  12. Good data. Many thanks.
    [url=]how to write an essay about my dream[/url] essay writers online [url=]someone to do my essay for me cheap[/url] essay writer helper

  13. Thanks a lot! Awesome information.
    [url=]best essay service[/url] professional essay writing services [url=]executive resume writing service[/url] trusted essay writing service

  14. Regards! Awesome information.
    [url=]professional paper writing service[/url] essay writing service uk [url=]best college essay writing service[/url] writing service essay

  15. You made your stand quite well..
    [url=]essay on service[/url] buy essay service [url=]custom dissertation writing service[/url] best college paper writing service

  16. Many thanks, Excellent information!
    [url=]the best essay writing service[/url] reliable essay writing service [url=]application essay writing service[/url] online essay writing

  17. Seriously a good deal of great info!
    [url=]phd dissertation help[/url] phd dissertation [url=]dissertation writing[/url] proquest dissertations

  18. With thanks, Ample advice.
    [url=]cheap essay help[/url] write my essay [url=]paperhelp[/url] paperhelp

  19. This is nicely put! !
    [url=]dissertation writing services reviews[/url] dissertation definition [url=]phd dissertation writing[/url] dissertation def

  20. Amazing posts. With thanks!
    [url=]professional paper writing service[/url] college paper writing service [url=]order custom paper[/url] paper help

  21. Reliable postings. Many thanks!
    [url=]cheap research paper writing service[/url] custom papers [url=]custom handwriting paper[/url] professional paper writing service

  22. Thanks. I enjoy this!
    [url=]phd dissertation help[/url] dissertation writers [url=]dissertation abstract[/url] dissertation data analysis help

  23. buy medicines online in india [url=]india online pharmacy[/url] indian pharmacy

  24. Thanks. Lots of information.
    [url=]xyz homework[/url] xyz homework [url=]should i do my homework[/url] do my homework for me

  25. canadian pharmacy sarasota [url=]canadian pharmacy[/url] legit canadian pharmacy

  26. Beneficial postings. With thanks!
    [url=]make an essay[/url] write my thesis for me [url=]writing essays for money[/url] write paper for me

  27. medication from mexico pharmacy [url=]mexican drugstore online[/url] mexican drugstore online

  28. You definitely made the point!
    [url=]buy a paper[/url] pay for papers [url=]professional paper writing service[/url] research paper writing service

  29. You actually suggested it well!
    [url=]essays for sale[/url] buy essays cheap [url=]pay for essay reviews[/url] pay for essay papers

  30. You said it nicely.!
    [url=]dissertation proposal[/url] writing dissertation [url=]dissertation writing[/url] dissertation uk

  31. You said it nicely.!
    [url=]help with writing an essay[/url] writing help [url=]cheap essay help[/url] essay typer

  32. Superb facts. With thanks.
    [url=]writing an analytical essay[/url] best essay writing website [url=]personal essay writing service[/url] online paper writing service

  33. With thanks, Loads of data!
    [url=]write paper for me[/url] do my essay for me [url=]write my research paper for me[/url] write my research paper for me

  34. Point effectively used!.
    [url=]help me write my essay[/url] help with essay writing [url=]help with my essay[/url] help with my essay

  35. You expressed it exceptionally well!
    [url=]tentative thesis[/url] thesis creator [url=]writing a thesis[/url] thesis statment

  36. canadian pharmacy cheap [url=]certified canadian international pharmacy[/url] online pharmacies in usa

  37. the best ed pill [url=]ed pills for sale[/url] cheap erectile dysfunction pills

  38. Point effectively considered.!
    [url=]custom paper[/url] pay for paper [url=]pay someone to write a paper[/url] pay someone to write a paper

  39. You actually mentioned it perfectly.
    [url=]do my programming homework[/url] hire someone to do my homework [url=]do my homework for money[/url] do my finance homework

  40. Amazing data. Thanks a lot.
    [url=]example thesis[/url] tentative thesis [url=]a thesis[/url] define thesis statement

  41. top 10 online pharmacy in india [url=]buy medicines online in india[/url] Online medicine order

  42. Incredible lots of excellent facts.
    [url=]write my paper for me[/url] essay writer website [url=]write this essay for me[/url] write my resume for me

  43. You actually mentioned it effectively!
    [url=]buy essay papers[/url] buy essay papers [url=]pay to write essay[/url] buy essays cheap

  44. Thank you. An abundance of advice!
    [url=]the college essay guy[/url] essays help [url=]writing helper[/url] paperhelp

  45. Awesome tips. Thanks!
    [url=]cover letter writing service[/url] online essay writing services [url=]which essay writing service is the best[/url] pro essay writing service

  46. Tips well applied.!
    [url=]write my essay[/url] free writing assistant [url=]best essay writing service[/url] cheap essay help

  47. Incredible lots of awesome tips!
    [url=]essay writers online[/url] write me an essay [url=]writing a persuasive essay[/url] help me write my essay

  48. Truly loads of helpful knowledge.
    [url=]dissertation abstract[/url] dissertations [url=]phd dissertation[/url] dissertation writing services

  49. You actually mentioned this effectively!
    [url=]cheap assignment writing service[/url] college essays writing [url=]cheap research paper writing service[/url] best essay writing website

  50. With thanks, Valuable information!
    [url=]cheap essay writing service[/url] essay service [url=]my essay service[/url] research paper writing service

  51. the canadian drugstore [url=]canada drug pharmacy[/url] reputable canadian online pharmacy

  52. cialis without a prescription [url=]Cialis without a doctor prescription[/url] cialis cost in nz

  53. i need cialis [url=]cheap cialis[/url] buy cialis online free shipping


Please enter your comment!
Please enter your name here

11 − 5 =