I meant to say sql generated

Ok....I hear you loud and clear

But in obiee 12c you are not expected to write sql, and even when you want to do some calculation there is the edit formula that gives the syntax, making it easier for you to apply .....Must i master everything, sql, etl, data warehouse etc as in todays jobs and interview they expect you to be very knowledgeable in almost…

As for the sub query, I was just thrown off on the question , ..... I know that anything you do in the front end , a query is generated .... is that what they call subquery

Very straight answer and correct.............. I need to learn to think through a question before answering

Thank you , I understand were I deviated and I could have answered it better

My answer was you enter your credential to open up the web logic page , on your right hand side you click security realms, my realm , click user and group and then click new , enter the name of the user and a new password after creating the user , you create a group (same way) and attach the user to the group . click save…

Thanks , I will try that too

Thanks , I will try thay too

Andrew , thank you. I am not an expert but will try my best

so how do I go about getting a dashboard picture ....do I google something on dashboard

Ok , ......that means I have to have something already built and then tell story......

You are very correct learning the tool is not the problem but telling the story........ I know the concept Bi analysis/dashboard..........if I can get around a real life project I should be able to work my way through

Gianni, I have the concept of the tool (Bi analysis tool/dashboard) but I have never worked on a real life project and thats my challenge