Questions tagged [cube]
Cube objects representing N-dimensional data in an OLAP cube
43
questions
2
votes
1
answer
582
views
SSAS Cube for tracking changes in parent child relationship over time
I would like to build an SSAS cube which tracks how objects in a graph who's edges represent a "belongs to" relationship change over time (daily). There are two components to the change:
which object ...
CommunityBot
- 1
1
vote
1
answer
881
views
How to release SSAS memory without forcing restart
We have a production server with two SSAS instances, 1 for user querying and 1 with empty templates where we do new releases and (full) processing of the cubes (and then backup and restore processed ...
CommunityBot
- 1
20
votes
2
answers
21k
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 ...
- 131
23
votes
2
answers
42k
views
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 ...
- 131
0
votes
1
answer
517
views
Why is MDX Moving Average Calculation Inconsistent in Excel?
This question hurts my brain to talk about. Hopefully I can explain it properly.
I have the following calculation defined in my cube:
CREATE MEMBER CURRENTCUBE.[Measures].[52 Week Comp Net Sales ...
0
votes
0
answers
414
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 ...
1
vote
0
answers
327
views
Why does a GIST index on a cube column in PostgreSQL actually make K-Nearest Neighbor (KNN) ORDER BY queries worse?
Adding a GIST index actually seems to make K-Nearest Neighbor (KNN) ORDER BY queries on cube columns worse in PostgreSQL. Why would that be, and what can be done about it?
Here's what I mean. In a ...
1
vote
0
answers
126
views
Ranking and use of cube by in an SQL query? [closed]
I am a the MSc student who does not understand this following SQL dilemma and want to be certain from an Academic standpoint.
The entire “Foodmart” database can be downloaded from: http://didawiki.cli....
- 78.1k
3
votes
2
answers
253
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 ...
- 70k
1
vote
0
answers
80
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 ...
- 141
3
votes
1
answer
616
views
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 ...
CommunityBot
- 1
-1
votes
1
answer
389
views
Adding templated Date-Time dimension to the cube
I have a database with FactSales table that contains Date column of type I4. I have created a cube and linked dimensions via foreign keys as usual, however, since I have no DateTime table in the ...
- 51.7k
3
votes
1
answer
4k
views
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 ...
0
votes
1
answer
313
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 -...
- 176
0
votes
1
answer
1k
views
DBCC on SSAS Cube fails
DBCC on the Cube fails(SQL version 2014 SP2, 12.0.5000.0).
My XMLA query:
Error message:
Executing the query ...
The DBCC element at line 7, column 88 (namespace https://schemas.microsoft.com/...
- 146
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 ...
- 21
1
vote
0
answers
442
views
How to improve performance of SSRS report using Cubes as data source?
I am trying to build an SSRS report with SSAS as the data source. It has 4 cascading parameters. I used the SSRS Query designer to generate MDX because I am not very familiar with Cubes/MDX.
It works ...
- 11
2
votes
0
answers
53
views
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 ...
- 21
1
vote
1
answer
2k
views
Is processing required dimensions enough or to process the entire cube?
I have four large dimensions and one of the dimension is not going to be changed, also the particular dimension didn't need to be processed.
So, processing the three dimensions individually updates ...
- 15.7k
0
votes
1
answer
1k
views
SSAS Cube Process Manually works but MDX query doesnt work
I am new to SSAS.
Here's a cube which is rebuilt by a SSIS package everyday but it seems to cause duplication. We manually 'Process' the cube using the GUI, it then updates this table with the ...
- 15.7k
1
vote
0
answers
134
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 ...
- 171
1
vote
1
answer
163
views
SSAS Cube Only Displays Total Values
When browsing my cube it shows the correct invoice values by date when I select only a date type (the date table was generated by SSAS with hierarchies), but if I add the customer name it shows the ...
- 1,385
0
votes
0
answers
699
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 ...
- 197
1
vote
1
answer
275
views
SSAS Feature to hold confidential data
I need to use Data Cubes to analyse the Sales Performance. Since the product costs are highly confidential it should not be exposed to the middle management. However, the other information needs to be ...
- 15.7k
1
vote
0
answers
422
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 ...
- 197
0
votes
1
answer
1k
views
SSAS MD dimension joins to same table twice (but processing fails as attribute has 2 names for same ID)
My cube has a product dimension, and each product has an "availability" status attribute. In the database, SellableItemAvailabilityId in DimSellableItemVersion (which contains products) joins to Id in ...
CommunityBot
- 1
0
votes
1
answer
1k
views
How to sum measure value for all records between two dimension values
I have a cube, called metric_cube, with a measure of Metric and a dimension Week with the given output on SSAS from SQL Server 2014.
Current Output:
Week Metric
---- ------
1 6
2 5
3 ...
CommunityBot
- 1
2
votes
1
answer
1k
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'...
- 928
1
vote
1
answer
569
views
Can we have OLAP cubes with same OBJECT NAME and ID at different database?
I have olap database for both production and test. Fortunately I noticed that cube under both production and test olap database has the same object name and Id. But DataSource for production and test ...
- 15.7k
1
vote
0
answers
549
views
How to backup SSIS packages and CUBE Projects from Visual Studio 2013.5?
I'm using VisualStudio 2013.5 to develop SSIS, SSDT and SSAS Cubes (multidimensional and tabular model). I would like to ask you is there a possible to backup SSIS packages and SSAS cubes from ...
2
votes
1
answer
1k
views
Formatting a Measure in SSAS cube
I have a measure that show number in millions / billions.
The formatting of the number for now is like this : "$#,##0.0;-$#,##0.0"
I would like to format the number to show something like this:
...
- 1,385
5
votes
2
answers
5k
views
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,...
- 15.7k
1
vote
1
answer
1k
views
Permissions Error on Member that doesn't exist
My team built an SSAS cube a year or two ago; it was the second cube we've built. We rolled it out to a few teams who have been using it without any issues. Today, I sat down with a new user to set up ...
- 1,385
2
votes
1
answer
3k
views
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 ...
CommunityBot
- 1
3
votes
1
answer
1k
views
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 ...
CommunityBot
- 1
2
votes
0
answers
15k
views
How to check the status of an SSAS cube while it is processing
When one processes an analysis services cube in Sql Server Management Studio, by right clicking on the cube name in the GUI and selecting the "process" option, a GUI pops up and displays the status of ...
- 121
2
votes
1
answer
341
views
Duration measure in fact table
I have a fact table with the user reservations with StartDate and EndDate.
I am thinking what is the proper way of serving the duration queries in the reports. Should I calculate DurationDays and ...
- 67
2
votes
1
answer
6k
views
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 ...
- 9,640
7
votes
3
answers
6k
views
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 ...
- 84.2k
1
vote
0
answers
225
views
Design The Cube Dimension for Group/Member OR "Many to Many" type relationship
I am looking for the right approach how to implement group/member like relationship in the cube dimension. i have attached the smaller version of my tables currently I have. Table-1 is SecurityTable, ...
- 632
6
votes
1
answer
2k
views
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?
CommunityBot
- 1
2
votes
0
answers
32
views
Real-Time SSAS cube status notification [duplicate]
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 ...
CommunityBot
- 1
1
vote
2
answers
6k
views
How do I design a Dimension and Fact Table from a relational database?
I'm new to using SQL Server 2008 R2 SSAS. I have the following tables in my database, that I wish to model using SQL Server Analysis Services:
Table1
ServiceTypeID | ServiceTypeName
-------------...
- 750