How could I display the sum of quantity from the fact table FacturesAvoir for each requestNo from the table F_demande_Achat?
How could I display the sum of quantity from the fact table FacturesAvoir for each requestNo from the table F_demande_Achat?
Solution
You'll need to set up a dimension that includes the three "F_" tables, and then link that dimension to the Measure Group that uses FacturesAvoir as its source.
- Changing SQL Server DB from tabular to multidimensional
- How to refresh analysis service database using Powershell
- How to revoke login/connection access to SQL Server Analysis Services (SSAS)
- GENERATESERIES function for calendar with hour interval not working as intended
- 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?