Oracle Business Intelligence 12.2.1.2.0 Thanks

Hi Akanksha, Suppose you want to display a column based on some condition then you can write the condition/case statement in that column level and try once. But we can't get all functionalities as normal reports conditional formatting as Gainni is explaining. Thanks Ramesh Rathod

Thanks you Gianni, I got solution , enabled the check box for include columns with only null values. Ramesh

Thanks for your reply Gianni, I have enabled the check box for include Null Row in pivot table property. Then also i dint get all the months but i get all partner values. When i enabled check box for Include columns with only Null values, then i got result like below I have a date range for 1 year only i.e, 2107. but am…

Yes Christian , All filters are wait for variable and based on variable pass to the filters the report(Analysis) will give data. Thanks

Hi Gianni, Chriian Thanks for the reply. My problem is resolved. I have used single space(' ') for the All column values in report criteria. When we choose the All column values or select values then presentation variable captures the single space (' '). conditions : For 1st Analysis 2nd Analysis 3rd Analysis: Thanks

How does your "condition 1" looks like in OBIEE? I have created analysis with one column A and added filter A is Prompted. Am using this analysis in section condition where row count>0. So you have to "extend" your "condition 1" by adding the part checking for Prompt B and C. Please suggest how to extend B and C to…

Hi Gianni, Thanks for reply. Am facing the problem like when i choose Prompt A and B then report 1 and report 2 are displaying in dashboard, but only report 2 need to display. Prompts Selected: A and B I have taken section conditions: For section 1 --> In analysis i have taken A is prompted and in section condition row…

Hi Souvik, Thanks for reply. I have done the date range validation. Here My validation is up to one Year. If i select 01-01-2016 it will will allow us to select uo to 01-01-2017 only. Here Report From Column SQL: SELECT "Time"."Date" FROM "Loyalty - Transactions" WHERE "Time"."Date" <= CURRENT_TIMESTAMP ORDER BY…

Hi ArijitC, I have the same problem. I am using aggregation rule as 'SUM' for Grand total, but iam not getting the sum as i expected.I am using Pivote table and Grand Total column at row level. As you suggested aggregation rule as 'SUM' it will work for normal table, not for pivote table. Thanks

Hi, You can use case statement to fitter the condition. Check the value for agency name = Asia Region CASE WHEN "Dim Agency"."Agency Name" = 'Asia Region' THEN "Fact Product"."Total of Policy" END