J
Juanjo
Hi,
I've got a pivot table in excel 2000. The pivottable's
data source is a olap cube (exists 2
files in my hard disk .cub and .oqy).
The problem occurs when I want to filter data from cube
The cube uses a view in a SQL Server database and we need
to restrict these view depending on the value of a cell in
the sheet (for example between dates)
Is it possible to make code in the sheet that refresh the
data modifying the query?
In this sheet there are thousands of registers
MANY THANX
I've got a pivot table in excel 2000. The pivottable's
data source is a olap cube (exists 2
files in my hard disk .cub and .oqy).
The problem occurs when I want to filter data from cube
The cube uses a view in a SQL Server database and we need
to restrict these view depending on the value of a cell in
the sheet (for example between dates)
Is it possible to make code in the sheet that refresh the
data modifying the query?
In this sheet there are thousands of registers
MANY THANX