The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
23 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 ...
1
vote
0answers
115 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
11 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
13 views

Array of string in MDX

I have a dimension attribute that has composite key, such as CalendarQuarter in this post. This means my attribute members will have members that can be written as: ...
0
votes
0answers
72 views

User-mapped Error processing SSAS cubes

I'm receiving the following error message intermittently whilst attempting to process an SSAS cube. I've changed the SSAS memory parameters as per this link, but am still intermittently recieving ...
0
votes
0answers
48 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 ...
0
votes
0answers
11 views

create siblings ssas

If you have a parent-child dimension how can the power users easily create new level in the hierarchy? In SSAS is the posiblity to enable WriteBack and easy create new child and new sibling. Can you ...
0
votes
0answers
110 views

Problem in Incorporating filters into Data Warehouse design

While implementing a data warehouse (proof of concept) I have a requirement to incorporate a user level save-able filter on dimensions. The requirement is a proof of concept so I have the liberty to ...