I have the same issue. Also in a SSO environment I am unable to connect to BI Applications. In a non SSO environment it is possible. Hope to have some solution for this.

Hi, you can find most/all tables here: http://www.oracle.com/webfolder/technetwork/docs/HTML/oer-redirect.html look for section 'Tables and Views'

Perhaps you can work something out with RMAX() by year, quarter. Maybe this will solve your puzzle if the toDate() function is not doing what you expect from it.

You can use the filter in the filter section preferably I think. Not in the column formula if I understand your question correctly

Hi, in the subject areas that you joined by a UNION, you can fill in a '0' in the dummy column. Apart from that there are two places on which you can set the aggregation. In the column itself AND in the pivot as Christian Berg mentioned. Are you sure you set the aggregation on both places correct? Regards, Walter

Hi, in case there is time involved you probably can use the 'Time Series' function Ago() for this. With this you can compare a value to a period ago.