Hello Selva, There is nothing like a custom RPD and Catalog for Usage Tracking. When you configure OBIEE for Usage Tracking, these things are handled by OBIEE internally. As already confirmed and suggested by Joel and others, you need to follow the steps and configure the Usage Tracking. Hope that clears all...

Yes, Steve,,, I had visited this document earlier, but did not get much clarity on what has to be added in "bitech-analysis-application.ear". After a lot of to-and-fro messages, finally I got some clarity with the help of Oracle Support and am able to get this done now. Thank you for your time. I will mark your suggestion…

There is no simple way around this. You will have to define a case statement in RPD for all such columns. Can you give this a try: You were trying to select values for NULL from the drop-down using "is equal to/is in". Can you please try to evaluate it using "is null" from the Operator drop-down list?

Hello Steve, Yes, I am following the same blog document. In order to complete Kerberos SSO, LWSSO has to be disabled. I've read it somewhere as I don't remember the exact post/URL. Also, I tried for Kerberos SSO when LWSSO was enabled for OBIEE and nothing worked (as I was still getting the LWSSO Login page). When I…

Thank you Steve, so do you mean that I cannot disable LWSSO in DV or VA? If that is the case, how should I proceed to enable Kerberos SSO (because as per my understanding, I will have to disable LWSSO in order for Kerberos SSO to work). Please suggest.

In that case, I will recommend you to use the approach suggested by @Thomas Dodds and @Robert Angel There is no easy-way-out in this scenario. Also, ideally, if your dim has NULLs, it should come as null. Also, to filter out NULLs in the report, you should not "Equate" it with NULL, instead you have to use "is not null" as…

Hello Christian, Apologies as I got a little busy with some official work and did not got enough time to check this. The OBIEE Homes were just a reference and not actual values, whereas in the command, I have used the actual value. Apologies for the confusion. Also, just to clear the things a little more, I can see the…

Dear User, You can define a CASE Statement for the "Gender" column. something like below: CASE GENDER WHEN 'M' THEN 'MALE' WHEN 'F' THEN 'FEMALE' ELSE 'NULL' <or whatever value you want> END

Hello Joel, I did take a reference of this document for Section "Upgrading Scaled-Out Systems from a Previous 12c Release" and a few other documents, MOS. The upgrade is a successful. However, my issue is to disable default SSO for OBIEE. Also, it's not like I have 2 OBIEE Homes... The domain home is in the older OBIEE…

It's not just OPMN. There are other services as well like nodemanager in the services. I do not have currently OBIEE 11G. I think you will need to create startup script and deploy it as a windows service.

Can you please post some example of "Factor Query", please?

Yes, it should solve your problem.

Dear User, When you run the "startWeblogic.cmd" manually, it does not return you a prompt. This is expected. When you close the command prompt or the user logs out, it will close the OBIEE services. Best way to prevent this is automate the process of starting the OBIEE services.

Dear User, Assign those specific users to BI CONSUMER Role and assign this role to the dashboard. Permission for this role should be "OPEN". That is, create a new role by inheriting BI CONSUMER role and use it in this dashboard. Alternatively, you can add those specific users directly into this dashboard with permission as…

Dear User, Can you check the physical query generated and see if SUM is used or COUNT?

Sometimes you have to go an extra mile... I think the calculation/aggregations for Columns A and B were not happening in the way you wanted... Applying "Server Complex Aggregate" rule forced the calculation to be applied in a specific way. Best explanation is in the below blog:…

Dear User, Please follow below steps: 1. Edit your column 2. Enter the formula as below: avg(SUM(MAX(fact column by dim1) BY dim2, dim3)/SUM(MAX(fact column by dim1, dim2, dim3) BY dim3, dim2)) 3. From the dropdown (where you selected AVG, please select Server Complex Aggregate) as shown below: This is what Robert is…

What is the format of your attachment? Can you please create a new agent and test this? EDIT: If this is a Dashboard, you will need to do similar settings in the DASHBOARD Properties for PRINT Options.

Can you also provide the column formulae used for A, B and C?

Dear User, Can you also give some sample values for all 4 columns (new calculated and existing aggregated columns)? Also, a screen of what is getting out.