HELP URGENT PLEASE !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

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 cub

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 register


MANY THAN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CHANGE QUERY SQL CUBE FROM EXCEL 0
Dates In Excel 5
Excel 2003 SP3 - can't find the .cub files 2
OLAP cube DateTime dimension 0
OLAP 1
FRom Pivot table select multiple items under report filter 0
Visual Reports 0
OLAP – returning data from a separate list 1

Top