Exploring the Capabilities of Microsoft SQL Server BI: A Unified Data Intelligence Stack
A Unified Ecosystem for Enterprise Intelligence In a data-driven world, organizations need more than just reports—they need an end-to-end ecosystem…
Category: SSAS
Key Difference between Relational & OLAP Reporting
Feature Relational OLAP Data Access Generalized access 1) Relational table(s)2) Transactional or Summary Table(s) Multi-dimensional (cross-tab) presentation only1) Dimensions &…
SSAS – When we need to do full processing of the cube even we have daily incremental processing of the cube.
Following are the scanario(s) in which we need to do full processing of the cube even we have daily incremental…
Analysis Service – How to create a measure of varchar datatype in SSAS cube
Work round: 1) We can do some work around if we have data like Age (21,50, 75) which is stored…
SSAS Error – KEY NOT FOUND while processing the Cube
1) The KeyNotFound property on the dimension ErrorConfiguration is for snowflake schema. 2) For example, you have employee table which…
SSAS – Performance issue with Date Dimension
When we dont have a proper date dimenison then SSAS wil give performance issue(s). Performance issue mostly come when we…
SSAS Tabular Model Issue: The file name(s) would be too long for the destination folder. You can shorten the file name and try again, or try a location that has a shorter parth
This issue occurred when we move/copy the SSAS solution to a different folder. if this is not getting solve by…
SSAS – Why aggregation values are not changing for the hierarchical dimensions in Cube.
This issue normally comes when there is a problem in relationship between Dimension and Measure group. Go to the Dimension…
Benefits of SSAS Performance Monitoring and Reporting
By consolidating SSAS performance data, we can build variety of performance monitoring reports that will help us in taking right…
Data Sources for SSAS Performance Monitoring
The following sources can be involved in the ETL processes to consolidate the performance data from SSAS instances for Performance…
SSAS Partition wise Disk Usage Report
Objective The objective of this report is show size of the partitions available in the cube and which storage mode…
SSAS Dimension Performance Report
Objective The objective of this report is monitor progressing time of all the dimensions as well as data retrieval time duration…