| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CHANGE QUERY SQL CUBE FROM EXCEL
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to protect ms query written in excel to view, change, del | Excel Discussion (Misc queries) | |||
| where is the create OLAP cube option from microsoft query? | Excel Discussion (Misc queries) | |||
| suppress warning and locate cube in a pivot table from olap cube | Excel Discussion (Misc queries) | |||
| How do I change the datasource location for a query in Excel 2003 | Excel Discussion (Misc queries) | |||
| Fields change order from MS Query to Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
