V
Vadim Rapp
Hello,
in excel, I get data from sql server 2k. I create a query like this:
select ... from tblCustomers, tblSelection where tblCustomers.customerid =
tblSelection.id
The table tblCustomers has thousands of customer id's; but the table
"tblSelection" has only a few - those that need to be included in this
particular Excel report. When I run the query in MS Query, it works
correctly, i.e. it returns only the selected customers.
However, then I create OLAP cube in MS Query, save it as file, and return
the cube to Excel. In the resulting pivot table, Customers include not the
selected few, but all customers from tblCustomers .
Why is this happening and how to draw from the server only what's in the
query?
thanks,
Vadim Rapp
in excel, I get data from sql server 2k. I create a query like this:
select ... from tblCustomers, tblSelection where tblCustomers.customerid =
tblSelection.id
The table tblCustomers has thousands of customer id's; but the table
"tblSelection" has only a few - those that need to be included in this
particular Excel report. When I run the query in MS Query, it works
correctly, i.e. it returns only the selected customers.
However, then I create OLAP cube in MS Query, save it as file, and return
the cube to Excel. In the resulting pivot table, Customers include not the
selected few, but all customers from tblCustomers .
Why is this happening and how to draw from the server only what's in the
query?
thanks,
Vadim Rapp