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
-1 votes
1 answer
64 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
42 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
57 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
375 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
1k 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
56 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
211 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
2 votes
2 answers
924 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
  • 161
0 votes
1 answer
70 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
363 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
72 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
419 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
70 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
125 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
130 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
399 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
80 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
19 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
  • 457
1 vote
0 answers
857 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
285 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
  • 457
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
131 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
651 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
27 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
503 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
113 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
384 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
19 votes
2 answers
20k 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
1k 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
86 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
255 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
323 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
963 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
358 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
42 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
157 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
1 answer
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
349 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
2 votes
2 answers
3k views

SSAS where are olap cubes stored

Getting started on creating data cubes with SSAS. I understand the various types of OLAP options ROLAP, HOLAP and MOLAP. However, when creating a data cube using SSAS (at least for 2008 version) I do ...
user275157's user avatar
1 vote
1 answer
117 views

SQL Server Table Design for Report - Is OLAP Schema Suitable

A work colleague is developing SQL Server database tables for a reporting project. Basically, the only activity on the table will be populating it from a ETL process (SSIS). He insists on creating a ...
K09's user avatar
  • 1,394
1 vote
0 answers
289 views

Is it possible to use Hibernate for OLAP-server?

I have a PostgreSQL database with Java Hibernate. I need a XMLA datasource for a pivot grid client component. Is it possible to use Hibernate for a OLAP-server? Which OLAP-server does support ...
Spenhouet's user avatar
  • 111