Hi Christian, I also have the same requirement like that. But I have to drill through the Action Links as per the part (eg,BORROWING will drill to the Detailed report ,it will drill to the different reports as per the value.) of the Pie Chart. Is it possible? Thanks, Mayur

Hi, I have concatenated the VARCHAR columns with DOUBLE column in the formula it is throwing the same error as like NQSError : 22020 but, when I have cast it , It is working fine, And it is also displaying the concatenated result, Cast it again and try it.

For the test purpose I have concatenated the simple string with the Column, Formula I am Using, Result, In the same way you can use the Columns to concatenate instead of Test String.

Same formula is working fine with me. Can you share the snap for the Formula?

Edit the Formula like, "COLUMN1" ||' '|| "COLUMN2"

Thank You All for your help. Problem is sorted Out. Thank You So Much All.:) --Mayur

Hi Jackohug, Yes it is showing the correct values. I mean, I am trying to use the Calculated Items which I have created for the Pivot table in the Graph View. In the Graph it is not working. It is not showing any calculated Items in the Layout properties of the Graph. Thank You. Mayur

Hi Akansh I am already using the Pivot table. And I just want to create the graph on the same report. Thank You, Mayur

Hi , This is the my requirement, For the "sum of % not usable" and "sum of % rejected" created through the Calculated Items. But when I am trying to create the Graph on the same it is not working. Thank You, Mayur

Tried with that too but it's not working.

Hi Earlier I tried with the Column level (Calculated Measures) filter but filter was not working there so I have created the Calculated Items in the report that is meeting to the requirement.

HI, There is function for "dense rank" in oracle SQL you can try this with the Evaluate function. Try this, I guess it will work. Thank You.

Hi, Try this one, http://arjunonobiee.blogspot.in/2012/01/obiee-between-dates-prompt.html or Oracle Business Intelligence OBIEE 101: OBIEE Between Dates Prompt Thank You.

Hi, Not sure about version because I don't have experience of the other Version. Mark it helpful. Thank You.

Hi, I am using thick line instead of single line to highlight the color. Please check out the following snap I have used different color for the SINGLE CELL. Criteria: Logic: I have applied conditional formatting on different measure on single cell, >>Manufacture cost: Marketing Spend: and the last one: No of Units Sold…

Hi, It can be easily achieved by the conditional formatting. Try with the conditional formatting. Thank You. Mayur

Hi, Use the case statement in the Measure formula for this requirement. eg. case when 'measure' >100 then 'Do Not Consider' else 'measure' end Thank You.

Hi, Here is your answer, OBIEE in IL: OBIEE - Better looking Bar Graph Mark it helpful, If it works. Thank You

Hi, Take any random measure or dimension from the Subject Area, And Edit it's formula as, It will add one empty row in the Report. Thank You,

Hi, Instead of using Narrative View use the Title view for displaying image. Thank You