When the Dimension Table Does not have Data and Present is Fact Table : Show N/A or Unknown

Nagati PraveenKumar 1 Reputation point
2021-09-30T04:29:48.87+00:00

Hi All,

In a Tabular Cube, Fact table contains the values of Product line, where the Product Line dimension doesn't have the related column.

Ex:
in Product line Dimension

Work Line is the column and its not present in the Dimension , but in fact table the quantity /Revenue for Workline is present. i need to shown this type of revenue values as N/A or Unknown in Product line table.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions