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 ...
- 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 ...
- 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 ...
- 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 ...
- 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.
- 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 ...
- 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 ...
- 131
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 ...
- 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
- 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);
- 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 ...
- 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 "????????????????" , ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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. ...
- 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 ...
- 105
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 ...
- 105
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]....
- 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 ...
- 67
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 ...
- 201
Only top scored, non community-wiki answers of a minimum length are eligible