How to refresh ?

[dophin]

Hello, Alex

I don't know how to achieve the following :

a query provides data to a pivot cube
the query makes some filtering on the
underlying tables to provide a small dataset
to the cube

From time to time, the user needs to change
that first filter so he uses infopower's wwFilterdialog
to specify new conditions.

The fieds included in the "new" dataset are always the
same. Only the records are possibly different.

Could you please tell me how to refresh the cube
preserving the layout : column dimensions,row dimensions,
and measures displayed, even if the values are "renewed" ?

TIA

Joseph Osende

[AlexZencovich]

PivotMap.Savexxxx;
PivotCube.Active := False;
set filter
PivotCube.Active := True
PivotMap.Loadxxxx;


But in most cases internal filtering will faster because you have set filter not in query, server-executed conditional like "select * from table where filter_conditions" but dataset-based filter so you should keep FULL dataset in memory and refresh it with filter. It just slowdown if you not need to edit that dataset at same time as when you work with OLAP cube.

Smaller dataset by filter conditions will faster only if you perfrom server-based filtering when you work with client OLAP.

[dophin]

Thank you for the quick reply, Alex

Joseph Osende