Author Topic: In_memory or Aggregate Tables  (Read 228 times)

Offline fry

  • Senior Member
  • ****
  • Join Date: Jun 2013
  • Posts: 74
  • Forum Citizenship: +0/-0
In_memory or Aggregate Tables
« on: 17 Jan 2018 01:54:08 pm »
Good Day

Is there any possibility of creating In-Memory Aggregates or Aggregate tables to speed up virtual cubes.

Since virtual cubes is such a key feature, I am struggling to understand how there is not way of optimizing them using the aggregate advisor ?

Thanks

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,290
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: In_memory or Aggregate Tables
« Reply #1 on: 18 Jan 2018 02:40:10 am »
Good Day

Is there any possibility of creating In-Memory Aggregates or Aggregate tables to speed up virtual cubes.

Since virtual cubes is such a key feature, I am struggling to understand how there is not way of optimizing them using the aggregate advisor ?

Thanks

Hi,

The trick is to run aggregate advisor against the real cubes that constitute the virtual cube.

Page 351 of the Dynamic Cubes Redbook details this:

http://www.redbooks.ibm.com/redbooks/pdfs/sg248064.pdf

Cheers!

MF.
Meep!

Offline fry

  • Senior Member
  • ****
  • Join Date: Jun 2013
  • Posts: 74
  • Forum Citizenship: +0/-0
Re: In_memory or Aggregate Tables
« Reply #2 on: 19 Jan 2018 01:03:32 pm »
perfect thanks makes sense !!

 


       
Twittear