Hi, You are mixing things a bit. OBIEE doesn't use logical indexes for joins, it will go back to the joins you defined in the physical layer for the joins between objects. That's also why when you define a join in the business layer it doesn't ask you about columns or conditions but you can only define the kind of join…

Actually you are right It's just the dumbest thing ever to run the RCU to generate the scripts for the DBA and being asked for a DBA connection. If you have the DBA connection why would you like to generate the code instead of running it? Smell like a smart developer forgot a piece of logic here ... Actually it must be a…

The blog just heavily use javascript to change the structure of the page once it has been rendered (actually it miss a piece to call the function only when the DOM is ready or you can get errors). It is a normal dashboard, actually it can works on any page of OBIEE where you can add the piece of code. I would suggest to…

Captain_Cook wrote:1) The underlying queries will change so this will have impact to performance?2) Rewriting DDR queries (syntax changes from Oracle)?3) Performance of BI/Presentation Server exchanges with PostgreSQL in comparison to Oracle 1) The queries generated based on the RPD will change just because the DB is a…

So can you maybe close the thread? Other users with similar question will know they can find something interesting on here. For now it's still This question is Not Answered.

at least we agree

Hi, REPLACE("Your table"."Your column", ',', ' ') You must edit the column formula and use the REPLACE function to replace , and add a space instead.

If you do it the same way as 11g it's supposed to work. For sure the res (that's the one with the custom style inside, at least it's like that in mine), the msgdb I didn't test, so can't confirm 100%.

Great to hear you did it the right way So it's easy: copy your analyticsRes over to the 12c server and deploy it, cross your fingers and ... it probably works already not too badly (as it's a different version there can be things missing or being a bit different, but there are chances 95% of the job will be done already).…

You have an option. But keep in mind the "export" link there on top is based on a privilege and not dashboard based: so you have it or you don't have it.

Your sequence is not fine (you will be able to install following it). zain-OC wrote:To implement the Data Warehouse do i need to install Data warehouse builder ?? What do you mean by "implement the Data Warehouse" ? As I said a data warehouse is a concept and not a tool, wikipedia define it as "... DWs are central…

Hi, zain-OC wrote:install and configure OBIEE 11gR2 with ODI and Data warehouse The first step is probably to find out exactly what tools you need / want to install ... OBIEE 11gR2 doesn't exist, ODI is a tool with many version and so you better define which version you need. Data warehouse is a concept and not a tool, so…

Hi, You are installing on Windows, that's fine but .... please don't tell us it's your Windows 7 or Windows 10 laptop. As far as I remember the certification matrix cover Windows Server 2012 and 2012 r2 (double check in case). And if it's a laptop install I would highly suggest using a VM (virtualbox) to keep things clean.

Hi Zoe, Could you please add few more details on how/where did you setup "row security" and how does it look like?

What is "customization" ? Is that a custom style? If it's custom style, custom messages etc. you have to do it manually, the migration script only works on the OBIEE content, not the custom look and feel. You can deploy custom style and/or skin in OBIEE 12c too or redo your customization if you have a list of the things…

Do not forget the RCU implemented an alternatives for these cases. You can run the RCU to generate the scripts instead of execute them and you send the SQL to your DBA so he can review what is inside and execute it as sys on his side without problem. In this way the DBA keep sys on his side and is also totally aware of…

I would not use "deny" privilege. Ideally you must have 2 accounts: one maybe admin (so you can set privileges) and another one with little or no access (a kind of consumer only). So you remove the current privilege and add only admin instead, using your 2 accounts you can see the difference between the one allowed to…

Depends on your authentication providers chain, but AD users will of course be authenticated in AD (AD will not send out to Weblogic users password to authenticate them). The slowness has more chances to come from your AD than weblogic, you are supposed to configure the authentication provider using your AD in a way to…

There are few things you can hide by setting privileges in the administration page. Some others you will probably have to customize (modify) OBIEE files to hide them but then it would be for everybody all the time and it's maybe not what you really want (as some users will still need these links). So I would suggest you…

Hi, I would agree with Venkata you can't assign an AD user to a weblogic group and honestly I never saw it done in that way. For people having your kind of requirement (getting users - groups relationship from somewhere else than LDAP/AD but still keep authentication on LDAP/AD) you have the BISQLGroupProvider. Basically…