Why do you want to revert? Put the new (right) password and done. There are also documents in MOS about password changing to make everything "clean".

Hi, The weblogic password is generally saved in an encrypted format in files to allow weblogic to boot without prompting for username / password. So when you change the password you need to update those files as they keep containing the old value otherwise. Have a look at this to see what is that thing:…

Did you open a SR and asked Oracle? I guess I saw some threads where that kind of cases ended up being fixed with MOS giving some "magic keyword" to set in the analysis as variables to influence the way OBIEE generate queries. (I didn't read all the details in the Word files, just looked quickly)

Also consider webservices and javascript methods to get the infos of catalog items, between the various things returned there are a bunch of dates and users referenced (but I wouldn't blindly trust that).

It's the DB features for your physical database in the OBIEE RPD.

Why? Why didn't you used a supported way of doing things? There are 2 ways of customizing OBIEE, none of them require to modify analytics.ear because it's the wrong way of doing things and will conflict with almost any patch, update and upgrade.

The link Joel posted answer the question perfectly. More in general the concept of "integration" is quite vague. OBIEE is a web application, Jet is web too (in the end it's a bunch of JS and CSS), so you can put your Jet code in an OBIEE page but I wouldn't call it integration.

Who is going to pay? Because licensing is the keyword in the end ... Did you look at cloud? In OAC you can get a small instance and it's provided "ready to use", so maybe it's a solution. Then you have Data Visualization Desktop which could be enough.

Hi, I will say it depends on what you expect to get ... When you look for data of the 28 Feb, what values do you expect in the AGO column? 28 Jan or 28 Jan + 29 Jan + 30 Jan + 31 Jan ? I guess the thing is more in the meaning of "AGO", the fact that part of January is missing is technically not wrong if you ask the system…

"tool"? Define tool ... You can setup a VM, a container or install it on a server. As there isn't one ready to use you have to install it yourself, so the "technical" solution doesn't really matter....

What Robert said, if your values are multiplied by 3 it means one (or many) of your joins is multiplying the returned rows. So look at the generated physical query and you will spot which join is wrong and multiplying the rows.

The rule is "first come, first served" Next time I will distract Joel to avoid him to look at threads

Just guessing ... The bar is too small and so the value can't fit inside ... EDIT: Joel was faster

Stop being me: I'm generally the one writing lot of blabla and getting the "right answer" and you writing just few words. In this thread we apparently switched, I better go back to my previous role

1. isn't a solution as the logical model needs to be a perfect start, so no snowflake allowed there ... You can also use solution 1/2: Fact table -> Vehicles Fact table -> Vehicles User Fact table -> Vehicles K Group Fact table -> Vehicles R Group (remember here it's a logical view, so the source of each dim will actually…

kamrandb wrote:Will this mean that ODI 11g will not be integrated with the Weblogic 12c? I didn't checked the OBIA certification matrix which is the one answering that question. I believe OBIA comes with Weblogic 10.3.6 (or a number not too far) by default and that's the main weblogic. If you want to use OBIEE 12c you…

Hi, You mix lot of different products ... OBIEE doesn't have and will never have a certification with ODI as the 2 tools don't share anything. The key element which contains both OBIEE and ODI is OBIA. OBIA so far is only ODI 11g, while for OBIEE you get 11g out of the fox and you can upgrade it to 12c. You can't use ODI…

I will be a bit less categorical than Christian ... Official by XML Search and Replace no. But ... you can always do a string working on the file system files containing the XML .... Just remember it's up to you to make sure you aren't going to destroy the catalog and you actually don't break the XML inside objects.…

Can you close the thread by marking answers as required? So far it's still This question is Not Answered.

Well, depends on your whole security model. Do not believe OBIEE security is just few clicks adding people here or there, you have to plan it and design it based on your business needs. So the answer can be Yes or No depending on how does your full security model looks like. I personally always remove 'authenticated user'…