Stack Overflow
Stack Overflow

Questions tagged [olap-cube]

An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.

An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.

An OLAP cube is a method of storing data in a multidimensional form, generally for reporting purposes. In OLAP cubes, data (measures) are categorized by dimensions. OLAP cubes are often pre-summarized across dimensions to drastically improve query time over relational databases. The query language used to interact and perform tasks with OLAP cubes is multidimensional expressions (MDX). The MDX language was originally developed by Microsoft in the late 1990s, and has been adopted by many other vendors of multidimensional databases.

820 questions
4
votes
2 answers

Analytics in Elasticsearch

I am working with Analytic of events, I use hadoop to process the logs and store some results in Mysql. This did not work now due to scalability issues as logs are keep coming daily. We need to show stats per year, month, week, day, hour along with…
maaz
  • 4,371
  • 2
  • 30
  • 48
4
votes
1 answer

MDX Column Alias for use in SQL

I'm trying to query our SSAS cubes and return the values into a SQL view for use as parameters in cube based reports. I need to return 3 values for financial seasons based on the date hierarchy. This is the below code, which returns the correct…
Will Wainwright
  • 322
  • 5
  • 14
4
votes
1 answer

SSAS: Errors in the OLAP storage engine: The attribute key cannot be found when processing

In my searching, I have seen this error text been asked in different contexts, but specifically, I want to know if I am missing something here. In a basic setup, I have 1 measure table and 1 dimension table in my DSV. In my test, the measure table…
Warren
  • 1,984
  • 3
  • 29
  • 60
4
votes
2 answers

How to determine if current User is SQL Server Analysis Server Admin

I'd like to scope some cells to particular values if the current user is an SSAS admin. I'm not sure where I'd even begin to determine that kind of introspection. Any ideas would be welcome please. Note that I'm using UDM and not Tabular models
Preet Sangha
  • 64,563
  • 18
  • 145
  • 216
3
votes
1 answer

Exponential moving average in MDX

I have bellow output of cube date value ---- ----------- 2021-01-06 10 2021-01-07 Null 2021-01-08 Null 2021-01-09 15 2021-01-10 18 2021-01-11 25 My question is, how can I create exponential moving average with…
Mohammadreza Khedri
  • 2,523
  • 1
  • 11
  • 22
3
votes
0 answers

SSAS List roles and dimension permissions (RLS) from Analysis Services

I'm trying to get all the roles from Analysis Services and their dimensions permissions. I have already been successful, managing to extract users and their roles, however I have not found anywhere if it is possible to extract permissions by…
Guilherme Matheus
  • 573
  • 10
  • 30
3
votes
1 answer

Transaction lifecycle tracking in data warehouse

How do you store facts within which data is related? And how do you configure the measure? For example, I have a data warehouse that tracks the lifecycle of an order, which changes states - ordered, to shipped, to refunded. And for a state like…
M.R.
  • 4,737
  • 3
  • 37
  • 81
3
votes
1 answer

Is it possible to hide the (All) Level for Attribute Hierarchies in SSAS Tabular model

In SSAS multidimensional model the (All) level is an optional level of hierarchy and it is a system-generated level. It contains only one member whose value is the aggregation of the values of all members in the immediately subordinate level. It is…
user1523087
  • 149
  • 2
  • 10
3
votes
1 answer

How to access Olap-Cubes from R on Linux

I want to access an Olap-Cube from R on Linux. Specifically I have a SQL-Server 2016 with Analysis Services and Cubes that I would like to access. We have been accessing the cubes from R on windows using microsoft R and the olapR-package. And while…
fulz
  • 41
  • 8
3
votes
1 answer

SSAS OLAP Cube - Sum measure only works when keys are present

(This is a mock of my actual setup to help me figure out the problem.) I have one fact table and one dimension table, linked by an id field. My goal is to make a measure that sums up all "thing_count" (integer) values in my cube. If the user…
Lil' Bits
  • 898
  • 2
  • 9
  • 24
3
votes
1 answer

R data cube define hierarchy

I have some problems with the OLapCube package, data.cube: install.packages("data.cube", repos = paste0("https://", c( "jangorecki.gitlab.io/data.cube", "cloud.r-project.org" ))) Some test data: library(data.table) set.seed(42) dt <-…
Markus Hein
  • 63
  • 4
3
votes
2 answers

The requested operation could not be performed because OLE DB provider 'MSOLAP' for Linked server 'SSAS' does not support the required interface

I am getting this error when I try to update a cube using the linked server: Msg 7390, Level 16, State 2, Line 20 The requested operation could not be performed because OLE DB provider "MSOLAP" for linked server "SSAS" does not support the…
Sreepu
  • 123
  • 1
  • 1
  • 14
3
votes
2 answers

Query returning only the leaf nodes from SSAS Cube using MDX

I have a requirement to list out the parent levels of the resultant leaf node into their corresponding columns into a single row. The below query return the expected result SELECT NON EMPTY { [Measures].[Value] } ON COLUMNS, NON EMPTY {…
asb
  • 781
  • 2
  • 5
  • 23
3
votes
1 answer

Slow SSAS cumulative sum calculated measure

I have a cumulative sum of a measure structured as: Aggregate ( { NULL : [Date].[Year - Month - Date].CurrentMember } ,[Measures].[Applications] ) From the date of the first application to the current date, the days of the date range must…
samb0x
  • 185
  • 15
3
votes
2 answers

How to structure/implement multidimensional data / data cube

I've been reading into what a data cube is and there are lots of resources saying what it is and why (OLAP/ business intelligence / aggregations on specific columns) you would use one but never how. Most of the resources seem to be referencing…
diplosaurus
  • 2,538
  • 5
  • 25
  • 53
1 2
3
…
54 55