• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 135
  • Last Modified:

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
0
AXISHK
Asked:
AXISHK
  • 2
  • 2
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
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.
0
 
AXISHKAuthor Commented:
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
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Yes, probably. You will find that something, probably ProductSubcategoryKey, has been renamed in the Dimension.

You are currently in Cubes - go to Dimensions in Solution Explorer and explore either the dimensions labelled Product - it depends on how it has been set up. Anyway, in Attributes, you will find that something has been renamed as Subcategory.

Click on that attribute, and have a look at its Properties, specifically Source - KeyColumns.
0
 
AXISHKAuthor Commented:
Tks
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now