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).

The OP wrote: saketsrv wrote:I have recently configured obi 12c application ver. 12.21.2.0 There is no opmnctl anymore in 12c, everything is done via the bitools/bin/status.sh command.

Hi, no config for that part, it's just there and work by itself ... Difficult to say based on what it build it as OBIEE has all the info of what people open or not, so it's some internal cooking.

Honestly it's more the data (the way you described it) looking like it's not proper. But as said you can still make it work (I gave an example of the kind of join you can try), but as said: poor performance, possible wrong behaviour (like 101 also joining to 1015 because of the 101% kind of join). The fact table with…

Hi, Your question is a database question (Oracle Text isn't OBIEE but DB). What sounds strange is why are you supposed to install it by hand, I don't remember having to do anything extra other than installing 11gR2 for an OBIEE 11g install. So what kind of database did you install? (detailed version)

Hi, dumb question but: do you see anything else in the UT table? Because it's not something you can configure: everything or nothing, so the kind of analysis (if a chart or a table) doesn't change from a usage tracking point of view.

Hi, OBIEE ideally works on a dimensional model with 1 or many facts rows pointing to one attribute. In your case you already have 1 fact pointing to many attributes (so you just reversed the logical relationship). I would highly suggest you normalize your data and use real primary key = foreign key relationship (at least…

Hi @user1254883 , Can you please post what you are exactly doing now? You started with an OBIEE 12c install on Windows 7 and now moved back to installing OBIEE 11g? (which at least is certified for development only on Windows 7) Because you are "hijacking" your own thread and people answer based on OBIEE 12c while this…