Universe - Context/Object-Question

[jens_grotholtmann]

Hello,

I have some Dimensions A, B, C around different tables in the center, like X, Y, Z.

Now there are Contexts for X, Y and Z-table.

Now my Universe contains now and object like

case

when A.id = 2 then

    '22'

when A.id = 4 then

    case

         when B.id = 3 then

            'D'  

          else

            'E'

      end

   else

      'UNKNOWN' 

end

So tables A, B, and C are not directly join. To join them, I have to use X, Y or Z, depending on the context (and add Table X, Y or Z to the tables-section of the object).

I could create the object for each dimension separately, but I'd like to do a "good" solution.

Thanks in advance

Jens

[jens_grotholtmann]

So, I figured out, how it works in an ugly way:

You can go with only one objects, but this throws errors in the universe. For the WebI-Report everything is fine, because the report asks for the context to use.

Pro: You have only one object in the universe

Con: You have errors in the universe

So I tried to do one object per context. This works, as long as you have a table, which is used in the joins for that specific context. If you do not have such a table, you could create a derived table, to force BO to use the specific context.

Question:

Why is there no option, to select a specific context for an object in an universe?

That would be a neat thing. Does anyone know if there is something on the idea space?

Bonusquestion:

Is this the wrong place for this question? Then please feel free to move it to a better space!

Thanks in advance

Jens

P.S.: Even if you do not have a solution, please feel free to share your experience. I think this is a great opportunity to discuss the matter.