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

Issues in expand/collapse in Excel using MSSAS

I am trying to browse a cube in Excel. When i try to expand the year dimension all 4 quarters displays well, but when i drill down further i got some display issues described as below, although the response which I am getting of the MDX query is…
Ankit S
  • 75
  • 2
  • 11
-2
votes
2 answers

How to see how many people are accessing a ssas cube?

I wanted to know how many people are accessing a particular ssas cube. Please let me know the process to find them.
Sharath Reddy
  • 1
  • 1
-2
votes
1 answer

Excel Cubes - OLAP?

I am not sure if this is possible but I have a very large data set (extracted using Microsoft SQL Server Management Studio) and would like to import this into some sort of cube (OLAP?) to be analysed in Microsoft Excel (Pivot tables etc.) which is…
Kajan
  • 45
  • 2
  • 9
-2
votes
1 answer

How to create date dimension with decades in SQL Server?

I want to create a date dimension for an OLAP cube, which have to use Russian dates format and include decades (like 80s, 90s, etc.). How do I do that?
k1lly
  • 17
  • 6
-2
votes
1 answer

Make parser for CSV file to get tons of data

I got some work to extract data from a big CSV file. It has a lot data related to articles and publishers. So I want to make a parser for it in Java to make a data warehouse and show this data in OLAP. Can anyone tell that how can I get started with…
Sohaib Malik
  • 1
  • 4
-2
votes
1 answer

How I can get data from a Olap Cube in Excel C# Addin

I have an SSAS 2012 cube and I need create an excel addin for get data from cube and show it in a pivot table. What code I need for create pivot table with connection to olap cube.
Juanchoweb
  • 1
-3
votes
2 answers

Get data from olap cube in c#?

What is the best solution to get data from an olap cube?
lex87
  • 1,276
  • 1
  • 15
  • 33
-3
votes
1 answer

Discover Cube Error befor Production Phase

Goal: Apply a fresh deployed cube in the production environment. Problem: How should I enable to discover any problem in the cube when it is updated automatic once a week before it will be applied in the production phase? Information: In this…
HelloWorld1
  • 13,688
  • 28
  • 82
  • 145
-4
votes
1 answer

MySQL:Trying to run CUBE query -> Error in your sql syntax | LIMIT 0,25

I have query in my structure trying run in PHPMYADMIN. I am trying to run CUBE query for OLAP operation, this is my query : SELECT QUARTER, REGION, SUM(SALES) FROM salestable GROUP BY CUBE (QUARTER, REGION) I have also tried this query : SELECT…
stephen salvatore
  • 5
  • 4
-4
votes
1 answer

referenced relationships sql server analysis Services, How can i create it

enter image description hereI'm beginner in SSAS, actually I work on SSAS Olap cube I have an issue which is I can not add customer fields to charge dimension or to charge fact (to be displayed on power bi ) Thank you in advance
Djaber T
  • 3
  • 4
1 2 3
…
54
55