Not Auto Refreshing of Pivot Table 1

[MoDaya]

Hello,

I created a basic cube, processed and browse it. Then a couple of days later when I browse the cube again, I stil get the previous number - not the updated number. How can I get the cube to auto-refresh whenever I browse? I don't want to have to process it always...

Many thanks...

 

[MDXer]

If you are using MOLAP as the storage type then you have to process the cube to have the new data built into it. You can create a dts package that does a cube process on a scheduled basis.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck