Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Tag: olap
SQL Server Table Design for Report – Is OLAP Schema Suitable
Question : A work colleague is developing SQL Server database tables for a reporting project. Basically, the only activity on […]
SQL Server Table Design for Report – Is OLAP Schema Suitable
Question : A work colleague is developing SQL Server database tables for a reporting project. Basically, the only activity on […]
CUBE and calculating the number of dimensions
Question : if a data presented with 4-dimension in which each dimension is dependent to hierarchical 3-level aggregate like (country, […]
SSAS OLAP Semi-Additive Measure over Time Dimension
Question : Issue: Help, I’m relatively new to building OLAP cubes in Microsoft’s SQL Server Analysis Services and I need […]
CUBE and calculating the number of dimensions
Question : if a data presented with 4-dimension in which each dimension is dependent to hierarchical 3-level aggregate like (country, […]
Do I still need OLAP cubes after a SQL Server Upgrade
Question : After our DBA got sacked for poor performance, I am now our accidental DBA. I have been pushing […]
How does a column-oriented DBMS filter on multiple columns?
Question : I’m learning how column-oriented DBMS / “columnars” work for OLAP situations. Let’s say we have a log of […]
Defining OLAP or OLTP on table level in Oracle/postgres/SQLserver
Question : Usually companies have separate databases for OLTP and OLAP (Row stores and column stores) where data is loaded […]
Cons of using a star schema in a columnar database
Question : My organisation is implementing a new data warehouse using a columnar data store (Redshift) and the performance is […]