AXISHK
asked on
SQL Query on AS
Under Cube Designer --> Dimension Usage , click the intersection of Product and Product Forecast to show the attached relationship.
For the Granularity attribute "Subcategory", is it equivalent to ProductSubcategory key in Dimension column but it has been renamed to "Subcategory" ?
Tks
SQL-AS.png
For the Granularity attribute "Subcategory", is it equivalent to ProductSubcategory key in Dimension column but it has been renamed to "Subcategory" ?
Tks
SQL-AS.png
You have said that that is the intersection of Product and Product Forecast. It appears to be the intersection of the Subcategory dimension and the Forecast measure group table instead.
ASKER
Sorry, should be ProductForecast (Fact table) & ProductSubCategory. So for the Granularity attribute "Subcategory", is it equivalent to ProductSubcategory key in Dimension column but it has been renamed to "Subcategory" ?
Tks
Tks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks