Convert to your date to Month format with MonthName function in obiee and use it in pivot table.
Something like this . Cast(MonthName(yourdatecolumn) as char)||'-'||CAST(YEAR(yourdatecolumn)as char).
Thanks for your response.
I have tried that but all columns it is showing same month i,e prompted month as heading for all the other columns
Can you show me a screen snap of your results(edit view) also your criteria.
I guess the screenshot of your requirement (and the criteria tab) will help as it's a bit confusing.
If you have a pivot I hope you have a period column in your pivot and this one give you the selected period and the next 11 months and you have a single measure for the amounts/numbers you have to display, right?
In that case the columns headers will automatically have the good names, so I don't really see how you built your analysis to have fixed headers for now....