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

[nQSError: 26014] Near '.': Qualified names shouldn't have a space between names.

Received Response
22
Views
4
Comments
2941304
2941304 Rank 1 - Community Starter
edited Aug 13, 2024 5:30PM in Oracle Analytics Cloud and Server

Hi,

I am getting error while making joins in between tables in the Rpd.Can anyone help to resolve this.

pastedImage_0.png

Regards

Manjupriya N

Answers

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

    If you could screenshot the formula giving that error and not cropping it we could maybe help. this way you are removing exactly the information we would need to help you...

  • Gianni Ceresa
    Gianni Ceresa Mod

    What Christian said about the crop, you removed the part which contains the answer to your question. More in general don't write or edit names of columns by hand, just use the interface to add them in the formula (selecting them on the side) as they come with the exact right syntax and encoding already.

  • 2941304
    2941304 Rank 1 - Community Starter

    This is the error.See when i join this two table.i am facing the following error.I checked the spaces also and also removed the double quotes in between the obiee_reports and oblm142obiee

    pastedImage_1.png

    Regards

    Manjupriya N

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    It looks like this is the source of the problem; -

    pastedImage_0.png

    What is the fully qualified name of the physical table?