Skip to Content
Former Member
Jul 16, 2012 at 02:44 AM

Question on Fact table and Optimization


Dear Friends,

I have few question on BPC 7.5 MS version

  1. When we write a EVDRE report, data comes from which table? i.e. Fact, Fac2 or FacWB.
  2. How can I find out when table in DB, Cube in SSAS and Application in BPC were refreshed or optimized last time
  3. What is the SQL statement for finding out the total record in each of the above table.
  4. For better performance, do I need to refresh or optimize all the three ( tables, cube, application) separately or just optimizing application in BPC will be enough.