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.

So can you mark as required and close the thread? For now it's still This question is Not Answered. ( )

The patches are for the 12.2.1.4 setup, so you install FMW 12.2.1.3 and apply the patches on the 12.2.1.4 install you do.

Did you give up on this one? Did it work as expected?

Hi, Export to Excel can't translate custom CSS just because there is too much that can be done with CSS which can't be translated into Excel. So when exporting to Excel custom "browser" effects like your CSS or Javascript isn't exported as the tool has no idea of what to do with it.

You can try with table1 left outer join table2 and a condition to keep only rows where table1.column is null . That's one of the way to do it in SQL and you can do it in the LTS.