The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
81 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 ...
1
vote
1answer
261 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 ...
0
votes
1answer
16 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 ...
1
vote
0answers
54 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
819 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 ...
1
vote
0answers
180 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
8 views

Set filter in a DataCube SQL Server

I have a datacube with several dimensions. I need to filter the data in one dimension so that only the data will be shown in the cube that matches the filter. I know normally I would do this for ...
0
votes
0answers
110 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 ...
0
votes
0answers
206 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
98 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 ...