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

Physical query generating with different table

Received Response
1
Views
1
Comments
3295028
3295028 Rank 1 - Community Starter
edited Aug 13, 2024 6:13PM in Oracle Analytics Cloud and Server

Hi all,

I have one logical column with case statement. When I create report with this column its sql gets with wrong table as well that table is not available in LTS.

When I create column with same logic in report it works fine with correct sql.

Can any one help me out in this. What I am missing?

Thanks,

Ajit

Answers

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

    Edit: Missed a line there.

    So for case 1 - are you sure it's referencing the correct column of the RPD and there isn't an old alias being referenced that acutally points elsewhere? Have you checked the XML?

    Also: How do the two queries differ in detail? Does the error tell you precisely what's going wrong where? In log level 5 you should be able to see the actual flow throguh the RPD and where what happens and / or goes wrong.