Hi, I have read about Fusion Charts to get this done. LInk :https://www.fusioncharts.com/dev/chart-guide/standard-charts/pyramid-chart Can we use this in an OTBI analysis .xml to get the pyramid layout. Please confirm. Our client is pushing on having the structure in Pyramid format. Regards, Rashmi

I tried sorting--> went to Results screen --> clicked on 'Head Count' column --> Sort --> Descending. Analysis gets sorted , but, not the funnel. Funnel is, by default i guess,sorted on ascending order of the Job Name. Can you please help.. Regards, Rashmi

Can you please guide , how to sort a analysis on a specific column in descending order? Regards, Rashmi

Hi Julian, I did check the funnel option. But, I guess , it requires for every parameter(like job name), it compares 2 different fact columns(like head count and assignment count). We just need one fact i.e. head count for each job. When I create an analysis like this, it will not give the highest head count at the largest…

Hi, Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B version? Please advise. The different levels in the pyramid would represent different grades (e.g. Analyst, Associate consultant, Consultant,... partner, etc.) And their width+number(width of the pyramid) would represented headcount at those…

Hi Caroline, Thank you for the update. Here I am able to achieve the different color for the bar in a normal graph. . I am not able to sort the bars in the graph in either ascending/descending manner even I though I have applied the sorting rule on the column in the criteria section. I have uploaded the image for your…

How to change colors of the bar graph in the pivot graph. I need to change the color of the bar for each vertically grouped entity Eg. I have an analysis showing Employee score and ranking them on that basis. The graph should should display different colored bar for each employee. Request your assistance. 

Hi Guys The requirement is based on goal management and performance management. I have to create two analyses: one detailed analysis (Where score is to be calculated based on some calculation logic on budget and actual targets) Then I have to create another analysis based on scores of the detailed report and I have to rank…

Hi Thank you all for your replies but the thing is i have a requirement where one dashboard should be created consisting of various analyses and the data for the analyses will flow from BIP Detailed Report. For example if there are some scores in BIP Detailed Report then i want to create one analysis having ranking on the…

Thanks Noelle, there was a firewall block on mail server. We are using an alternate email id and it works very well with the same code.

Hi Amritsen, Thanks for the update. Please find bursting query below: ========================================= SELECT PERSON_NUMBER KEY, 'RTF' TEMPLATE_FORMAT, 'en-US' LOCALE, 'PDF' OUTPUT_FORMAT, 'EMAIL' DEL_CHANNEL, 'Employee Confirmation Letter' OUTPUT_NAME, PEA.email_address PARAMETER1, -- to 'rashmirao2@kpmg.com'…

Hi, we require CSV report output in e-text template format. we tried manually but user wants automated. so we tried using File Method But getting error that output Failed. Bursting query we used is : SELECT 1 KEY, 'FND LOOKUPS VALUES' TEMPLATE, 'en-US' LOCALE, 'ETEXT' OUTPUT_FORMAT, 'FILE' DEL_CHANNEL, 'Desktop'…