OBIEE Analysis: Adding a specific column creates No Results error

KevinjLayton

I'm trying to add a salary basis and annualized salary amount into an analysis but as soon as I add the column and try to show the results it comes up with the error No Results. If i delete the column the results of the name,lastname ect. come back. Any thoughts?

Gianni Ceresa

Look at your logs, check the generated query, open your RPD, fix the model and retry.

As OBIEE is empty out of the box it's difficult to tell you anything more precise as you are the only one having your RPD and your analysis in front of you.

[Deleted User]

Look at the query. You're not stating what OBI version you're using so it's nqquery.log or obis1-query.log.

You have to look at  what's happening - we can't know how your RPD and data model are built.

Edit: Hah as Gianni said