Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OBIEE Metadata Easy Order

Received Response
21
Views
4
Comments
dilek
dilek Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 6:13PM in Oracle Analytics Forum

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 & AI 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 & AI Lead

    What about using Physical and Logical display folders?