Hi, And what did you do to fix it? Because right now you are sharing the information that it doesn't work, but you aren't asking anything and neither provide logs or anything else which could drive to some hints. So start by checking the logs, read what the tool and the system generated and find out the root case of the…

Hi, You are missing a key point in your thread: different as "they are finally correct" or different as in "they aren't correct" ? Did you do some analysis/debug of the case to find out what is different between how 11g and 12c do things? (generated queries etc.) Do you talk about analysis or reports (BI Publisher) ? Did…

Plan B: keep it simple ! Make as many condition analysis as you have values in the prompt ... Basing conditions to display one of many sections on number of rows returned by a single condition analysis and trying to find dimensions having different (but fixed) number of rows is the best way to get in troubles in the next…

Hi, Did you check the official documentation? It cover those topics. You also find more documents in My Oracle Support website. Search there and you find everything you look for ...

The favorites are stored in the catalog, not in a database ("almost" nothing is stored in a database in OBIEE). So you can do it by editing the files on disk (XML) for all the users: _internals/_favorite inside each user personal folder. You probably want to do a backup first ...

It doesn't require an extra license. The tool is "cluster by default" in a way, so you always get the concept of cluster in Weblogic even if single node.

Hi, Not sure what you exactly expect to get ... First would be good to know if you want to do a report (Publisher) or an analysis (OBIEE Answers). Then keep in mind OBIEE isn't Excel, if you want an Excel behaviour keep using Excel and Smartview also exists for that reason. PS: I thought Oracle employees were required to…

The certification matrix ... take some time to get into it in detail (it's Oracle ) The "system" sheet in the file is the one giving you the OS details for the "server" on which you want to install the tool. You first need to look at the column "Product Offering" to identify all the values that match your needs. In your…

3491748 wrote:in this picture I saw windows 7 sevice pack 1. the file I looked into is "fmw-122120-certmatrix-3254735.xlsx" donwloaded from oracle. sheet "client". Look better in the picture you posted yourself ... Column A: do you see OBIEE as one of the products matching Windows 7 ? And you seem to be looking at the…

My assumption (based on the question) is that the OBI users are stored in the embedded Weblogic LDAP and not in an external corporate LDAP or AD.

Adam Wickes wrote:What if they login but don't do anything?Does anything go into Usage Tracking? I would count those as "no longer in use", because just login to see the homepage but not run a single analysis is like not logging in

It's perfectly normal ... In the physical layer you simply define the condition connecting the 2 tables, not the inner or left/right/full outer nature of the join. You then set the kind of join in the business model. So forget the physical layer but go in the logical layer where you have the logical join between your fact…

An export is always based on the view except if you export in CSV (or the other option next to it) which is the export of the "criteria tab". So what kind of export are you doing? What format did you pick? Would also help to post a bit more info :

3491748 wrote:Maybe you are right after looking the certified OS with oracle BI 12.2.1.2 I decided to install on windows 7.s1. I hope it works for me. No, no, no, stop ! Windows 7 ??? Where did you see Windows 7 as a supported OS for OBIEE ? Oracle Linux 7.5 is totally fine, it is in the certification matrix and it's…

Keep in mind DDR (direct DB requests) bypass the core of the tool, so you don't get most of the feature the tool has. If you want a calculation you need to do as Joel said: do it in your query (as you are writing a query instead of using the models of your RPD, you can't really expect to not have to model things but then…

You can look at https://www.rittmanmead.com/blog/2015/09/using-the-bi-server-metadata-web-service-for-automated-rpd-modifications/ to get some ideas. There isn't a "click here" option of course, so it's up to you to code the pieces to get there, but it's doable.

Who knows ... I said it looks like your logical keys aren't correct. But you are the one knowing how they should be instead as it's your data and your model. But just from the picture I believe you have an issue as if "Company code" is the one of the first post it's clearly not unique for every country.

The issue is your model (and data) ... You have a LAST aggregation which is executed on the company code and year. But you have the same company code for various countries, which explain why the same values for a given company are used in every single country. I would say you have issues in your logical keys.

You mean for analysis? (so not Publisher reports based on subject areas) You can generate a report in catalog manager and analyse that one, it will give you subject areas, tables and columns references by analysis, but it will not do the job the other way (telling you that one column is used in 5 analysis). But with that…

I changed my mind few times about the "best" way to do the customization. Both ways are documented and supported by Oracle, that's the good news. The EAR lost all the interest except if in a cluster, but if you have a shared folder mounted on all the nodes it's easier and better to go for the shared folder, mainly because…