Using "Fact" Relationship Type on the "Dimension Usage" tab in a SSAS OLAP cube

ssas relationship olap dimension fact-table
Mike Larke picture Mike Larke · Nov 8, 2011 · Viewed 7.5k times · Source

I was hoping someone could explain the appropriate use of the 'FACT Relationship Type' under the Dimension Usage tab. Is it simply to create a dimension out of your fact table to access attribute on the fact table itself?

Thanks in advance!

Answer

Kenneth picture Kenneth · Nov 8, 2011

Yes, if your fact table has attributes that you would like to slice by (create a dimension from), you would use this relationship type.

Functionally, to the users it behaves no differently than a regular relationship.

Related questions

SSAS One to Many Dimensional Relationship

Question in SSAS for y'all. I am attempting to define a One to Many relationship in an OLAP SSAS cube environment. However, i'm running into problems with defining a primary key. Example tables are below. Relationships between the first 3 tables …

Read More
"Duplicate attribute key" error when attribute is not a key

I am getting the following error when processing a Dimension: Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Orders', Column: 'Project', Value: 'client service stuff'. The attribute is 'Project'. 'Project' is …

Read More
SQL Server 2012: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000

I am using Analysis services in Microsoft SQL Server 2012 on Windows 7. I tried to create Mining models and process it. I am getting the following error while processing it. OLE DB error: OLE DB or ODBC error: Login failed for …

Read More