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…

I guess the IFNULL isn't working because there isn't a NULL like the OP said in the title. It's just empty, nothing at all (which is not NULL), so the formula can't be executed on something which doesn't exist and that's why the IFNULL doesn't return anything.

I didn't try deploying my own style in the "old" way, but I would be surprised if it doesn't work anymore. The new theme management store a weird thing in the catalog with isn't really a custom style as it doesn't have CSS files but an XML with some properties inside. It looks more like a simple way for those who want to…

Hi, You get those messages when running the import metadata wizard, right?

My opinion is that it isn't supposed to be a big risk, mainly because the OBIEE core didn't really change (theme management? Yeah ... useless when you know how to properly customize OBIEE). So on that side little or no extra issue than .3 is expected. For the DV side ... it's newer, and as they had it for a while in OAC…

Hi, It's a bit unclear what you are trying to achieve. You mention 2 different things ... You want to open by default a tab, or do you want to hide all the others? (which of course will produce the same effect as opening the default tab). By the way, do you agree the "tabs" are the pages of the dashboard? (just to be sure…

mmajdana1 wrote:Hope I am wrong. Don't think you are ... The fact you had to use CSS to get it on screen is a good indicator that you can't do it in the export ...

Don't forget SmartView .... Being into Excel it gives you more Excel options.