{"id":141,"date":"2009-10-08T07:17:00","date_gmt":"2009-10-08T14:17:00","guid":{"rendered":"http:\/\/rajiniravi.com\/ravi\/wp\/?p=141"},"modified":"2009-10-08T07:17:00","modified_gmt":"2009-10-08T14:17:00","slug":"xl-connection-to-sql-analysis-services","status":"publish","type":"post","link":"https:\/\/ravi.rajiniravi.com\/blog\/2009\/10\/xl-connection-to-sql-analysis-services\/","title":{"rendered":"XL connection to SQL Analysis services"},"content":{"rendered":"<p>Last year, I had rigged up a OLAP cube in MS SQL Analysis server with sales data for the channel team I am part of. The front end was <a href=\"http:\/\/www.dundas.com\/\" target=\"_blank\">Dundas<\/a> data viz software. The interface itself wasn&#8217;t fast but I could build some nice visual dashboards. Then realized that for quick slicing and dicing of voluminous data, I could connect to the server thru MS-Excel (how-to <a href=\"http:\/\/support.microsoft.com\/kb\/940167\" target=\"_blank\">here<\/a>). The resultant pivot in XL  amazing flexibility to analyze the data.<\/p>\n<p>The logon credentials was done thru <a href=\"http:\/\/en.wikipedia.org\/wiki\/Integrated_Windows_Authentication\" target=\"_blank\">windows authentication<\/a>. Starting last week, I couldn&#8217;t connect to the cube and I just couldn&#8217;t figure out what the problem was! All I could think was that this was probably because I had changed my windows password at about the same time.<\/p>\n<p>The IT guys after a few days of trial and error found a simple solution, remove my &#8216;Document and Setting&#8217; folder and let Windows create a new profile! This is a dirty quick-fix.  I am still looking for the correct answer to this problem. So far the best explanation and discussion I got is in the <a href=\"http:\/\/www.experts-exchange.com\/OS\/Microsoft_Operating_Systems\/Server\/MS-SharePoint\/Q_21791885.html\" target=\"_blank\">expert exchange forum<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Last year, I had rigged up a OLAP cube in MS SQL Analysis server with sales data for the channel team I am part of. The front end was Dundas data viz software. The interface itself wasn&#8217;t fast but I could build some nice visual dashboards. Then realized that for quick slicing and dicing of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3979,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"book_review_cover_url":"","book_review_title":"","book_review_series":"","book_review_author":"","book_review_genre":"","book_review_isbn":"","book_review_publisher":"","book_review_release_date":"","book_review_format":"","book_review_pages":"","book_review_source":"","book_review_rating":"","book_review_summary":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[13,32,33,35,38],"class_list":["post-141","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-problem-soultion","tag-analysis-services","tag-ms-excel","tag-ms-sql","tag-olap","tag-problem"],"jetpack_featured_media_url":"https:\/\/ravi.rajiniravi.com\/blog\/wp-content\/uploads\/2021\/01\/photo-1547139559-c89c59d117611.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":0,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/media\/3979"}],"wp:attachment":[{"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ravi.rajiniravi.com\/blog\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}