I have seen this error ( not related to Evaluate) when presentation services are down. I would check following things... 1. if everything is up and running. 2. If the user that you connecting with have access to essbase to run that query. 3. I'm sure you already have required setting for Evaluate. Just double check if…

First good to see someone actually reading a blog that I thought no one reads. You need to add a default member for this to work in analysis. Otherwise the analysis will work in dashboard when you submit with a presentation variable. PV_Entity is the presentation variable here. To work in analysis Do this..…

Yes, that is correct. I overlooked that it is a pivot table, sorry. In pivot table, if you don't have the measure in Measure bucket then it is treated as attribute. If OBI thinks that it can do a group by then you will see symbol. But for measure you will not see that. Thanks Arijit

Still not very clear to me. Anyway trying to guess what might be the issue. 1. Check if you have data for the first month. If not, try including null values. 2. Check if you have enough space in the X axis of the graph to show all values. Update canvas width on graph properties window to increase width to see if that…

Can you please set aggregation rule as 'SUM' for Grand Total formula column and try ?

Try this .... FILTER("table"."measure" USING "business"."unit" like '@{v_variableName}{%}')

Here is oracle documentation about how to set up time series function. https://docs.oracle.com/middleware/1221/biee/BIEMG/dimensions.htm#BIEMG348 Thanks Arijit

Read these blog about time series analysis in OBIEE. Hope this will help. Thanks Arijit OBIEE in IL: OBIEE and Time Series Calculations in analysis (Ago‎, Period Rolling‎, To Date‎) OBIEE in IL: OBIEE - Few options to compare data to previous month, Year or something...