Of course, Christian. Regards, Manoj.

Thank you Adam.

Thank you Adam. obis1-diagnostic.log displayed an error "[nQSError: 12010] Communication error connecting to remote end point: address = 127.0.0.1; port = 51796.". Corrected Windows hosts file (removed comment from 127.0.0.1) and the issue is resolved. However, does the Oracle DVD always use 127.0.0.1 IP address? Is there…

Hi Christian, Thanks for your reply. Could you please let me know why you think that both the posts are the same? Here, I am trying to understand the negative impact, if any, of higher LogonExpireMinutes, ClientSessionExpireMinutes and ConnectionExpireMinutes parameter values (which, based on the same current value, I…

Could be to exclude top {1, 0, 2, 3, 4, 5, n} rows from the result set.

Hi, I have tried to create an Analysis where I have tried to replicate your scenario. It's based on SampleApp version 607p. The subject area is "U - Usage Tracking" and the columns selected are: "Query Time"."Start Date" "Query"."Query Type" "Query Time"."Start Time". All these presentation columns belong to S_NQ_ACCT…

Closing this as "Assumed Answered", as now I need to start working on making the actual changes (I am convinced but now I need to answer internal questions like what is the impact, etc..)

Hi Christian, (I am saying to myself: OMG, questions from OBIEE experts, questions from DBAs, questions from architects, questions from PMs, questions from PLs, questions from vendors, questions from colleagues ....). I don't know why it's based on ODBC, probably the Vendors created it generic for their clients. Although I…

Thanks Joel. With regards to 10g, the decision makers are someone else. I have not tested the changes system wide yet (please see below 'Additional details') but I would like to prepare for testing the changes. The script changes the date format in an Oracle 11g database to 'YYYY-MM-DD'. Additional details.- I have created…

Yes, tried that just now. My apologies, sorry I kept you gentlemen weeping. Kind regards, Manoj.

No luck yet. With CAST ( VALUEOF("SV_Cutoff_Date") AS DATE ) in the complex join, the SQL statement generated is cast(TO_DATE('2018-09-26' , 'YYYY-MM-DD') as DATE ) which throws no error but the prompt's value is never considered which means that the default value of the session variable is always used. And with CAST (…

Nice to know that the OBIEE gods (and angels) are helping me. Thank you, thank you very much. But I am not sure what I have done to make them weeping? The date attribute of the date dimension is of date data type (both in the database and the RPD) so no time aspect is expected. Team dimension's start date and end date too…

Thanks for the above replies. I understand the issue but I am not able to resolve it. As per step 3.1, I have varied my SQL statements in the initialisation block. As per step 3.2, the 'Results' window shows me SV_Cutoff_Date value as 2018/09/21 00:00:00 . As per step 3.3, the Session Manager dialog box shows me the…

Ok, the pivot is further enhanced. Set the aggregation rule to 'First'. The pivot is now based on all the attributes.

You may wish to customise the presentation. Below same data is displayed using Table view (first) and Pivot Table view (second). (OBIEE 10g .... Should be feasible in your latest version, if not apologies, in advance.) Edit: I am not displaying an attribute above in the pivot, it's a measurement.

As per your case statement, the output is produced. May be you want to try Pivot Table and hide borders?

Thanks for the reply Martin. For peace of mind, I had even removed the filters on USERID and DTE columns. Regards, Manoj.

Compared the output in SQL Developer this morning in the live environment. They match. However, the queries (particularly the FROM and WHERE clauses) generated are different (and have different meanings). I tend to feel the second one is more correct syntax-wise, as the fact is joined to other dimensions (with snowflake)…

Hello Robert, I added it to the complex join. And now the filter "is_row_deleted = 'N'" is added using AND instead of WHERE. Asim, thanks for your reply as well. Regards, Manoj.

I have completely failed to understand why a page functions correctly, as desired and developed based on requirements, in OBI EE 11g but not in OBI EE 12c. From an end user's perspective, it's completely annoying to scroll up to view the graphical presentation of data when pagination is used in 12c. After submitting the…