5.) APEX like the example in SampleApp 6.) Hangout/skype/slack or any other communication tool

Hi, Depends on your license. If you have named users license you must have a license for every single user you have. The easiest is to get in touch with your Oracle account manager to make a point about your current licensing and define your new needs or the limitations you have now to fix to not exceed the license you…

True when you use the analysis, but the single object is the analysis which has 1 LSQL globally (if you translate custom filters into generic filters). Real query generated at the time of executing the report with the context is available in the UT tables, as Christian said. But all these possible queries always come from…

Hi 3269182 wrote:Urgent requirement pls....! That's why consultants exist: hire one and he will be pleased to answer as fast as possible. Did you try searching? This topic as been covered here at least 10 times and on Google at least 100 times. Out of the box not a single one of these things is possible. There are external…

I agree but in this case the OP posted "Weblogic Server : 11gR1", so definitely not a 12c

Did you really googled? Because just writing few words I got this as first result: https://docs.oracle.com/cd/E12839_01/apirefs.1111/e14397/LogMgmt.html#BEA-170011 You must check in the various logs for other pieces of information, the warning you are seeing isn't the cause but just a consequence of your real issue. And I…

As extension: you can also define and setup UT on another kind of DB, as long as it's a standard kind of database talking SQL and that can be defined as a physical source in the RPD, so not really only limited to the 3 kind of DB but 98% of people just use the table in the RCU schema.

So first thing you can take Kibana out of the equation: Kibana isn't a database, so it can't store your usage tracking. The admin guide explain how to setup usage tracking in the supported way: inserting into the S_NQ_ACCT table of the BIPLATFORM schema, which means the database is one of the 3 supported for the RCU:…

Hi, You can maybe already start by sharing your searches, finding, what you tried and what happened and so have a more explicit question about a precise point? (a bit what suggests). Asked like that it sounds a bit like "do my job" ...

Because the job is done by the BI Presentation service. You can still access static elements like the images etc. But any content requiring the BI Presentation service will not work. The java pages deployed on bi_server1 need the service in the background to be able to show you something. It's why you always need all the…

If it worked you can maybe close the thread? For now it's still This question is Not Answered. Closing it will help others finding answers to their questions faster.

if it's the piece you were looking for (publicly it's the only license you have to accept before to get the software) you can maybe close the thread ...

If you look on the download page (Oracle Business Intelligence 12c (12.2.1.2.0) Downloads ) you first have to accept the OTN License Agreement before to be able to download. Right now the agreement is here: OTN Developer License Terms It will also be easier to get in touch with your Oracle account manager for all the…

Yes, you can see things like that. The pages of /analytics (answers) and /xmlpserver (publisher) or even /va (visual analyzer) are server from the managed server and these pages interact with the services in the background and the services interact with each other based on the action you performed. If you look on your…

Sorry but if you have the analysis reference (which you have) you can't really go to a lower level, that's the same as LSQL hash in the end (you of course cover changes to the analysis somewhere else). 1 analysis = 1 LSQL = 1 LSQL hash 1 analysis = 1 absolute path to that analysis If you copy that analysis in 2 different…

Hi, They are different kind of things. "bi_server1" is a managed server of Weblogic. The AdminServer control it and weblogic can have many (or even none) managed servers. It is an application server where java apps can be deployed. The services are components running on your server and they are really the heart of OBIEE.…

Hi, Do you look for a solution in OBIEE or in general in your DB? OBIEE can definitely manage your 7 tables and query them all together (defining 7 LTS for your logical table) or you can just "unify" them at the DB level. The simplest way is a view. I would avoid an opaque view in OBIEE as that's really hiding logic.

The SampleApp just take the one based on the same OBIEE version you are using (11g or 12c), so you can easily copy/paste things and reuse them directly. For your 2 tables I don't see a problem if you have 52k items in one and 33k in the other, they are not supposed to be the same as they are something else. Also keep in…

Hi, If you look into OBIEE Samples there is an example of this impact analysis (column/subject area <-> analysis, prompt etc.). They also provide scripts to get the data and load them and of course you have the RPD model and the web catalog objects. If you want to do it with what you have of course you can't join at the…

What Christian said ... In other words: it's not OBIEE that must do something, it's the browser which must be able to understand the link and open the required app. In OBIEE all you have to do is to create links (like web links) by editing the formula or setting a custom format on the column format (or both if you need).