OBIEE Metadata Easy Order — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Metadata Easy Order

Received Response
11
Views
4
Comments
dilek
dilek Rank 6 - Analytics Lead
edited Aug 13, 2024 6:13PM in Oracle Analytics Cloud and Server

Hello everybody,

I try to find an easier way of ordering columns of tables on obiee repository (default is alphabetical). Since there are lots of columns and tables, it takes so much time. If there ise, can you hep me pls.

Regards,

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Prefix them with an alphanumerical value which will sort them:

    0001 - Zardoz

    0002 - Slartibartfast

    0003 - Cthulhu

  • dilek
    dilek Rank 6 - Analytics Lead

    Thx Christian, but I have hundres of tables. Should I change all tables and columns physically? Or you say something different?

    Regards,

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I was talking about the BMM layer. I would only use that on the physical layer if you're anyways aliasing everything.

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    What about using Physical and Logical display folders?