How to enable SSAS Usage-Based Optimization in SSAS

By
roopesh.valluru
-
394
37829

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

394 COMMENTS

  87. Our Suitcase sets are designed to “nest” comfortably inside each other so you can own that beautiful set of matching luggage without any storage hassles Hard plastic is durable and easy to clean Choosing the best makeup case depends really on a few things: (a) How much makeup you have, (2) where you’re going, and (3) what you’re hoping to store, which brings us to… We’ve successfully received your request. 100% Italian design, 100% made in Cambodia. Why We Love It: Available in 13 different styles and four sizes, this case also boasts numerous compartments making it a “variety is the spice of life”-type of traveler’s ideal choice. The robust shape and size fits perfectly into a car for one-week getaways closer to home. Interested by this product?
    http://linkcentre.com/profile/elandeni1985
    Fluffy brush delivers volume Fluffy brush delivers volume Worked at Sephora for many years and still swear by and exclusively use Covergirl Lash Blast (orange tube) (and Benefit Rollerlash, but that is a bit more pricey). Waterproof Lash Blast in brown is the jam to my jelly рџЌЇрџђќ Especially if you have straight and stubborn lashes that won’t normally hold a curl! For an even thinner brush option, Innisfree’s Skinny Waterproof Microcara Mascara is one of Shackleton’s favorites. She says it has “the price of a drugstore mascara with the pack of a professional brand,” thanks to its super-fine brush. “Without a doubt, this one stands out for getting even the tiniest lashes noticed,” she adds. Finding a mascara that doesn’t smudge doesn’t have to be expensive. There are cheap drugstore mascara products that do just as good a job in the heat and humidity. Plus, they won’t fail to give you length and definition. Whenever I look for a mascara, I make sure it does three main things: It makes my lashes look full, it doesn’t dry up or clump, and it has to be smudge proof.

  88. A primeira versão do bingo surgiu em 1530, na Itália. Na época, os membros dos conselhos políticos de Gênova eram decididos através de sorteio. A mecânica era muito simples. Os nomes dos candidatos eram inseridos em bolinhas que, em seguida, seriam retiradas aleatoriamente de uma urna. Soa familiar? Ainda no século XVI, esse sistema passou a fazer bastante sucesso. Tanto que, não muito tempo depois, foi criada uma loteria semanal com a mesma mecânica. A Lo Gioco Del Lotto D’Itália, como foi chamada, pode ser considerada a primeira utilização lúdica desse método de sorteio. E, dessa forma, a mãe do bingo. Nota do consumidor Jogar ao bingo online da Playspace é muito simples e divertido. A primeira coisa que deve fazer é escolher a sala de que gosta mais (Madrid, Barcelona, México, Rio de Janeiro, etc.), em cada uma das quais a quantidade de cartões e apostas é diferente. De seguida, deverá comprar os cartões que desejar e, a partir daqui, pôr-se confortável e desfrutar da partida.
    http://malpkellsofal1973.cavandoragh.org/clique
    Estas promoções podem ser de carácter temporário ou definitivo, estando estas últimas associadas a dias da semana, por exemplo, nos quais é possível obter saldo extra a jogar em determinadas slots. Já nas promoções temporárias inserem-se, entre outros, os torneios de slots (ou de outros jogos como roletas e blackjack), que geralmente funcionam à base de acumulação de pontos para subir numa tabela de prémios e ganhar bónus mais competitivos no final do torneio. Se você é um apostador obstinado que quer jogar e ganhar ainda mais, 20 rodadas grátis podem ser pouco para você. Nesse caso, vai ficar feliz em saber que o National Casino possui muitos outros bônus. Um dos mais famosos é o seu Bônus de Boas-vindas de 100% e 100 rodadas grátis. Para coletar esse bônus, basta criar uma conta e fazer um depósito mínimo de R$ 80. Como o valor máximo desse bônus de depósito é R$ 600, os jogadores vão poder curtir o National Casino por muito tempo com esse bônus. Isso sem falar das 100 rodadas grátis, que também podem render grandes ganhos.

  176. Aviator to autentyczna i oferowana przez licencjonowane kasyna online gra typu crash, co sprawdziliśmy w wielu źródłach. пояснения Официальный сайт Vavada Wspօminаliśmу już, żе Plinkօ mа sеtki wеrsji, а większօść z niсh mօżnа zօbасzуć i zаgrаć nа 1Win. Niе tуlkօ strօnу hаzаrdօwе օnlinе są bаrdzօ zаintеrеsօwаnе tą grą, аlе tаkżе twórсу giеr stwօrzуli օdmiаnу inspirօwаnе Plinkօ. Mօżеsz nаpօtkаć różnе tуtułу Plinkօ pօdсzаs օdkrуwаniа pօrtfօliօ giеr 1Win. Sprаwdź niеktórе z niсh, сzуtаjąс kօlеjnе sеkсjе. 1Win Loyalty Program is good program for players. 1wincoin is a thank you from online casinos for loyal customers. Join the casino and receive 1win coins as a reward. 1win coins are awarded for betting on games in the casino section and for betting on sports according to your account currency.
    https://cct.opencitieslab.org/user/acnonrabar1984
    Mostbet umożliwia szybkie i bezpieczne transakcje finansowe. | Mostbet oferuje transmisje na żywo z wybranych wydarzeń sportowych. | Mostbet oferuje gry od renomowanych dostawców oprogramowania. | Dołącz do społeczności graczy Mostbet i dziel się doświadczeniami. mostbet-online-casino-polska เว็บไซต์ให้บริการเกมสล็อตทรูวอเลท goodbet711 สล็อตด้วยมาตรฐานการบริการที่ดีที่สุด Mostbet umożliwia szybkie i bezpieczne transakcje finansowe. | Mostbet oferuje transmisje na żywo z wybranych wydarzeń sportowych. | Mostbet oferuje gry od renomowanych dostawców oprogramowania. | Dołącz do społeczności graczy Mostbet i dziel się doświadczeniami. mostbet-online-casino-polska

  272. Un calido saludo a todos los aventureros de la suerte !
    El catГЎlogo de casinos internacionales online incluye tragamonedas modernas y juegos de mesa clГЎsicos. [url=http://casinosinternacionalesonline.guru/][/url]. Muchos consideran a casinos internacionales online como la puerta de entrada al entretenimiento global. Cada vez mГЎs usuarios se registran en casinos internacionales online gracias a sus promociones constantes.
    Cada vez mГЎs usuarios se registran en casino online internacional gracias a sus promociones constantes. Muchos jugadores prefieren casino online internacional por sus bonos exclusivos y variedad de juegos. La reputaciГіn de casino online internacional crece por su transparencia y su innovaciГіn en apuestas.
    Descubre los mejores mejores casinos internacionales confiables – http://casinosinternacionalesonline.guru/
    ?Que tengas la fortuna de disfrutar de increibles botes acumulados!
    п»їcasinos internacionales online

  327. If you would like to proceed with this bulk order, our team will contact you within one business day regarding product availability, expected delivery date, and any applicable delivery charges. You will only be invoiced based on the actual quantities delivered. FREE DELIVERY for orders $59 and above Shopping at Aldi SHOP&GO is easy! Fruit Shop Frenzy sits on the border between medium and high Volatility. You should expect a slightly bumpy ride but nothing like the rollercoaster of a pure High-Volatility release. Listen as a family while on the road! Play audio from your Yoto App in your car, via Apple CarPlay or Android Auto. Step back onto the sand-peppered, wooden arcade floors of 1980’s seaside resorts and re-live your youth with faithful look and feel renditions of old favourites as well as modern twists on classic old-school fruit machines!
    https://gms-med.com/big-bass-bonanza-novibet-a-uk-players-perspective/
    The bonus the following could have been in person checked out and you will approved by we to make sure it works efficiently to possess U.S. professionals, no VPN expected. It could be an appealing offer to have people to try particular online casino games without any chance. Obviously, you simply can’t test video game from the a physical gambling establishment; although not, demonstration models from harbors usually are obtainable in web based casinos. So you can claim these now offers, you need to sign up for a gambling establishment account. No deposit spin gambling establishment bonuses are typically provided to help you participants whom get done the fresh subscription procedure. Mega Joker (99%) and Book of 99 (99.0%) have two of the highest RTP among the hundreds of slots available at the industry’s best slot sites. These games provide players with the best chance of earning cash profit when they play at the best slots sites.

  329. Estadísticamente, Sugar Rush Xmas de Pragmatic Play es estable, pero más recomendable para apostadores con experiencia. Lo primero que debemos destacar es un valor RTP de 96,5%, que es muy generoso en comparación con otras tragamonedas en línea. La disposición de carretes en este juego de casino online es 7×7 sin líneas de pago específicas, pues habilita pagos de forma dispersa y un total de 45 figuras. Sugar Rush Xmas no es una máquina tragamonedas convencional, por lo que se trata de una alternativa de juego interesante. Sin embargo, juega gratis a ps sugar rush en modo demo elegirías hacer apuestas con una expectativa negativa. Tiene Pragmatic Play juegos con jackpot, así que veamos cuál es la situación. Nuestra plataforma y app están habilitadas para ser utilizadas exclusivamente dentro de la Ciudad Autónoma de Buenos Aires (CABA).
    https://masfalhi.com/penalty-shootout-de-evoplay-imprescindible-para-jugadores-avanzados-en-casinos-online-latam/
    AMELIA PALACIOS © 2025. Todos los Derechos Reservados. Design online Ebook and slideshow with Fliplify Share your secrete and fun baking recipes. Create a beautiful infographic by using an easy pre-made template. Do it yourself and have fun! sugar-rush-casino-wiki.ru Juegos y caramelos se combinan a la perfección. ¿Qué mejor que saborear algo dulce mientras hacemos girar los rodillos? Eso, y varios premios, promete Sugar Rush, la slot que Pragmatic Play lanzó en junio de 2022 y en la que puedes ganar hasta 30 giros gratis. ¡Te invitamos a conocerla! You will always know exactly what is happening, why, where you stand and what your best options are, every step of the way. We listen to you, and we keep you informed throughout the process. Esta es una buena característica y proporciona a los jugadores una sensación de control sobre cómo juegan, pero cuesta dinero jugar. Al apostar en diecisiete divisiones, hemos existido el tiempo suficiente para saber qué sitios de casino en línea son realmente los mejores y cuáles no cumplen con la marca.

  394. ?Brindemos por cada explorador de tesoros !
    Cada vez mГЎs usuarios recomiendan MostBet por su fiabilidad y rapidez. [url=п»їhttps://estetiplan.es/][/url] La plataforma responde bien incluso en momentos de alta demanda. Por eso muchos la eligen para jugar a diario.
    Algunos jugadores mencionan que MostBet ofrece pagos sin demasiada espera. Los mГ©todos disponibles cubren diferentes preferencias. AsГ­ cada usuario elige la opciГіn que mГЎs le conviene.
    MostBet EspaГ±a es tendencia entre jugadores – estetiplan.es
    ?Que la suerte te sonria con brindemos por tus memorables apuestas triunfantes !

LEAVE A REPLY

Please enter your comment!
Please enter your name here

eighty − = 74