Lets consider the following:

Dim_A. Dim_B
Name Value Name Value
1 Cat 1 Big
2 Dog 2 Small


The fact table
# Dim_A Dim_B Value
1 1 1 11
2 1 2 <null>
3 2 1 31
4 2 2 41
5 3 1 51
6 3 2 61

I will have problems with the records: 2 (because of the null), and with 5
and 6 (because there is many Dim_A = 3)
I would like to make a report in Excel with these records. I used DSO to
generate the query.

Select * from fact_table left join………

Now I have the query and I need to run it. For that I need a connection to
the database with ADODB. When I use the provider “MSOLAP”, I can just query
the cube. So my query will fail because “from” means from a “cube” and I have
a “fact_table” in the from statement. When I try the provider “sqloledb” a
can not access the database at all.

How can I proceed with It???

If you want to see what records are missing in the cube you will need to
check the source tables. And not the cube. You can't query what isn't there.

So the select you wrote is the way to go. But you need to connect to your
source system. If your source is sql you could use the sqloledb provider.
But the connection string must be pointing to your source DB and not the OLAP
db.

Regards,
Nc

"Soan" wrote: