question

PraveenNagati-9397 avatar image
0 Votes"
PraveenNagati-9397 asked CarrinWu-MSFT commented

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

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
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PraveenNagati-9397, welcome to Microsoft Q&A! What is the relationships for you cube? You should check the relationships first. If the relationships is correct, have you do full process cube before?

136546-screenshot-2021-09-30-152753.png


0 Votes 0 ·

Hi @PraveenNagati-9397, we have not get a reply from you, any update for this thread?

0 Votes 0 ·

0 Answers