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'…

Hi guess by default "authenticated user" (the application role representing all the users successfully authenticated) is member of "BI Consumer", so by adding "BI Consumer" to your 2 roles you are actually adding these 2 roles to everybody because of the inheritance between "BI Consumer" and "authenticated users".

3295595 wrote:... was trying to configure external table authentication. Unfortunately it is not working and failing in the database adapter configuration. Why don't you try to look into that and fix this one instead of looking to manage your users inside the embedded LDAP? It's really not the best way for real (prod)…

Depends ... If you have the lightweight SSO login page (the one of the blog) the changes must be done inside the login page WAR/EAR directly as it's totally outside OBIEE and so can't be affected by your custom style. Keep in mind that so far it's maybe not totally supported, didn't check if Oracle wrote about it... If you…

Yes as long as in all the nodes it is available on the same path (to avoid issues). So if it's in a shared folder mounted in all the nodes in the same way you will be fine...

Hi, You look for hardware configuration or software configuration? For the software side when you run the installer it does its own checks and tell you what it doesn't like. Often to keep the install simple you install the "oracle-rdbms-server-12cR1-preinstall" package via yum (assuming you are on a OL or similar system)…