2022 Developer Survey is open! Take survey.

Hot answers tagged

7 votes
Accepted

Cube with 2 measure groups (with different relationships to dimensions) returns too many dimension members in reports

As you correctly noted this is what happens when you try to display measures across a dimension to which they don't have a relation. You basically have 2 options Use IgnoreUnrelatedDimensions Use an ...
user avatar
  • 15.4k
5 votes

Is processing required dimensions enough or to process the entire cube?

I think you are confusing things. First of all, processing the cube and processing the dimensions is sort of separate. I think you mean "processing the entire database". If you process only ...
user avatar
  • 15.4k
5 votes

CUBE and calculating the number of dimensions

It seems like the "hierarchical dimension"s example given as (year, month, week) is treated really the same as 3 independent dimensions - all 8 possible combinations are allowed - that ...
user avatar
  • 6,582
3 votes

CUBE and calculating the number of dimensions

Welcome to DBA.SE. The question is more of a mathematical problem, than a database one. It might be better suited on a different site. However, 8 ^ 4 = 4096. Or the CUBE (3-level aggregate) to the ...
user avatar
  • 14.9k
3 votes
Accepted

Formatting a Measure in SSAS cube

Please try this format string: 0,,.0 \M $ This trick is a bit buried in the documentation.
user avatar
  • 1,365
3 votes
Accepted

Permissions Error on Member that doesn't exist

In SSMS if you open each role and find the Measures Dimension Data security section then go to the Advanced tab (if you have trouble finding it see this blog for screenshots from the same screens in ...
user avatar
  • 1,365
3 votes

How to optimize performance for dimension attributes?

MSDN states: The value of the AttributeHierarchyEnabled property determines whether an attribute hierarchy is created. If this property is set to False, the attribute hierarchy is not created and ...
user avatar
2 votes

Can we have OLAP cubes with same OBJECT NAME and ID at different database?

Every object has a Name and ID property that must be unique within the scope of the parent collection. For example, two dimensions can have same name as long as each one resides in a different ...
user avatar
  • 275
2 votes
Accepted

SSAS : An error occurred when instantiating a metadata object

The solution was removing the empty files E:\MSAS11.DWH_AS\OLAP\Data\Cube Fraude.0.db\MY_DATABASE OLAP.56.cub.xml which allowed the aggregation to continue
user avatar
  • 9,478
2 votes

Cube with 2 measure groups (with different relationships to dimensions) returns too many dimension members in reports

Add this calculated measure to the cube: Create Member CurrentCube.[Measures].[Max Current CP With Units] as IIf(Not IsEmpty([Measures].[Units]),[Measures].[Max Current CP],Null);
user avatar
  • 1,365
2 votes
Accepted

SSAS Feature to hold confidential data

This is an overly broad question but SSAS has security features that allow you to shield data for certain users. You should look into Roles and Permissions. Since you are talking about shielding ...
user avatar
  • 15.4k
2 votes

The following system error occurred: No mapping between account names and security IDs was done

from the SQL management studio, connect to Analysis services and go to Roles, under the roles, the user that has been removed from active directory will appear in question marks "????????????????" , ...
user avatar
  • 2,756
2 votes

SSAS Cube Process Manually works but MDX query doesnt work

If you want to make sure the code you are running is exactly the code run when you process manually you should click the script button in SSMS and use that XMLA script. If you execute a series of ...
user avatar
  • 15.4k
2 votes

Have several 128 elements lists, need to obtain distance between them

I can not save them as a list of floats, since i get: "can't adapt type numpyndarray" Quick google search shows numpyndarray as being SciPy's "N-dimensional array". This can hold what PostgreSQL ...
user avatar
  • 55.7k
1 vote
Accepted

SSAS Cube Only Displays Total Values

The Customer dimension is joined to the measure group at a non-key granularity. If the Customer Name attribute isn't related to the attribute you join on then data repeats in reports. You need to do ...
user avatar
  • 1,365
1 vote

SQL to MDX translation?

Mondrian is indeed a good example, in that it's a ROLAP engine (in which MDX statements are translated to SQL which are then fired to the underlying database (other than it caches results, so ends up ...
user avatar
  • 176
1 vote
Accepted

DBCC on SSAS Cube fails

Did you read the rest of the docs? Output when running DBCC against an earlier version of Analysis Services DBCC is only supported on databases running on a SQL Server 2017 instance. ...
user avatar
  • 146
1 vote

How to sum measure value for all records between two dimension values

First you need two cube-dimensions because you cannot use one dimension on more than one axe of a MDX-select. You can use role-playing dimensions, that means there is only one "Week" dimension in the ...
user avatar
1 vote

SSAS MD dimension joins to same table twice (but processing fails as attribute has 2 names for same ID)

You have a product dimension using all 3 tables. The dimension key is DimSellableItemVersion.SellableItemId and you can use SellableItemAvailability.Id two times as an attribute, once for the product ...
user avatar
1 vote

MDX Intersection - how to?

You just need to add an MDX where clause. Look at the Basic MDX syntax. In that where you need to specify the SET to slice on. Have a look at Using Sets in MDX Queries SELECT NON EMPTY { [Measures]....
user avatar
  • 15.4k
1 vote

Duration measure in fact table

You should calculate this during your ETL process or create a calculated column on your fact table. Then, aggregations will be easier and queries will be somewhat faster than calculating the values ...
user avatar
1 vote
Accepted

Cube processing either takes too long or fails

Oh my dear.. First of all. In your case I would like to suggest you to choose the "Process Default" option. If you are using Process Full always you are dropping all data and objects and recreating ...
user avatar
  • 201

Only top scored, non community-wiki answers of a minimum length are eligible