Not parsed address (direct to server) contains port number in the address.

On PROD environment there are two clusters. How to find out of proxy is used? Are there any articles describing the setup?

Can load balancer do the trick?

You are right, but this is the case. New field in Presentation layer is string/varchar type. If you will add it to filter, or on the analysis, it will be string/varchar. In related column in database is number/double. In this case filtering do not work, as in database table there is no string/varchar, and you can't compare…

@Robert Angel, additional question. What we have done is changing Rating in Presentation layer (from number/double to string). In database it is still number/double. In current setup it is not possible to use it as filter or Keep Only in analysis, as string do not match with number. Is there any way to solve it? Or whole…

In RPD it is DOUBLE.

Hi, Yes in DB, EP_RATING is number. From 0 to 5 (0, 1, 1.5, 2, 2.5, 3, 3.5, 4, 4.5, 5) and 999.

Any reason why in OBIEE (report) it works fine without CAST for first part? Cast is string function basically. so try the below:CASE WHEN CAST("WORKFORCE".""."HRDWH"."DimRating_MD"."EP_RATING" AS VARCHAR(4)) = '999' THEN 'Not Rated' ELSE CAST("WORKFORCE".""."HRDWH"."DimRating_MD"."EP_RATING" AS CHAR(1)) ENDbecause first…

Hi, Thanks for the link. I'm afraid that one of us didn't get the point. I had error message displayed as set of data to export was bigger then set limit. I have expanded the limits. Error message is not displayed any more, but I want it back if set of data is bigger that set limit. Now I have behavior that set is limited…

On support page Oracle is suggesting two possible solutions: First one didn't work. Has anyone tried the second one? Additional details: can it have any impact if we have more that one cluster in the environment?

Thank you Christian. Unfortunately it was not clear for me how exactly I have use it, as in description they are executing nqcmd.exe and from Windows cmd.

Thank you very much for your answers. Before I received it I have tried by myself. And the re is one trick about this setup. nqcmd is available in two locations: * Oracle_Home/bi/bifoundation/server/bin/ * Oracle_Home/user_projects/domains/bi/bitools/bin/ On one of the pages I have found info that file from first location…

I have executed this command on Linux, and after BI server restart it didn't work

Data type is INT (visible on screenshot), no aggregation rule. In the report I have set SUM. I know what is going on: in DimPerson, there is more than one entry per employee id, in that case age or tenure is multiplied by number of entries. Is it possible to add somehow to the formula that it should take the valid entry…

Sorry to say, but it will not work. I have column Age, which is created the way you have mentioned, and it is not summing correctly. Don't have a clue, what OBIEE is doing.

Do you mean that it should be created in Physical layer in table containing fields which I'm using in the formula? Where formula should be created?

Server complex aggregate just repeats result for the first line. I have tried to do it in rpd, but result was the same. Which means that I did something wrong or for timestampdiff you cant' sum it.

Hi Thomas, I'm not sure what do you mean... Formula is created in OBIEE, directly in analysis, not in rpd. I don't thing that I can manipulate anything in that case.

Robert Angel wrote:Yes, he will!In case (no pun intended) I was less than clear, I had meant to create a parallel column using the same statement but with numbers returned for the sort order, and then to use this on the displayed column with the original case logic.For the sort order column; -CASE WHEN…

Hi, I can create dimension in RPD with CASE. Thank you for the hint with setting sorting in RPD also. And what do you mean by prefixing? Should it be created in the analysis?