'everything is fine' ... not really though, you have a problem. Do you have ANY object level security in the Subject Area on ANY of the columns or tables? If so, then the error message is telling you that the column doesn't exist (and for all intents and purposes it doesn't) ... I suspect column security is implemented,…

Doing data cleansing in the front end of OBIEE is to seriously miss the mark ... it's an inefficient approach.

Check your syntax ... if need be simplify your report to the bare minimum and get the filter correct first ... If that doesn't work, then time to check the SQL sent to the Database (one where it works with report filter; one where is is not working with column formula filter) ... post those SQLs.

Some were already employees who transitioned ... some applied straight out of college ... for a seasoned worker breaking into a new area, you are going to have to 'force' the issue by being able to demonstrate you can deliver value on day-one. You are far more costly to bring on than that college student and you are more…

+1 to @Joel Acha

here's the section on multilingual data ... http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/deploylocal.htm#BIESG1757

You are better served by having a true common key for the date independent of language to drive the lookup ... (YYYYMMDD) 20162019 would be a natural choice. Then you would have 2 logical columns, one that does a lookup for the 'EN' date description and one that looks up the italian description -- OR you could leverage the…

Mark, This is how Oracle implements in BI Apps for multi-lingual ... common key, language flag, descriptions in native 'tongue'. Retrieves even the English via the lookup! So the star model looks like it should, but the translation tables are not joined to their corresponding dimension, they are leveraged as look-ups in…

Sure you can do what you want ... and we're not telling you not to do it. We're telling you not to set your expectation unrealistically. Do not stick to the 'book' side of it alone -- be very ready to demonstrate knowledge. As for how long ... who knows? That's a very individual thing. I've had people excel at this with no…

Then you just need the 3 BI Roles (Admin, Author, Consumer) and you need to add subject & object specific roles to control content access. Finance Author is someone in BI Author and Finance Roles ... HR Consumer is someone in BI Consumer and HR Role. You can plan out roles to handle: Subject Area Access Roles (for BI…

You a lookup ...that accepts a 'key' for the month, a value for the language you want (optional) and returns the description in the language of your choice. Here's a nice write up on it - http://gerardnico.com/wiki/dat/obiee/lookup_table Referenced is the Oracle Doc on multilingual:…

Given your reply looks like you need a Role that is more than BI Consumer and a little less than BI Author ... so create a LDAP group, create a EM Application Role and add the new LDAP group to it. (make this new role a member of BI Consumer [so this role can do all a consumer can do]), then add this role to any additional…

Not at all ... I'm telling you a certification is not the vehicle to ride to make the change ... get the VM, get to know the product, make an impression on someone in the BI space and get an interview. The switch is possible.

"Once I get in, since I have the OBIEE technical knowledge due to doing the certification," Unfortunately the certification does actually grant you this nor is it a free pass ... as I said before, should you ace the exam yet have no hands on experience, and in an interview you are asked to solve a problem (apply the…

@Christian Berg right on! ... In a phone screen I can pick out 'understanding applied' from 'book smart' very quickly ...

It's public (not based on Oracle account) ... If it won't sign you in with Prodney/Admin123, then you have to wait a bit until it gets reset. Your best best is to actually download and run the VM in Virtual Box. Then you aren't at the mercy of some yahoo out there to take the thing offline (accidentally on purpose as my…

Many people get Oracle Certified simply because they currently work for (or have in the past) a partner of Oracle's which carries a certification level requirement. I would imagine many don't hire solely based on a certification -- and don't think for a minute an interview just deals in verbal questions ... you may be…

Is this what you are looking for? https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=296132983859286&id=1449681.1&_afrWindowMode=0…

to do this in Answers is very inefficient ... you'd be better served having this implemented in the database (use of your information drives your design). however, In answers criteria tab ... use the Project column, the date column (filtered by gate1), the date column (filtered by gate2), then ensuring you have real…

Perhaps a dedicated fact table that has that count already figured out - it's much more efficient.