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
2
votes
1 answer

Non-Additive Fact

I have a Fact Table with 10 measures. out of 10 measures 9 are aggregated at Sum level.But I have Unit Price which is a Non-Additive Fact Measure.When I go to the property of Aggregation and make it none it does not work in SSAS and gives NULL…
ace_mccloud
  • 497
  • 1
  • 8
  • 25
2
votes
2 answers

Best method to upgrade atoti version?

I was trying to import atoti to my jupyterlab as import atoti as tt I encountered the below problem. Exception Traceback (most recent call last) in ----> 1 import atoti as…
Raghav Vashisht
  • 81
  • 4
2
votes
1 answer

SSAS - cube filtering on import

I am new to SSAS and after trying for hours to solve this problem I asking here. I have a msOLAP cube that I want to import into SSAS PowerBI but due to large database I want to pre-filter it befor importing. The cube has measures in cpe_fact table…
Hi Cohen
  • 21
  • 2
2
votes
0 answers

MDX Calculated Member on Fact Dimension

I have written below query to get count of job numbers from a fact dimension. It is working fine. WITH SET V_Lots AS {[ABC Lots].[ABC Type].&[A] ,[ABC Lots].[ABC Type].&[O]} * {[ABC Lots].[ABC Load Nbr].[ABC Load Nbr]} MEMBER …
Arjun
  • 1,049
  • 6
  • 23
  • 37
2
votes
0 answers

How does one compare different versions of MSMDPump.dll?

I am trying to implement MSMDPump.dll on my web server to allow my users to connect to several cubes I have on a SSAS server. I was reading this article and it says I need to pull that file from (< drive >:\Program Files\Microsoft SQL…
Cody
  • 161
  • 7
2
votes
3 answers

OLAP Cube Calculation for Last Year Comparison on Week Day - MDX

I want to compare actual sales values with sales values of last year. The difficulty in this comparison is the compliance of the week days and thereby of the leap-year. Example on day level: 2016-02-04 (thursday): actual sales: 580,- last year…
Alexo
  • 131
  • 4
  • 15
2
votes
0 answers

Can we have MS Sql Server as data source for Druid for data loading?

Can we have MS Sql Server as data source for Druid for data loading. If not what is the best possible way for data ingestion to Druid from MS SQL Server? We actually need to create data cubes using Druid currently our database is MS SQL server. What…
Vishnu
  • 93
  • 1
  • 5
2
votes
2 answers

Multi-dimensional data processing alternatives

I am looking for a multi-dimensional data processing but without having to use any OLAP. For example, I have a table of sales transactions. I would like to have the total sales on many dimensions like Product, State, Region, Time (monthly,…
Sathya
  • 2,371
  • 5
  • 19
  • 27
2
votes
1 answer

How to create OLAP cube using azure data lake store?

I have 3 csv data sets. I want to create an OLAP cube so that it creates a schema joining all the 3 data sets. How can we do it in Azure? Can we use Azure data lake for this?
vasanth kumar
  • 21
  • 2
2
votes
0 answers

SSAS OLAP create a dimension with dynamic attributes

It is possible to create a dimension in a OLAP cube where the attibutes of this dimension are dynamic? For instance, today I can have the attibutes A | B | C | D and tomorrow I can have the attibutes A | B | C | D | E. Thanks in advance!
Ricardo Castro
  • 157
  • 13
2
votes
2 answers

Server: The operation was cancelled because of locking conflicts (Analysis Services)

I have a report application that is connected to an Olap cube in Analysis Services and every time that the application query the cube while the cube is processing I'm getting these errors: 1-Server:The operation was cancelled because of locking…
JC_BI
  • 419
  • 1
  • 5
  • 16
2
votes
0 answers

Is there any OLAP Library for SQLite in .Net?

I would like to know is there any OLAP libray for SQLite? which will allow me to create CUBES dynamically. Thanks, Omky
Omkar
  • 2,129
  • 8
  • 33
  • 59
2
votes
3 answers

How are OLAP-cube operations and MDX related?

I would like to understand how OLAP-cube operations (i.e. drilling up/down, slicing/dicing and pivoting) and MDX are related. My current guess is that OLAP-cube operations to MDX are like relational algebra to SQL. However, I do not see how some…
AlwaysLearning
  • 7,257
  • 4
  • 33
  • 68
2
votes
0 answers

HOWTO implement OLAP cube queries into PHP MYSQL browser App

We developed a browser app written in PHP and MYSQL using the Smarty template. The data is similar to sales data and can be stored in a OLAP cube format. Now we would like to offer inside the App a menu for certain users to analyze the sales data…
Bombur312
  • 21
  • 1
2
votes
1 answer

How to do filtered aggregations by a filter field in olap cube?

Currently I have one field in a SQL DB table called Amount. This field will be used in a Reporting Services report that uses SSAS OLAP Cube behind to display the winners and the payments. The column payment of the report must use this field (I mean…
José Amparo
  • 79
  • 5
1 2 3
…
54 55