A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

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
1answer
273 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 ...
2
votes
0answers
8k 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
483 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
451 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
245 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
23 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
114 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
219 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
416 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
217 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
10 views

Data Cube Design

I have a reporting system with many entities. I will limit this to two, players and teams, in this question, but there are actually many more. Both players and teams have many plays. The reports are ...
0
votes
0answers
16 views

Building a data cube in a data warehouse through Inmon architecture?

I have been reading about data cubes and Kimball. Through building a star schema, one can then model a cube using its measures and dimensions of the star schema. But then there is a different data ...
0
votes
0answers
18 views

Changing Cube Max Dimension

thanks in advance for any help. Python/postgres noob here. I need to change the default dimension for cubes in postgres. I tried to download source code, fixing the cubedata.h file to change max ...
0
votes
0answers
201 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
463 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
147 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
227 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 ...