Transcription
SQL Server Analysis ServicesProtocol and Test Suite IntroMax WangSQL OIPI Test Development Team
Agenda
Understand SSAS
'Who' is SSAS?I’m an AnalyticalData EngineDecision SupportBusiness AnalyticsSemanticData ModelsBusiness Report&Data Visualization
Where is SSAS?APPs & ServicesMicrosoft Business IntelligencePower Pivotin ExcelSQL ServerAnalysisServicesSQL Server SQL ServerIntegrationDBMSServicesSharePointSQL ServerReportingServicesPower BIDataSQL ServerOracleMySQLJSON FileExcel File
How does Semantic Model work?Data WarehouseGet DataDeploySemantic ModelReporting ServicesAnalysis DatabaseAssignPermissionUserReports
Why don’t just Query?
SSAS Semantic 1/10
Data Access of Multidimensional ModelDataSourceRelationalData SourceCubeRetrieveDataMultidimensionalModelReport
Data Access of Tabular Model (Cached Mode)VertiPaqData SourceData Feed lysis DatabaseReport
Data Access of Tabular Model (DirectQuery Mode)SingleSQL ServerDirectQueryTabularModelReport
I heard there is an Azure Analysis Services.CloudTabular 1200Tabular 1400Tabular 1200Tabular 1400On-premisesTabular 110xMultidimensionalData MiningPowerPivot for SharePoint
More Details
Typical Message SequenceCreate ConnectionAuthentication Request (TCP)ClientAuthentication Response (TCP)New Session RequestNew Session ResponseSSAS Operation Request (Discover, Execute)SSAS Operation Response (Discover Execute)End of Session RequestClose ConnectionServerEnd of Session Response
OperationsAuthenticate RequestAuthenticate ResponseDiscover RequestClientDiscover ResponseExecute RequestExecute ResponseServer
Generating a messageDIME RecordTYPE FieldHTTPHTTP SASResponseTCPBinary IP
Parsing a messageDecode Binary TCPSOAPMessageSSAS RequestSSASResponse
Structure of SSAS messageScripting LanguageXMLASOAP
Scripting Language tidimensionalTabular110xTabular1200Tabular1400SQL Server2019ASSLASSLTMSLTMSLSQL Server2017ASSLASSLTMSLTMSLSQL Server2016ASSLASSLTMSLTMSLSQL Server2014ASSLASSLNANASQL e
ASSL SampleMultidimensionalTabular XMLA (for Compatibility Level 110x) Delete xmlns 3/engine" Object DatabaseID AdventureWorksDW2008 Create /DatabaseID /Object /Delete
ASSL in XMLAASSL
TMSL SampleTabular JSON (for Compatibility Level 1200 )"refresh": {"type": "automatic","objects": [{"database": "Adventure Works "}]}
TMSL in XMLATMSL
SSAS Objects - sionCellPermissionDatabaseRoleAggregation
Query Language of Multidimensional
CubeCar tWuhanst Quarter1BlackSwitchLocation ijingJan.Feb. Mar. Apr. May.TimeDimension
Miraculous Dimension
SSAS Objects - n
Query Language of TabularMDX Query
New Calculation Group in SSAS 2019InternetTotalSalesSales ColumnSales TableSales MTDSales QTDSales MeasureOrders ColumnOrder TableSales YTDOrder MTDOrder QTDOrders MeasureOrder YTD
Calculation Groups sampleMTDQTDYTDCalculation ItemsCalculation GroupSales TableTableOrder Table
Calculation Groups sample
Simpler the betterModel StructureQuery & ormancePartitionVertiPaq EngineMeasureHierarchySelf-Service BI
AMO-TOM Assemblies
Test Suite
Open Specifications program
Interoperability Test Tools Microsoft Message AnalyzerMicrosoft Protocol Test SuitesOData ValidatorPlugfests and eventsInteroperability labsMicrosoft Office Binary File Format ValidatorMicrosoft Exchange RPC Extractor
Why we need Test Suites?Ensure the quality of MicrosoftOpen SpecificationHelp to evaluate partnerimplementationsExtend and integrate tocustomized product
Test Suites workflowOpen SpecificationRequirement SpecificationTest SuiteHigh QualityOpen SpecificationFixIssue
Test SuiteTestSuiteSUT
Demo
Resources
For Newest News:Analysis Services Team Blog: Open Specifications Dev Center: s/For Developers:AMO: jects/amo-classes-introduction?view sql-server-2017TOM: evel1200?view sql-server-2017SQL Server 2016 Feature Pack download page: px?id 52676SQL Server 2017 Feature Pack download page: px?id 55992TestSuite Git: https://github.com/Microsoft/ProtocolTestFramework
For BI Users:SSDT: er-data-tools?view sql-server-2017SSRS: vices/tools/reporting-servicestools?view sql-server-2017Power BI: https://powerbi.microsoft.com/en-us/Power BI Blog: https://powerbi.microsoft.com/en-us/blog/Microsoft BI: s-intelligence
Microsoft Business Intelligence SQL Server Integration Services Data SQL Server Analysis Services SQL Server Reporting Services SQL Server Oracle MySQL JSON File Excel File Power Pivot . 2014 ASSL NA SQL Server 2012 ASSL NA Analysis Serv