Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [cube]

Cube objects representing N-dimensional data in an OLAP cube

For PostgreSQL see the cube extension.

43 questions
23
votes
2 answers

What are Measures and Dimensions in Cubes

I'm new to Microsoft SQL Server Business Intelligence and Analysis Service (but I've been programming for years with SQL Server). Can any one describe Measures and Dimensions in Cubes in simple words (If it's possible with images)?
DooDoo
  • 203
  • 1
  • 3
  • 13
20
votes
2 answers

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 to start. My question are: What is difference…
Rathish Kumar B
  • 2,320
  • 5
  • 24
  • 36
7
votes
3 answers

Cube processing either takes too long or fails

I have a SSAS Cube with 35 dimensions and 10 measures. Some of the dimensions are quite large in size. In almost all dimensions data either get updated and inserted. Measures have high volume of data. When I run from SSMS (by right click on SSAS…
Zerotoinfinity
  • 761
  • 3
  • 13
  • 27
6
votes
1 answer

How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?

Apparently this feature was available in previous versions but has now been removed. What are some alternatives?
Sarah
  • 61
  • 2
5
votes
2 answers

Cube with 2 measure groups (with different relationships to dimensions) returns too many dimension members in reports

I have a cube that contains stock-take data from retail operations. It has 2 measure groups - one containing the number of stock units counted in each stock-take batch (which is related to the Product, Batch and Time dimensions), and another…
Laurence
  • 315
  • 2
  • 12
3
votes
2 answers

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 with n dimension in which none of dimension…
Betty Andersson
  • 31
  • 1
3
votes
1 answer

Have several 128 elements lists, need to obtain distance between them

Is storing them in a CUBE type field and then getting euclidean distance, (using <->) the only way? I can not save them as a list of floats, since i get: "can't adapt type numpyndarray" Can not cast a type bytea to type cube, either. Cube extension…
misterghost
  • 41
  • 6
3
votes
1 answer

The following system error occurred: No mapping between account names and security IDs was done

While trying to Process a cube i go this error "Error 133 The following system error occurred: No mapping between account names and security IDs was done. 0 0" i know its some user which is available in the roles have been removed from…
AmmarR
  • 2,826
  • 3
  • 28
  • 33
3
votes
1 answer

MDX Intersection - how to?

A similar question has been asked here, but I'll give a brief intro. In SQL Server there are 3 tables: Order (Id, Date); Product (Id, Name); OrderRefProduct (Id, OrderId, ProductId); OrderRefProduct is a many-to-many table since one product can be…
Oleksii Ignatiuk
  • 31
  • 3
2
votes
1 answer

How to optimize performance for dimension attributes?

I'm looking to enhance the cube processing time and someone suggested me to set "AttributeHierarchyEnabled='False'" for attributes which were not used at user defined hierarchies but I'm not clear with the "AttributeHierarchyEnabled" property and…
RajeshKannan
  • 163
  • 2
  • 9
2
votes
1 answer

SSAS : An error occurred when instantiating a metadata object

Aside from installing SSAS, I have no experience using it. Our developers are saying that it is no longer possible to create a new aggregation, whatever the cube. The error occurs when hitting Start. Here is what I found in the msmdsrv file Type:…
user4659
2
votes
0 answers

Real-Time SSAS cube status notification

Possible Duplicate: Real Time SQL Server Analysis Services Cube Processing Report I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services cubes are processing using SQL Server Reporting…
ObinnaJuan
  • 61
  • 1
  • 3
2
votes
0 answers

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 Excel. In these clients I am able to run custom DMX…
matt
  • 21
  • 3
2
votes
0 answers

What is the "Optimize Response" connection string attribute used for?

My apologies if this is not the correct forum to be asking this in. I am having trouble finding information regarding the "Optimize Response" connection string attribute. The most promising source of information I have found is here, but it doesn't…
djbzrms
  • 21
  • 1
2
votes
1 answer

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've concluded that there are three types of cache…
Stavros Koureas
  • 170
  • 1
  • 13
1
2 3