Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: ssas

SSIS / SSAS: Handling Age Columns

By adminPosted on January 27, 2023

Question : I have some columns representing Age in a table, taking values from 0 to 100, but also -1 […]

SSAS Date Dimension Relationship In Data Source View

By adminPosted on January 25, 2023

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?

By adminPosted on January 16, 2023

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

By adminPosted on January 11, 2023

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

By adminPosted on January 8, 2023

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

By adminPosted on December 27, 2022

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

By adminPosted on December 25, 2022

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

By adminPosted on December 7, 2022

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?

By adminPosted on November 24, 2022

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?

By adminPosted on November 17, 2022

Question : I believe I am an administrator on server BIREPLON1 SSAS as you can see on the picture below. […]

  • 1
  • 2
  • 3
  • …
  • 12

Recent Posts

  • Why does my BETWEEN predicate not match any rows? [closed]
  • MySQL using a index referencing a different column
  • mysql – Recovering databases from ibdata1 , .frm and .idb
  • Postgres: What could cause the error “cannot call populate_composite on a scalar”?
  • Safely changing innodb_buffer_pool_size on MySQL replication master?
  • Why my index don’t update?
  • MySQL – What exactly does smallint(2) permit? [duplicate]
  • Optimize a slow nested loops join
  • How to perform query operation on another query result
  • Identity column re-seed: when it is necessary?
  • MySQL -> Loop through a table, running a stored procedure on each entry
  • Optimize Postgresql query
  • How to speed up mysql query?
  • How to optimize a query for < operator
  • SQL Server transaction log [duplicate]
  • Can’t do a full backup because the log is full [duplicate]
  • Mysql error : Slave SQL Could not execute …on table
  • mySQL changing output unit of ST_Distance function
  • Is it bad to have a cyclical relationship?
  • Postgres 8.3 faster than 9.3?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding