Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Questions tagged [olap]

On-Line Analytical Processing, a class of systems designed for fast calculation, reporting and analysis of aggregate figures.

Filter by
Sorted by
Tagged with
0 votes
1 answer
31 views

what is the difference between data warehouse engine, data warehouse, olap engine, olap database, data storage engine vs data storage?

I need to clarify the keyword "engine" and what functionality stands behind it. I assume engine is a smaller component of a bigger thing - database. Like a 'car engine' is inside a car. So ...
ERJAN's user avatar
  • 483
0 votes
0 answers
28 views

Comparison of rolap and molap in the tubular or multidimensional environment is better?

I want to write a comparison article on ROLAP and MOLAP, and I have installed SSAS. During the installation process, there was a Tabular section and a Multidimensional section that I needed to choose ...
Kavous's user avatar
  • 1
0 votes
0 answers
26 views

Handling updates in OLAP system for e-commerce system using immutable stores

I have a digital commerce system that we have built in-house and it has been working fine. We now want to implement OLAP to provide our customers with advanced reporting and BI features. While looking ...
brahmana's user avatar
  • 101
-1 votes
1 answer
101 views

Real Time Analytics: Which database?

We are currently using MongoDB, and it is performing well for our needs. However, we are looking to support better real-time analytics and aggregations, which MongoDB doesn't handle effectively. ...
Nedim's user avatar
  • 99
0 votes
1 answer
49 views

SQL server OLAP tables perfomance

I have some tables on my SQL Server database that I only run inserts / updates nightly from our services and they are Read-only during the day for our clients (there is no update / insert / delete ...
beto's user avatar
  • 1
0 votes
0 answers
82 views

Setting up an HTAP Environment

I've had success in the past with setting up a CIX/PK on an identity column and then setting up supporting NCIX and NCCsIX on tables to help support an HTAP environment. I'm curious, going forward ...
Miguel Sanchez's user avatar
0 votes
0 answers
417 views

Cube won't deploy

I was able to deploy a large cube (with 2 dimensions and 1 measure) in Analysis services server but only after setting configuration error options for both dimensions and the measure (through the ...
Patrick Schulz's user avatar
0 votes
2 answers
2k views

What version of MSOLAP provider am i using?

We've just upgraded a Server from SQL Server 2016 to 2019. We have linked servers connecting to an OLAP cube. When I look under providers for MSOLAP the label of the dialog box shows: Microsoft OLE ...
Sir Swears-a-lot's user avatar
0 votes
1 answer
59 views

Data modeling for Warehouse

I am learning about database warehouses and data modeling. I came across this blog post. In the section, "DIFFERENT MODELS HAVE DIFFERENT PURPOSES" the author mentions that depending upon ...
adam's user avatar
  • 1
3 votes
2 answers
258 views

CUBE and calculating the number of dimensions

if a data presented with 4-dimension in which each dimension is dependent to hierarchical 3-level aggregate like (country, city, street), then we can summarize it into 4096 ways! we know for cube ...
Betty Andersson's user avatar
3 votes
2 answers
1k views

How does a column-oriented DBMS filter on multiple columns?

I'm learning how column-oriented DBMS / "columnars" work for OLAP situations. Let's say we have a log of millions of transactions with 3 columns: timestamp, shop, product, and we want to ...
Basj's user avatar
  • 171
0 votes
1 answer
81 views

How to combine Oracle RAC with in-memory database to isloate OLAP from OLTP

I am going through a document https://www.oracle.com/technetwork/database/options/database-in-memory-data-sheet-2338744.pdf There is a thing written "Oracle Real Application Clusters (RAC) can be ...
user3102917's user avatar
1 vote
1 answer
400 views

Defining OLAP or OLTP on table level in Oracle/postgres/SQLserver

Usually companies have separate databases for OLTP and OLAP (Row stores and column stores) where data is loaded through ETL jobs to another database for analytical processing. I am particularly ...
user3102917's user avatar
1 vote
0 answers
80 views

SSAS : are dimensions with only Id and Name attributes useless?

I wonder if it is worth creating a dimension with only one column (e.g. Name) in addition to its Id Column. This dimension would be referenced by a fact containing a reference to the Id attribute of ...
lolveley's user avatar
  • 141
2 votes
0 answers
557 views

startup ask failed for service MSSQLServerOLAPService

I can't install SSAS (SQL Server analysis services) in multidimensional mode : I get an error at the end of the installation : startup ask failed for service MSSQLServerOLAPService. I was able at the ...
lolveley's user avatar
  • 141
1 vote
1 answer
76 views

Why does there have to be a tradeoff between optimizing a DB for transactional data and optimizing a DB for analytical data?

I'm a data scientist who's more on the math and modeling side of things than the engineering side, and I don't know much about the logic, data structures and design principles that underly database ...
Alex Kinman's user avatar
0 votes
1 answer
147 views

In a data warehouse, should a measure be based on a fact or a dimension?

Let's say there is a data warehouse created from a shop data. A fact is a single purchase of a product. There is a dimension that describes a customer. There is a need to create a measure that ...
Michal Karbownik's user avatar
1 vote
1 answer
155 views

Do I still need OLAP cubes after a SQL Server Upgrade

After our DBA got sacked for poor performance, I am now our accidental DBA. I have been pushing to upgrade our SQL Server instance from 2012 to 2017 so I can use the clustered column store indices in ...
Palps's user avatar
  • 113
0 votes
1 answer
488 views

Restore from .db folder for Analysis Services

There is an objective to recover cube from long time ago retired MSAS instance. Issue I'm currently standing with is that actual .abf backups are now in a cold storage and recovering them would take a ...
JagdCrab's user avatar
  • 101
0 votes
1 answer
20 views

Is there such a thing as an OLAP cube that can change the number of levels in a hierarchy without having to be rebuilt?

The current analytics solution that my team works with cannot handle changes in the structure of one of its hierarchies. If a new level or branch is added, then the entire domain must be first backed ...
Alex Kinman's user avatar
1 vote
0 answers
92 views

Are OLAP / NoSql / In-Memory database mutually exclusive concepts or can there be overlap between them?

I'm a data scientist with little knowledge of DB technology. I keep hearing 3 types of databases mentioned as key technologies for analytics and modeling solutions: NoSql databases OLAP cubes In-...
Alex Kinman's user avatar
20 votes
1 answer
2k views

What exactly is the 'online' in OLAP and OLTP?

I'm a bit confused because I'm questioning the definition of 'online' in OLTP and OLAP. I used to think that 'online' here means that we want our answer in bounded time and based on the data available ...
Zeruno's user avatar
  • 497
1 vote
0 answers
918 views

Where to build the OLAP cubes? [closed]

I have built a data warehouse with multiple fact tables and dimension tables (with a MySQL server). Now where could I build the OLAP cubes and write the MDX queries to produce results? BTW, I have ...
mingchau's user avatar
  • 176
0 votes
1 answer
318 views

SQL to MDX translation?

An MDX (a language dealing with multidimensional data, in particularly dealing with the cube metaphor) statement can be translated to an SQL (a well-known language for the relational model) statement -...
Zeruno's user avatar
  • 497
2 votes
0 answers
1k views

connection to remote Analysis Services from SSMS

On my company local SQL Server instance I was able to add a linked server to a remote AS instance (in Management Studio > Server Objects). I was also able to connect using Data Tools, as well with ...
matt's user avatar
  • 21
0 votes
2 answers
2k views

Cons of using a star schema in a columnar database

My organisation is implementing a new data warehouse using a columnar data store (Redshift) and the performance is currently abysmal. There are many causes for this but I think the key reason is ...
roastbeeef's user avatar
1 vote
0 answers
134 views

Proactive caching vs. nightly cube reprocess

I'm working with an SSAS cube that's fully reprocessed every night by an SSIS job. My current goal is to get data into the cube with less latency, and to do so I'm looking at implementing proactive ...
Julian Goldsmith's user avatar
0 votes
0 answers
700 views

Process an OLAP Cube as a daily job takes too long using `ProcessFull` option

I have two cubes which updates in sequence. These takes very long to update, upwards of 5 hours due to their sizes. I have a SQL agent job which updates the cubes. The job has type SQL Server ...
Cenderze's user avatar
  • 197
0 votes
1 answer
33 views

Using OLAP-specs to compute selective running totals

Let's say I have a table with columns id, subid, state, value, where (id, subid) is a unique tuple, state may be 0 or some value <> 0, and value is just some number. I want to build a query that ...
Bubaya's user avatar
  • 155
0 votes
1 answer
522 views

OLAP window functions in DB2

I am using DB2 z/OS 11.1.5. According to this reference, OLAP functions such as first_value should be supported at least in DB2 9.7. However, when trying to execute the query declare global ...
Bubaya's user avatar
  • 155
2 votes
2 answers
1k views

Dealing with different types in a fact table

I'm working with dimensional modelling for the first time, trying to build a data warehouse that pulls in data from an OLTP database, and I'm having some trouble figuring out what to do with this type ...
crf's user avatar
  • 121
2 votes
1 answer
1k views

SSAS Realtime Processing

I created a cube in SSAS, how I can extract real time data from the data source to my cube? I mean if any data modification (insert, update, delete) happens, SSAS should update the cube.
hd.Ngo's user avatar
  • 31
2 votes
1 answer
2k views

Why do OLAP cubes perform better than Relational databases on certain tasks?

My team uses a Multidimensional OLAP database for a lot of it's analytics and predictive modeling. The standard line in all the documentation is "OLAP cubes are better suited for this type of ...
Alex Kinman's user avatar
1 vote
1 answer
118 views

MAT over a calculated measure [closed]

We have an OLAP SSAS cube with budget data on the fact table, and budget cathegory (sales, costs, salaries, ...) on a dimension. We have a bunch of formulas for our users but we are not able to create ...
DeepButi's user avatar
  • 161
1 vote
0 answers
422 views

Reduce RAM required to process OLAP cube

I have a cube which I have created by using (in Visual studio) New Project -> Import from Server (Multidimensional and data mining). This cube is indeed created from the metadata of an already ...
Cenderze's user avatar
  • 197
7 votes
1 answer
2k views

SSAS OLAP Semi-Additive Measure over Time Dimension

Issue: Help, I'm relatively new to building OLAP cubes in Microsoft's SQL Server Analysis Services and I need help with a semi-additive measure over a time dimension. In other words, I want to show ...
Christopher Aliotta's user avatar
1 vote
0 answers
44 views

What schema if I have many measures

Forgive me if I misuse any words. I'm a c++ programmer with some basic DB knowledge. I'm developing an analytics engine for simulation data for vehicle engines. OLAP seems like a good fit but I haven'...
BdON003's user avatar
  • 11
3 votes
3 answers
5k views

Should dates in dimensional tables use dimDate?

Assuming my dimDate has a surrogate key. Should all the date columns in the dimensional tables (not the fact tables) store the surrogate key of date dimension? Or just plain date? For example, in ...
u23432534's user avatar
  • 1,535
20 votes
2 answers
21k views

Difference between star schema and data cube?

I am involved in a new project where I have to create a data cube from the existing relational database system. I understood that the existing system is not properly designed, and I am not sure where ...
Rathish Kumar B's user avatar
3 votes
1 answer
2k views

speed up PostgreSQL calculations via OLAP warehouse?

So I have asked these three questions: Percentile rank that takes sorted argument (or same functionality) in PostgreSQL 9.3.5 https://quant.stackexchange.com/questions/29572/building-financial-data-...
mountainclimber11's user avatar
1 vote
0 answers
87 views

Incorrect hierarchy relationship while joining with parent-child tables

I have two tables with 1:M relation in my DB: GROUP (GroupId, GroupName, AccountId) USER (UserId, UserName, GroupId, AccountId) and ACCOUNT (AccountId, AccountName). I added all needed links from ...
K V's user avatar
  • 11
1 vote
1 answer
277 views

Is OLAP cube duplication of data?

Is an OLAP cube a duplication of data or is it just references to original tables? Or can I control it?
Rott's user avatar
  • 13
-1 votes
1 answer
349 views

SQL Server connection, session, command handling

I am trying to build an etl tool that tracks DMV data from SSAS Instance. To do that and in advance to record sql queries that users are request, i must know how the sql server handles the connection, ...
Stavros Koureas's user avatar
2 votes
1 answer
1k views

SSAS Cache Levels

I am using SSAS for reporting statistics on a big amount of data. Recently I began learning best practices for tuning and I am interesting in how SSAS caches the data. I have done my research and I'...
Stavros Koureas's user avatar
0 votes
1 answer
389 views

pglogical for OLAP queries

I am looking to setup a replica for OLAP queries. Currently in my prod I have a master (OLTP node) replicating to a slave via streaming replica. I don't want to use streaming replica for OLAP queries ...
Siddharth Prakash Singh's user avatar
2 votes
3 answers
2k views

SSAS How to calculate Standard Deviation

I'm trying to calculate a variety of statistical calculation across a range of data such as Standard Deviation and Average. The data comes from many different "Data sources". These are are held in a ...
Sir Swears-a-lot's user avatar
0 votes
1 answer
43 views

Should I put OLAP and realtime web DBs on the same server?

I have several different workloads I'd like to consolidate into the same Sql 2012/2014 instance. Cognos/OLAP is burst oriented and users are accustomed to a response delay Web databases that require ...
makerofthings7's user avatar
1 vote
0 answers
168 views

SSAS 2014, Relation OLAP - Poor performance, high resource usage, what did I do wrong?

Let me start with the background, I was working on a project that needed a back end that was scalable and fast. Having worked quite a bit with SSAS, I thought I'd try SSAS's in memory solution, ...
Randall's user avatar
  • 121
4 votes
2 answers
3k views

Star Schema from Relational Database

I'm a newbie to data warehousing and I've been reading articles and watching videos on the principles but I'm a bit confused as to how I would take the design below and convert it into a star schema. ...
saj's user avatar
  • 93
1 vote
1 answer
370 views

OLTP to OLAP process causing deadlocks and impacting customers

I should preface this with the fact that I'm a .net developer who has fallen into DBA and performance work because it has become business critical, so I'm missing the DBA skills for this kind of work. ...
C Bauer's user avatar
  • 123