This content has been marked as final. Show 7 replies
I think you can write a subquery through Advanced tab of Analysis in OBIEE 11g. Please see if the steps below can help
1. Create an analysis for the source report(The report which is your data source in this case).
2. Validate the results and if they are fine capture the 'SQL' through Advanced tab.
3. Now create the final report and in the from clause, please provide this source SQL.
This way, we can make the BI Server generate a sub query.
Hope this helps.
Yes, the original answer is a complex pivot table with several aggregations and I am trying to use the columns from this answer in another report.
Can you think of any way? Sub query is helpful, but being able to use the pivot view as a source for another answer is very powerful and I am wondering if I can do that.
I am trying to use results from column in another column. The first column is a formula and i'd like to use the results to do a case statement in the second column I believe:
CASE WHEN (TIMESTAMPDIFF(SQL_TSI_MONTH,"- Lines"."Expiration Date","- Lines"."Start Date" ) ) >12 THEN 'Y' ELSE 'N' END
This is my formula in the second column, I'd like the results from the first column TIMESTAMPDIFF(SQL_TSI_MONTH,"- Lines"."Expiration Date","- Lines"."Start Date" ) that are >12 to display as a Y and everything else an N. All are displaying as N so it's not reading my formula. any help would be appreciated