Excellent, thanks!!!

Yes, you are totally correct! I did "know", but I had forgotten through long habit... I usually model physical first and then logical. My only action on the logical is typically to create the logical join fact to dimension, and on rarer occasions overrule the default on the join created. As such I fear I had forgotten the…

To expand; - to resolve go to the PHYSICAL layer and look at the physical joins created there. If any are NOT fact to dim (Fact -> Dim) then they are incorrect, and need recreating.

I would achieve this with a prompt that sets a presentation filter and then some case logic on your numeric field to do what you describe based on the value set in the presentation variable.

Hi, yes you need to migrate rpd and catalog, presuming there are changes in both. On 11.x you can just use the OBIEE environment control to upload the new rpd for use, but it is 'customary' to maintain an archive of previous rpd versions so you can rollback if necessary. See this =>…