All Questions
Tagged with cube sql-server
15 questions
1
vote
1
answer
1k
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 ...
- 11
0
votes
0
answers
451
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
132
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....
- 11
3
votes
2
answers
273
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 ...
1
vote
1
answer
297
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 ...
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 ...
- 2,816
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 ...
- 315
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,...
- 315
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 ...
- 169
2
votes
0
answers
16k
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
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 ...
2
votes
1
answer
360
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 ...
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 ...
- 163
1
vote
1
answer
587
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 ...
- 163
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 ...
- 203