Do you have some sample data or more explanation that can be given for us to understand?

The catalog manager using A accesses the shared location's catalog and deployed there. Whereas when you access catalog manager using any one of the B or C's address, it tries to access the local server's catalog and hence you might not see your changes. When you use A url, which server is it hitting in the background - B…

All the schemas that are created during RCU Creation is rquired and should be accessible. These contain metadata required, security and other relevant stuff that is required by OBIEE to be up and running.

Usually this error is due to no/incorrect content level setting. Please check the content level of LTS for both Fact and Dimension.

Thanks Gianni, will close the thread as I have got the solution.

This is working fine. What if there are multiple columns in different reports? I found this the Doc ID 2614514.1 as well. What will be the impact if I am following this?

Thanks Gianni, Please allow me some time to implement and check this. It will be like a day or so to completely test this. I have a positive feeling that this will definitely work...

Hello Gianni, In the below formula: "'<a target="__blank" name="'|| "COLUMN_TO_BE_DISPLAYED" || '" href='||"LINK_COLUMN"||'>'||"COLUMN_TO_BE_DISPLAYED"||'</a>'" COLUMN_TO_BE_DISPLAYED is the column that will be displayed with a hyperlink linking back to LINK_COLUMN. Per your suggestion, I created a duplicate of…

Hello Gianni, Thanks for the explanation. Just for my understanding, so in this case, if the USER sorts the link column dynamically, will it work properly? As my sort is done on COLUMN_TO_BE_DISPLAYED, which is UPPER (let's say), then the data will all come in UPPER Case only and not as original (which is mix of upper and…

Hello Jerry, I have already tried that and the user complains that he will lose the control to sort the report on the go. Unfortunately, this will not work.

Can you please post some more insight on what exactly you are doing? The question you have put is really sense-less if you are not providing details.

Did this helped you?

Hello Venkata, These ports are configured while installation of OBIEE 11g/12C. If you want to change the default ports, you can follow MOS 2125910.1 You can also refer section: 5.3.1.2 Changing the Oracle WebLogic Server Listen Ports Using WLST in https://docs.oracle.com/middleware/1221/core/ASADM/ports.htm#BEIFJBIA

Have you disabled the "Listen Port Enabled" option for Admin Server?

Can you specify your OBIEE Version, server and other relevant details?

Better, try to understand the Physical SQL generated for the incorrect Totals. That should give an idea as of what is going off.

What are you trying to achieve (COUNT)? Are you taking simple counts or Running Counts (RCOUNT)? Both are very different. Please check

You can define Initialization Blocks (IB), use static Variables fro Connection Pools and then use these variables directly in RPD. Hope this helps.

Hello Odarin, Can you please try something very simple first to see if the Filter is coming in your SQL? Like: Filter(<Measure> Using <Condition>) -- Measure: Already Aggregated in RPD

That's the way OBIEE works... Why do you want to combine both columns anyway? To handle this at OBIEE Presentation Server side, you will have to concat the columns.