ssasssas-2008
SSAS Distinct sum for connected Fact Table
I have 2 Fact tables with relations Fact Flight 1:many Fact Cost. Also I have separate dimensions for Fact Flight and Fact Cost. I want to make Fact Flight measures to be filtered by Fact Cost dimensions and vice versa. Is it possible in SSAS?
Solution
As I described these facts are connected 1-many. I resolved it adding connecting dimensionality using the connecting key: Regular for Fact Cost and Fact for Fact flight.
- SSAS Tabular Model - Partition Refresh and Schedule
- OLEDE Error: Login failed for user 'DOMAIN\ComputerName$'.;28000
- Why are multidimensional models not supported in Azure Analysis Services?
- DAX script for measure based on date dimention
- Exclude attribute value by default in SQL Server Analysis Services Tabular Model
- Can't add members to SSAS role through Visual Studio
- Power BI calculate Measure for previous working day
- User doesn't have permission to call the Discover method
- SSIS Cube process fail
- Cannot find SQL Server Analysis Services in SQL Server 2012 Management Studio
- "string was not recognized as a valid datetime" when building schema with wizard
- Measure DAX formula with SWITCH
- Is it possible to use the value from a table column as the text of a DAX formula for measure?
- MS SSAS MDX Ensure UI (E.g. Excel) shows the latest member of a dimension on refresh
- Visual Studio tabular cube: an M partition uses a data function which results in access to a data source different from those defined in the model
- C# amo get roles complete
- MDX function to find if a Member IsMemberOf a set
- Power BI - Find the % matching What-if analysis before and after
- Connect an on-prem SQL Server Analysis Server Tabular Model with Azure Data Factory
- My SQL Server Analysis services won't switch from tabular to multidimensional
- Aggregating Members calculated with IIF / CurrentMember conditions
- How to calculate a YTD based on the Month short
- MDX for concatenated dimension level based on result of another calculated member in cube design
- Refresh SSAS post ETL Process job
- Write MDX / DAX on azure analysis services and copy data to azure data warehous using ADF
- How to create Analysis Services Multidimensional Project template in Visual Studio 2019?
- SSAS/Power BI Row Level Security
- PowerShell script to refresh tabular cube on Azure
- DAX FILTER function with multiple criteria
- How to take MDX Query from SSAS Multidimensional Cube and Use To Build Power BI Report?