When the Dimension Table Does not have Data and Present is Fact Table : Show N/A or Unknown
Nagati PraveenKumar
1
Reputation point
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,344 questions
Sign in to answer