Hi Gianni, Basically it is a fresh install, then i copied catalog PARTIALLY from production to this instance. I copied only "shared" and "system" subfolders from the ROOT of production catalog, did not copy "users" subfolder into this instance. But the user with which i logged into analytics is created in the new instance…

Hi Charles, dont see any errors in nodemanager log, only one warning as below <WARNING> <Server start command for WebLogic server 'AdminServer' failed due to: [Server failed to start up but Node Manager was not aware of the reason]. Please check Node Manager log and/or server 'AdminServer' log for detailed information.>…

Hi Gianni, My mistake, i mean for stopping i ran stop.sh. When i attempt to start, please see below [oracle@Server or Host name bin]$ ./start.sh Starting domain; Using domainHome: /u01/app/oracle/product/12.2.1/Middleware_Home/user_projects/domains/bi ... Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic…

Hi Charles, From Admin server log file, copying some of the error messages , please take a look. <Nov 28, 2018 4:55:54,825 PM EST> <Error> <Diagnostics> <Server or Host name> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <>…

Hi Charles, this is on Oracle linux (on a VM), not a new install, previously working fine, tried some suggestions like kill all the oracle user processes, deleted Admin server "lok" files (only after confirming admin server not running using netstat ), replaced system generated weblogic username and password in…

Hi Charles, the URL you shared prompting for support identifier, i am not using corporate account, can you please share the PDF or Word version of that link. Thanks.

Hi. any suggestions please ..

Thanks Chris.

Thanks SonPat, i am still confused with OBIEE behind the scenes calculation behaviour.

Thanks Rob, your suggestion to use Server Complex Aggregate worked, but i have to create duplicates of measures A and B and then use them in C.

Hi SonPat, Got the expected values, but i did not use AVG as you shown in screen shot. Just gave aggr rule as Server Complex Aggregate. Thanks.

Hi All, Got what i want. I created 2 more calculated measures in answers A1 and B1 before creating C. Basically the 2 new measures are exact formulas of original A and B. Then i created C as usual as A1/B1. Then i set aggregation rule as SERVER COMPLEX AGGREGATE. Then BOOM... got the correct values. I do not understand why…

I want B.

The formula for C is A/B. which is SUM(MAX(fact column by dim1) BY dim2, dim3)/SUM(MAX(fact column by dim1, dim2, dim3) BY dim3, dim2) To this before i applied AVG , now i changed to SEVER COMPLEX AGGREGATE. This aggr rule is set in the "edit column formula" dialog box.

Hi Robert, Tried changing the aggregation of measure C from AVG to SERVER COMPLEX AGGREGATE. It did not worked. Below are the values i got for C. $52.00 --- correct $0.00 --- correct $57.50 --- incorrect $86.40 --- incorrect $88.50 ---- incorrect Please refer to the table of values in previous reply for what the CORRECT…

Column A -- SUM(MAX(fact column by dim1) BY dim2, dim3) column B -- SUM(MAX(fact column by dim1, dim2, dim3) BY dim3, dim2) both A and B has aggregation rule as SUM As said , C = A/B, C has aggregation rule as AVG

Hi, please see below values. A, B, C are 3 metrics. C = A/B. Below are values. A (amt , double) B (no of items, integer) C (correct value) C (what i am getting) $52.00 1 $52.00 $52.00 ---------> correct $0.00 1 $0.00 $0.00 -----------> correct $189.80 4 $47.45 $47.45 ----------> correct $522.61 9 $58.06 $46.56 ---> WRONG…

Hi Robert, here i am creating all 3 metrics in answers, not in RPD. updated the original question.

Sorry Robert, did not get you. Physical means the first two metrics should be created in the rpd ? that is what you mean ?