How to browse cube in Excel

20
6152

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

20 COMMENTS

  1. This molecule is capable of vasodilating each of the arteries found in the penis buy cialis online europe In rhino 6500 male enhancement liquid front of the carriage, the supervisor, the elder, knelt down without saying a word, Chen erectile dysfunction after da vinci prostectomy Mens Health Vitamins Supplements Qintian, the supervisor, is looking forward to it, and is here by order

  2. You also don t have to worry about running into someone you know at the pharmacy or feeling embarrassed about your prescriptions dapoxetina generico Table 17 Mean Endpoint and Change from Baseline for the Primary Efficacy Variables in the Two CIALIS for Once Daily Use Studies Study H a Study I b Placebo N 94 CIALIS 2

  3. tetanus shot might not that the doc had never even seen a stingray sting before, but the lifeguards at the beach had all been stung before and there were about 3 others while I was soaking my foot at the lifeguard towere with the same sting. doxycycline for epididymitis Importantly, dobutamine injection, a membrane- permeant ОІ1AR agonist that does not require OCT3 to activate Golgi- localized ОІ1AR 16, 19, caused similar increases in the rate of contraction, relaxation, and tau in both wild- type and OCT3 knock- out mice Figure 6 C- E.

  4. Between October and December 2011, a persistent, raised, erythematous rash in the tattoo area developed in 19 persons 13 men and 6 women within 3 weeks after they received a tattoo from a single artist who used premixed gray ink; the highest occurrence of tattooing and rash onset was in November accounting for 15 and 12 patients, respectively. unidox solutab in usa Varges D, Manthey H, Heinemann U, Ponto C, Schmitz M, Schulz- Schaeffer WJ, Krasnianski A, Breithaupt M, Fincke F, Kramer K, Friede T, Zerr I.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

1 + = 6