Top "Olap" questions

Online Analytical Processing (OLAP) is a category of software tools that provides analysis of data stored in a database, optimized for querying and reporting.

What are OLTP and OLAP. What is the difference between them?

Actually what do they mean? All articles I find about them don't give me an idea, or my knowledge is …

database database-design database-schema olap oltp
Data Warehouse vs. OLAP Cube?

Can anyone explain what is really distinction between Data Warehouse and OLAP Cubes? Are they different approach for same thing? …

data-warehouse olap olap-cube
SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax …

sql-server ssas mdx where-clause olap
Benefits of using Staging Database while designing Data Warehouse

I am in process of designing a Data Warehouse Architecture. While exploring various options to Extract data from Production and …

database-design data-warehouse olap
OLAP Cube deployment issues

I'm really new to this, so I am probably making a simple mistake. I need to make an OLAP cube …

sql connection ssas olap cube
Postgresql for OLAP

Does anyone have experience of using PostgreSQL for an OLAP setup, using cubes against the database etc. Having come across …

postgresql olap cubes
How to determine which SSAS Cube is processing now?

There is a problem when several users can process the same cube simultaniously and as a result processing of cube …

sql-server-2008-r2 ssas olap
OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE

I use SQL Server 2008 R2 and SQL Server Business Intelligence Development Studio. I create one project of Business Intelligence Project …

sql sql-server sql-server-2008-r2 ssas olap
How to learn MDX

I am currently learning OLAP & MDX after many years of relational database development. Any tips on getting started in …

ssas olap mdx
What is Multi Dimension OLAP CUBE and give example cube with more than 3 dimensions

As I am new to SSAS, have been reading an article on Multi-Dimension OLAP Cube and struggling to understand Cube …

sql-server ssas data-warehouse olap