Can you please share the output of the report, or the column formula you are using. Try assigning default value to the column formula and check it displays those values or not. Regards, Akansh Agarwal

Hi, Add serial number as a column in the dimension table, so it group by based on the branch name. Regards, Akansh

You need to create an hidden prompt that generates this presentation variable for previous year. Regards, Akansh

Hi Ibag, Go to properties and change the grid line properties to specify from default. See below image for reference. Let me know if it helps. Regards, Akansh

Hi, Use Narrative view to create your title. Mark the HTML content and use <c title="Roll Over Text">Title</c> Regards, Akansh

Hi Chandra Kanth, You can do it by creating a calculated column on an dimension. Regards, Akansh

Does your zoom level is set to 100% on the browser. OBIEE generates weird reports when zoom is not 100%. Regards, Akansh

Hi, Please check the content level of the fact table. You need to assign a level of detail for every dimension connected to the fact. Regards, Akansh

Hi, Can you send more details about your BMM layer star. Is maintain_date joined to any other table? Regards, Akansh agarwal

Hi, You can change the join in the BMM Layer between the two tables. Regards, Akansh

Hi Yaseen, You can create a direct database request and call the SAPurgeache function. Oracle Business Intelligence: Purging Cache in the Answers using Direct Database Request: Using agents you can schedule these reports. Regards, Akansh Agarwal

Hi Mayur, Please use the Graph Pivoted result functionality. Regards, Akansh

Hi, You can create a pivot table and use the graph functionality from there. You can then display only the graph or both. Using this will allow you to add calculated columns. OBIEE in IL: OBIEE - Sorting Graphs / Charts Regards, Akansh Agarwal

Hi, you need to do a restart of the server,starting each component at a time and then check the logs for any errors. Refer http://obinsight.blogspot.co.uk/2013/06/restarting-all-obiee-11g-domain.html Regards, Akansh Agarwal

hi, The ports are assigned during the configuration of OBIEE 12c

HI, check this. http://obieewanderings.blogspot.co.uk/2016/01/using-port-80-with-obiee-12c-analytics.html Regards, Akansh

Use Filter as FILTER(Revenue USING Last Three Months) and give the aggregation as Max. Regards, akansh

Hi, Try using Value Suppression as Suppress from the column properties of that column. Regards, Akansh Agarwal

Hi, Please check the database features between the two environments. Are they similar?? Regards, Akansh Agarwal

Hi, The way to implement this will to create alias of the tables based on the filter criteria. Create a logical table with the all the alias as Multiple LTS. And then fragment the tables based on the where condition of each table. A session variable can be used to select the fragment runtime i.e the fragment can be based…