Forum Discussion

PoweredOut's avatar
PoweredOut
Resolver I
3 years ago

Dimension Table Issues

Good morning

 

I am having some issues with my dimension tables. I have multiple dimension and fact tables. All relationships from the dimension tables to fact are one to many. 

 

I'm doing a lot of testing on my dataset as it's being used in many different reports. So I have from the DIM Date table 2023 chosen in the page filter just to check a small amount of data. When I start building a table with another DIM table lets say Category. Not all categories are shown, when I remove the year filter, all categories show. At this point I haven't even added any measures to the table.

 

In a real report, I need to choose Category first and then Date slicer to be able to access all categories. I went through all relationships and they are all set up in a Star Schema

 

I find this wierd behaviour or maybe I'm missing something?

 

Thank you

1 Reply