Hey

I have a critical problem
While I’m trying to use
"Microsoft Oledb provider for oracle"
In order to process my cube
My relational db stored in Oracle
So I have to use this driver
Every time I’m trying to process the cub
I get immediately error "one or more command..
Something about my relational db
I check the select statement and saw the problem
Somehow in the "from" part the olap implicit the fact tabl
Twice!! (Select ... From Sales, Sales. Where
My schema is correct and I can’t see the reason
When I’m using the Oracle provider, I get another error
The olap generate incorrect select for my time dimension
By implicit the year level twice
Again somehow the olap generate incorrect SQL querie
What should I do??

Best Regards

Chai Cheh.

I have a configuration like yours. I've got an OLAP DB with e relational DB
which can be an ORACLE os SQL Server database, you have only to change the
datasource without changing anything in the metadata structure. I also use
Microsoft OLE DB for Oracle with an ORACLE 9i database. At the beginning I
had some problems too but concernig the users and name of tables an fields
in tables. Defining everything in uppercase and using short names resolved
everything.
So I think the problem is not related with the driver or the AS OLAP wizard.
Do you have service pack 3 on SQL and AS? Do you read an ORACLE 8i DB (i've
never tried on a ORACLE older then 9i)?

Andrea

"Chai" <anonymous (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
news:F8DD04BB-ED4A-4FA9-B243-C6480DFC0161 (AT) microsoft (DOT) com...

Unfortunately I didn't find the way to do that without rebuilding the
schema. When I tried to do that by code using DSO object the source property
of dimensions and cubes went wrong and I was no more able to process the
OLAP database.

Andrea

"Chai" <anonymous (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
newsE6C2466-0174-4925-AB75-C4C9E8E3C619 (AT) microsoft (DOT) com...

We build a cube from Oracle 8i DB. We have a linked server created in SQL so we can create views for the Oracle DB and those views are the fact tables, not the Oracle tables themselves

We also had problems with our linked server to Orcl if we did not specify connection params in upper case

If you can't get it to work, you might want to test using a linked server and building your cube from it

Les

----- Chai wrote: ----

Hey

I have a critical problem
While I’m trying to use
"Microsoft Oledb provider for oracle"
In order to process my cube
My relational db stored in Oracle
So I have to use this driver
Every time I’m trying to process the cub
I get immediately error "one or more command..
Something about my relational db
I check the select statement and saw the problem
Somehow in the "from" part the olap implicit the fact tabl
Twice!! (Select ... From Sales, Sales. Where
My schema is correct and I can’t see the reason
When I’m using the Oracle provider, I get another error
The olap generate incorrect select for my time dimension
By implicit the year level twice
Again somehow the olap generate incorrect SQL querie
What should I do??

Best Regards

Chai Cheh.