PowerPlay number disparity with impromptu number?

[Jontility]

Hi all:
I know this is simple..I am very new to impromptu and build a transformer model and created a cube, when I view the powercube the numbers indicate that we have six customers on a particular product..which is not correct...but when I drill through from powerplay to impromptu the impromptu displays the correct numbers.....I know that when the cube was created we have only six customers for that product..I might be naive to think that the powercube will automatically update itself but I think I'm wrong...so anybody outthhere who can tell me how to set this cube to be automatically recreated everynite to reflect the change in the database...I will appreciate it.



John Organ
MIS

 

[GJParker]

There are many examples of doing this using macros on the forum, here's just one thread401-602501 a keyword search will produce many more.

HTH

Gary Parker
MIS Data Analyst
Manchester, England