#title Analysis Service [[TableOfContents]] OLAP.. 참 좋은거 같으면서도 좋지 않습니다. 분석이 주어진 차원으로만 이루어지는게 아니라는.. 그러기 위해서는 파워풀한 직관적인 ad-hoc query tool이 필요하다는.. ==== DAX ==== * [DAX Calculate the Max for a Group] ==== MDX ==== * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/7mnQHXxeGI4/ Counting Consistent Customers in MDX] * [http://www.mssqltips.com/sqlservertip/2877/sql-server-analysis-serviceslead-lag-openingperiod-closingperiod-time-related-functions/ Lead, Lag, OpeningPeriod, ClosingPeriod Time Related Functions] * [http://www.sqlservercentral.com/articles/MDX/95065/ MDX Guide for SQL Folks: Part III - Advanced Analysis] * http://www.reportportal.com * [MDX - 용어와 개념] * [http://bloggingabout.net/blogs/mglaser/archive/2008/08/15/configuring-http-access-to-sql-server-2008-analysis-services-on-microsoft-windows-server-2008.aspx Configuring HTTP Access to SQL Server 2008 Analysis Services on Microsoft Windows Server 2008] * [http://technet.microsoft.com/ko-kr/library/bb630321.aspx 디자인 경고 규칙] * [http://www.ssas-info.com/VidasMatelisBlog/144_using-ssrs-to-report-ssas-2008-database-structure-using-dmvs Using SSRS to report SSAS 2008 database structure using DMVs] attachment:AnalysisService/SSAS.DMV.sql [http://watist.tistory.com/578 원본] * tools * http://code.google.com/p/ranet-uilibrary-olap/downloads/detail?name=Ranet.UILibrary.Olap-1.3.3.0-6571.msi&can=2&q= * http://code.google.com/p/galaktikabusinessmonitor/downloads/detail?name=Galaktika.BusinessMonitor-4.5.461.0.msi&can=2&q= ==== 참고자료 ==== * [https://msdn.microsoft.com/ko-kr/library/gg492140(v=sql.120).aspx IIS(인터넷 정보 서비스) 8.0에서 Analysis Services에 대한 HTTP 액세스 구성] * [http://cwebbbi.wordpress.com/2012/12/18/introduction-to-mdx-for-powerpivot-users-part-5-mdx-queries/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%27s+BI+Blog%29&utm_content=Google+Reader Introduction to MDX for PowerPivot Users, Part 5: MDX Queries] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/wwfzWPcBqMI/ Introduction to MDX for PowerPivot Users, Part 4: Filtering] * [http://www.sqlservercentral.com/articles/MDX/91228/ MDX Guide for SQL Folks: Part I - Navigating The Cube] * [http://cwebbbi.wordpress.com/2012/10/28/free-mdx-training-video-now-live/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%27s+BI+Blog%29&utm_content=Google+Reader Free MDX Training Video Now Live] * [http://cwebbbi.wordpress.com/2012/10/22/returning-selected-items-in-an-excel-slicer-using-mdx-in-powerpivot-and-ssas/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%27s+BI+Blog%29&utm_content=Google+Reader Returning Selected Items in an Excel Slicer Using MDX in PowerPivot and SSAS] * [http://strataconf.com/stratany2012/public/schedule/detail/25672 Letting More Developers Dance with Elephants: What We Learned] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/lh1dw_b5LEk/ Named Sets and Block Computation in SSAS 2012] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/6E-hiG-nTtY/ Controlling the Position of Subtotals in DAX with GenerateAll()] * [http://www.databasejournal.com/features/mssql/analysis-services-powershell-provider-sqlas-in-sql-server-2012.html Analysis Services PowerShell Provider (SQLAS) in SQL Server 2012] * [http://cwebbbi.wordpress.com/2012/02/28/natural-and-unnatural-hierarchies-in-the-ssas-2012-tabular-model/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%27s+BI+Blog%29&utm_content=Google+Reader Natural and Unnatural Hierarchies in the SSAS 2012 Tabular Model] * [attachment:AnalysisService/1_SSAS_Best_Practice_JG_LEE.pdf SSAS Best Practice 2011] * [http://cwebbbi.wordpress.com/2012/01/12/aliasing-columns-in-dax/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%27s+BI+Blog%29&utm_content=Google+Reader Aliasing Columns in DAX] * [클라이언트PC 엑셀에소 전송계층 오류시] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/mfeQGwGcJRg/ Solving the Events-In-Progress Problem in DAX V2.0] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/gPrqQ4TjikM/ DAX Queries, Part 1] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/OdITPznW1sk/ DAX Queries, Part 2] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/owgpCFcHZrE/ DAX Queries, Part 3] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/7tVWgnQtqHc/ DAX Queries, Part 4] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/0ZDKiRg0ReY/ DAX Queries, Part 5] * [http://feedproxy.google.com/~r/wordpress/Cpjz/~3/E3JK02Ai4KY/ DAX Queries, Part 6] * [attachment:AnalysisService/SSASPerfGuide2008R2.pdf SQL Server 2008 R2 Analysis Services Performance Guide] * [attachment:AnalysisService/SSASOpsGuide2008R2.docx SQL Server 2008 R2 Analysis Services Operations Guide] * [http://cwebbbi.wordpress.com/2011/05/24/replacing-linkmember-with-a-many-to-many-relationship/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%27s+BI+Blog%29&utm_content=Google+Reader Replacing Linkmember with a Many-to-Many Relationship] * [http://ewinarko.staff.ugm.ac.id/datamining/OpensourceBI.html Open source BI] * http://ssas-wiki.com/w/Articles * http://www.olap4j.org/ * [http://www.microsoft.com/downloads/en/details.aspx?FamilyID=65df6ebf-9d1c-405f-84b1-08f492af52dd&displaylang=en Analysis Services Distinct Count Optimization] * [http://www.microsoft.com/downloads/en/details.aspx?FamilyID=3be0488d-e7aa-4078-a050-ae39912d2e43&displaylang=en SQL Server 2008 White Paper: Analysis Services Performance Guide] * [http://blogs.technet.com/b/dataplatforminsider/archive/2010/11/12/analysis-services-roadmap-for-sql-server-denali-and-beyond.aspx Roadmap for SQL Server “Denali” and Beyond] * [http://www.mssqltips.com/tip.asp?tip=2095 Using XMLA Command to Clear Cache of an Analysis Service Database] * [http://www.simple-talk.com/sql/reporting-services/adding-actions-to-a-cube-in-sql-server-analysis-services-2008/ Adding Actions to a Cube in SQL Server Analysis Services 2008] * [http://www.mssqltips.com/tip.asp?tip=1906 How to restore an Analysis Services Database] * [attachment:SSAS_HTTP_Access.docx Microsoft Win2003에서 SQL Server 2005 Analysis Services에 대한 HTTP 액세스 구성] * [http://www.bidn.com/] * [http://www.sqlserverdatamining.com/ssdm/Home/TipsTricks/tabid/61/Default.aspx?id=394 Explore filtered models in SQL Server 2008] * [http://www.sqlservercentral.com/articles/Analysis+Services+-+Decision+Tree/68502/ A Decision Tree inside out] * [http://www.sqlservercentral.com/articles/SQL+Server/68139/ A Neural Network in SQL Server] ---- SQIAR (http://www.sqiar.com) is a leading global consultancy which provides innovative business intelligence services to small and medium size (SMEs) businesses. Our agile approach provides organizations with breakthrough insights and powerful data visualizations to rapidly analyse multiple aspects of their business in perspectives that matter most. -- Sqiar 2013-11-16 09:53:19