A lot of temp tables have accumulated in the DB. Why?

• Related Articles

• Temporary Tables have accumulated and is not dropping from the DB. Why?

  Check for the Query id -'QUERY_FETCH_TEMP_TABLES' in 'warehouse xml' and modify as per the schema For example: If the Warehouse is DB2, modify the below query in 'admin_db2_warehouse.xml' as: QUERY_FETCH_TEMP_TABLES SELECT TABLE_NAME FROM ...

• How to define sequence or order for tables in dbmodel ?

  You can define the order for aggregate tables through ?sequence?. See the below example..

• How does ARC Temporary Tables get created?

  When we execute multi parse KPIs, the temp tables automatically get created and dropped in real-time. Sometimes executing such multi parse KPIs may take longer time and business users might terminate in between because of the time taken. At such ...

• Facing problems during drill across and when excel is generated, loading takes a lot of time.

  This problem can be due to various reasons. Try and access the ARC URL from your local browser instead of accessing it within the App server. Additionally, it is recommended to use the certified version -IE7 or IE8 compatible Mode and from the end ...

• What are aggregates/aggregate tables and where is it used?

  When a KPI is published using a set of measures and dimensions, it dynamically refers a specific aggregate table and fetches results from it.