You are correct unfortunately. Working with our dw team to see if they can snowflake there. Or create a new star.

And we have many aggregrates for that logical fact table. I remember something around you cannot fragment where there are multiple aggregates under the LTS

Fragmentation does not work from the perspective of time slice. But perhaps fragmentation by a subquery of a certain disinct set of cusomer ids. Not sure if this is feasible and works or how. But a thought I am going to entertain. Thoughts>

Thanks - yes, this seems pretty buggy to me as well. Will do

Actually what is happening when I did add the additional single Key and uncheck the display flag on the multi-key and apply it to the single key. It removes the warning after saving. However, once I close the RPD and reopen it. And recheck consistency. The display flag now is checked on both keys and 2 warnings are now for…

Thanks! I will try this out

Thank you for your response. But your answer does not pertain to the question per se. We do have a table in a database that contains the user and the ids. What happens is that some users have access to all the ids which are rows in that table. We do not want to inject all those ids in a where clause. We also do not want to…