Questions tagged [cube]

Cube objects representing N-dimensional data in an OLAP cube

17 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
10k 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 ...
2
votes
1answer
513 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 ...
1
vote
0answers
11 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 ...
1
vote
0answers
781 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 ...
1
vote
0answers
312 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 ...
1
vote
0answers
27 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 ...
1
vote
0answers
118 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 ...
1
vote
0answers
276 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 ...
1
vote
0answers
443 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 ...
1
vote
0answers
218 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, ...
0
votes
0answers
14 views

SSAS : how to disable grouping in “Age” property of a fact?

In SSAS, I have: the dimension ANESTHESIT, which has the key ID the fact PATIENT, which key is ID and has a field PAT_ANESTHESIST that is used in a relationship between ANESTHESIT and PATIENT(the ...
0
votes
0answers
65 views

SSAS cube processing failed: File system error: Insufficient system resources exist to complete the requested service

Have a mysterious problem with SSAS, may be related to SSAS itself or to PKWare Smartcrypt TDE that we have installed on the server. PKWare should encrypt the data for all users outside the domain, ...
0
votes
0answers
49 views

Can't attach SSAS/cube database

Due to running out of disk space, I wanted to transfer 1 SSAS database (cube) to another disk that I connected. In MS SQL, I am trying to detach and attach a SSAS database that I have just moved to a ...
0
votes
0answers
369 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 ...
0
votes
0answers
478 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
0answers
149 views

Which is the best way for selecting dimension attributes while creating a dimension?

I'm a newbie to SSAS OLAP so please apologize me if it was a silly question but surely I need suggestions. I would like to make clear some concepts which was confusing for me. Let us consider five ...
-1
votes
1answer
295 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 ...