Forum Discussion
problem with relation between table (newbie)
i have relation like these. In table projectdata I canuse related to salesName but I cannot use related to projectsubdata (I try to typing but it show nothing ) And second problem ...
Hi, Anonymous
You need to follow the star schema or snowflake schema in your data model. In your case you probably have more than 1 fact tables. In order to get correct results it is good to follow it. You can use LOOKUPVALUE instead of RELATED but this will not be a solution and maybe will cause some issues with data.