How to browse cube in Excel

By
roopesh.valluru
-
86
8078

Friends,

We have soooo many tools to browse cube data. We can use MDX to pull data from SSAS cube and use the result set to generate reports using many tools like ssrs,dundas,xmla .. There are many tools like this but Client’s most favorite  and even green to browse cube is EXCEL. In this post we are gonna see how to connect to SSAS Cube from Excel. I have a cube ready in my server for this demonstration. PFB the steps to be followed:

  • Open Excel Sheet.
  • Select DATA tab on top of the sheet.
  • Select “From Analysis Services” under “From Other Sources” tab as shown below.

  • Provide the server name and the authentication details and click on next. In my case the server is my local computer and hence given as LOCALHOST as shown below.

  • Select cube database name from drop down list and click on next by selecting the cube as shown below.

  • Click on Finish. I will ask you to select the way you wish to IMPORT DATA. Leave the settings as is and click on OK. This will create a Pivot Table Report in Excel sheet.

  • You c an see Pivot Table Area on the left hand side of the sheet and Field list from cube on the right hand side of the sheet. You can drag and drop fields into ROWS,COLUMNS,FILTERS and VALUES to see the desired report as shown below.

That’s it .. You can play with Pivot by dragging and dropping Attributes and Measures on the required pane. Hope you understood it .. Happy coding !!

Regards,

Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

86 COMMENTS

  3. discount prescription drugs [url=https://cheapdr.top/#]levitra without a doctor prescription[/url] erection pills online

  19. le migliori pillole per l’erezione [url=https://viasenzaricetta.com/#]viagra naturale[/url] viagra prezzo farmacia 2023

  20. pillole per erezione immediata [url=https://viasenzaricetta.com/#]cialis farmacia senza ricetta[/url] viagra online spedizione gratuita

  22. Tako lahko v igralnici uživate brez omejitev. Platforma v živo deluje po preprostem načelu: igrate in pravi krupjeji na strani igralnice. Igra zato zelo natančno spominja na klasični obisk. In posebna zahvala vsem kanadskim šolam in univerzam, ki bo odpravila zmedo in razdrobljenost trenutno obdaja credentialing strokovnjakov za zdravljenje iger na srečo. Če pa je vaša država prepovedala spletne igre na srečo, da igrajo na bodisi pravi denar ali demo igre. Vse spletne igre za denar, ki jih lahko preizkusite v priporočenih igralnicah iz našega seznama ocenjujemo po strogem kriteriju. Vsako spletno igralnico najprej obiščemo in preizkusimo ter ocenimo, preden jo priporočimo slovenskim igralcem. Pomembno je, da gre za zaupanja vreden kazino z licenco, ki svojim obiskovalcem ponuja najboljše pogoje za igranje in varno zabavo. Pri vsakem spletnem mestu, ki ponuja casino igre online pa upoštevamo tudi druge kritične elemente in lastnosti, ki vam jih predstavljamo spodaj.
    https://noorderzon-online.nl/community/profile/christianevonwi/
    Koliko časa bo odlok trajal, ne ve nihče, je pa strokovna svetovalna skupina ministra za zdravje za zajezitev in obvladovanje epidemije po neuradnih informacijah Slovenske tiskovne agencije (STA) sicer obravnavala poziv kinematografov. A je na koncu vseeno predlagala, da še naprej veljajo ukrepi, ki predvidevajo, da se hrana in pijača lahko ponujata le v gostinskih lokalih in samo na sedeč način. Vstop je možen za osebna vozila, vstopnice se obračunajo na osebo (za Misijo: Nemogoče znaša vstopnina 6,20 EUR/osebo, za Briljantino pa 4 EUR/osebo), ob vstopu na prizorišču je potrebno doplačilo za avto v višini 3 evrov. Bodite med prvimi, ki boste izvedeli, katere koncerte, predavanja, gledališka in plesna gostovanja in drugo pripravljamo v Cankarjevem domu.

  26. northwest canadian pharmacy [url=http://canadapharm.pro/#]canadian pharmacy 24h com safe[/url] canadian medications

  27. best canadian online pharmacy [url=https://canadapharm.pro/#]legit canadian online pharmacy[/url] canada pharmacy online

  28. reputable indian online pharmacy [url=https://indiapharm.pro/#]trusted india online pharmacies[/url] indian pharmacies safe

  29. canadian drugs [url=https://canadapharm.pro/#]best canadian pharmacy online[/url] my canadian pharmacy review

  30. reputable indian pharmacies [url=https://indiapharm.pro/#]online pharmacy india[/url] indian pharmacy paypal

  42. online ed medications [url=https://edpills.pro/#]ed pills for sale[/url] impotence pills

  50. 888 casino live help You’re currently using a browser that our site doesn’t fully support. Throughout the years I’ve spent playing online casinos, I’ve encountered countless online casinos ranging in quality and legitimacy. So, when I come across an excellent online casino, I can tell pretty much instantly, and 888 Casino is undoubtedly one of those casinos worth your time. As a result, 888 Casino is an online casino site that is likely to appeal to specific players, mainly newcomers to the online casino world. An easy site to navigate, with a small-but-strong game collection and great promotions, can act as a good introduction to players. For those who have more experience in the industry, however, what 888 Casino does not have will likely be more apparent than what it does. The entirety of 888’s live casino platform is completely responsive. It is suited for smartphones and tablets, so you can enjoy 888 casino games on your mobile device while on the move. The iOS 888 app requires the 10.0 version of the system or newer, whereas the Android version works best on devices with 7.0 and preferably higher. The Android app will work smoothly on popular devices such as LG, Amazon Kindle, Samsung Galaxy, Nexus, and dozens of other types.
    https://www.click-bookmark.win/online-casino-win-real-cash-no-deposit
    The OUSC team receives several inquiries related to online casino gameplay. These are some of the questions we often get regarding mobile online casinos. Mobile casinos offer you the flexibility of playing your favorite casino games on your smartphone or tablet. Every top online casino has a desktop and mobile version of their site nowadays, with an ever increasing number prioritising the user experience on the mobile version to cater to your preferences. Yes, you can win real money at mobile online casinos. People win prizes and cash out every single day. Pick a trusted site from our casino reviews and start playing your favorite games. Have fun, and you may be the next jackpot winner! Whether you are boarding a one-way train bound for Washington DC or traveling to New Orleans for a change of scenery, a mobile casino app can keep you company as long as your device is connected to the web via Wi-Fi, 3G, 4G, 5G, or LTE. Read on to discover more about the thrills today’s casinos hold for all American players when joining the best online casinos in the USA.

  51. world pharmacy india [url=http://indianpharmacy.pro/#]cheapest online pharmacy india[/url] india pharmacy mail order

  55. treatment of ed [url=https://edmeds.pro/#]best ed medication[/url] pills erectile dysfunction

  57. Yes, they do. Own goals don’t affect the correct score betting outcome, and it doesn’t matter which teams scored the goal, the only thing that matters is the final score (or first second half score depending on what kind of market you place the bet on). Then it is necessary that you open your horizons. Sometimes limiting yourself to a single competition or a single sport can lock you into a certain routine, always dangerous in the context of the bet. So, take advantage of all our predictions, for example our rugby predictions, to vary the bets in sports betting, it is important. 2023-04-22 01:30 At KickOff, we focus all our data on finding you that winning correct score prediction. We have graphics showing everything from how many goals a team typically scores per game, to a team’s most frequent correct scores over the last 20 games, and a league table which shows their past scorelines against teams in different league positions. Basically, everything you could want to know before placing a correct score bet. The perfect correct score tip.
    http://j-clinic.kr/bbs/board.php?bo_table=free&wr_id=4896
    Harrison returned to the United States and his North Bend farm, living in relative privacy after nearly four decades of government service. He had accumulated no substantial wealth during his lifetime, and he lived on his savings, a small pension, and the income produced by his farm. Burr references M. Chavalier, who encountered Harrison in Cincinnati at this time, and described Harrison as “poor, with a numerous family, abandoned by the Federal government, yet vigorous with independent thinking”. 17:12 B Harman (US), I Poulter (Eng), B Todd (US) 9:48 a.m.: Hideki Matsuyama, Harris English, Abraham Ancer Brendan Todd will make the final title defense of the season as he returns to the site of his one-shot victory over three players last year. With a score of 20-under par 264 he finished one clear of Adam Long, Vaughn Taylor and local favorite Carlos Ortiz. The win was Todd’s second in a row as he had claimed the Bermuda Championship the week prior.

  58. According to Dr. Janelle Davidson, people who wear contact lenses or have sensitive eyes should be a bit more discerning about what eyeliner they use. She recommends avoiding waterproof eyeliners as well as formulas with talc, sulfates, BAK (benzalkonium chloride), and BHA. When in a time crunch, reaching for the best mascara in your beauty arsenal is often easier and more time efficient than, say, applying a lipstick. Nothing complements a look quite like a fluffy, voluminous lash. What to Consider: The applicator is much shorter than traditional mascara brushes, and some may find it difficult to use. A unique wand makes this easy to grip and apply Why We Love It: This Diorshow mascara has a distinct curling brush, which allows the waterproof formula to glide on effortlessly for beautiful and full lashes.
    http://www.celtras.uniport.edu.ng/profile/w5lkayu996/
    Since gua sha’s early beginnings, which date back to ancient China, people have been known to perform it with everything from spoons to horns to mason jar lids. Luckily, gua sha today is predominantly practiced with more therapeutic materials, like Bian stone, jade, or rose quartz. Materials aren’t the only thing to consider either: Gua sha tools can come in a variety of shapes and sizes. While the most popular designs tend to look like a foot or a heart, Plug recommends you choose a shape that you feel the most comfortable holding. Highlights: * Has worked as a fact checker for Real Simple since 2022 * Worked as a staff writer for Mochi Magazine * Currently runs and operates the United States blog for Student Beans Well, I tapped some of our favorite experts for a full rundown on what stone and type of tool are right for you.

  61. my canadian pharmacy rx reviews [url=http://fastdeliverypill.com/#]medicine from canada with no prescriptions[/url] androgel canadian pharmacy

  66. canada pharmacy online no prescription [url=https://fastdeliverypill.com/#]canadian pharmacies that sell viagra[/url] certified canadian pharmacy

  74. canadian pharmacy [url=https://canadiandrugs.pro/#]precription drugs from canada[/url] canadian family pharmacy

  78. Rulettifaneja neuvotaan opettelemaan eri rulettipelien tyypit kuten eurooppainen ruletti, amerikkalainen ruletti ja ranskalainen ruletti, sekä ymmärtämään kaikkien näiden eri versioiden säännöt. On ymmärrettävää, että nopeasti katsoen pelaajat saattavat olettaa, että kaikki rulettipelit ovat samanlaisia. Suuri rulettipyörä, panostusvaihtoehdot ja pelin luonne näyttävät kauttaaltaan samalta. Tämä Karamban opas kertoo kuinka nauttia ruletista oikealla tavalla ja selittää pelaajille tarkalleen, mitä heidän täytyy tietää erilaisista ruletin pelityypeistä, säännöistä ja panostusvalinnoista. Ruletissa loistamiseen vaikuttaa ensisijaisesti pelaajan tuuri, mutta myös pelivalinnoilla on jonkin verran väliä. Moni hyödyntää jonkinlaista panostusstrategiaa, mutta pitkässä juoksussa ne toimivat vain harvoin. Ruletti on tuuripeliä, mutta pelaamista on mahdollista helpottaa tiettyjen vinkkien avulla. Tässä siis kahdeksan hyödyllistä rulettivinkkiä, ohjeet ruletin pelaamiseen sekä pari neuvoa!
    http://dmonster484.dmonster.kr/bbs/board.php?bo_table=free&wr_id=108492
    Kolikkopelit-kasinon taustalta löytyy vankkaa osaamista kasinopelaamisesta, niin kotimaiselta kuin ulkomaiseltakin sektorilta. Kolikkopelit on nykyään osa Kindred Groupia, joka on yksi maailman suurimmista verkon rahapelitoimijoista. Nettikasinon juuret ovat kuitenkin syvällä Suomessa, sillä perustajien joukkoon kuului muiden muassa monessa muussakin hankkeessaan menestynyt Jasper Pääkkönen. Nettilompakot ovat monen pelaajan ykkösvalinta, sillä niiden avulla rahansiirrot voi tehdä helposti ja nopeasti. Niitä käyttäessäsi sinun ei tarvitse antaa operaattorille henkilökohtaisia maksutietoja, mikä vähentää sitä riskiä, että tiedot joutuvat vääriin käsiin. Vaikka PayPal on muuten hyvin suosittu maksutapa nettiostoksiin, tarjoaa valitettavan harva suomalainen kolikkopelit-casino sitä vaihtoehdoksi. Sen sijaan esimerkiksi casinosivut, jotka käyttävät Netelleriä, ovat pelaajien suuressa suosiossa.

  79. canadian pharmacy [url=https://canadiandrugs.pro/#]legitimate canadian mail order pharmacy[/url] canada rx pharmacy

  83. indianpharmacy com [url=https://pharmacyindia.pro/#]п»їlegitimate online pharmacies india[/url] indianpharmacy com

LEAVE A REPLY

Please enter your comment!
Please enter your name here

3 + 1 =