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.

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.

· 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?


0 Votes 0 ·

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

0 Votes 0 ·

0 Answers