Question : I have some columns representing Age in a table, taking values from 0 to 100, but also -1 […]
Tag: ssas
SSAS Date Dimension Relationship In Data Source View
Question : When a fact table is at a higher granularity to the date dimension (e.g. monthly) how should this […]
SSAS – how to script the General settings? where are them stored? how can they be queried?
Question : I believe I am an administrator on server BIREPLON1 SSAS as you can see on the picture below. […]
SQL Server AS: Set ImpersonationMode via PS
Question : Try to create a database in SQL Server Analysis Server (SQLAS, SSAS) version 2012 SP2 if that matters […]
Custom aggregation for non-leaf level nodes to avoid double counting
Question : I have a fact table with the following columns: WorkerName OrderId NumberOfPackagesPerOrder Note that neither WorkerName nor OrderId […]
What are Measures and Dimensions in Cubes
Question : I’m very new to Microsoft Sql Server Business Intelligence and Analysis Service(but I’m programming for years with SQL […]
Analysis Services backup error: File system error: Access is denied
Question : This isn’t your typical file system access is denied error. I am pretty perplexed by this issue. I […]
Designing a dimensional DB off a normalized source that already implements SCD’s
Question : I have built an SSIS ETL to integrate various data sources (one from MySQL, two from SQL Server) […]
What does a DBA have to know about SSAS?
Question : I’ve seen a lot of material covering the business aspect of SSAS, but not really much about the […]
SSAS – how to script the General settings? where are them stored? how can they be queried?
Question : I believe I am an administrator on server BIREPLON1 SSAS as you can see on the picture below. […]