I am trying to browse data in my fact table, which is an Oracle view, but I
get an Automation error when I do this. I can add any other view from the
same schema with no problem, just not this one. I have no problem seeing the
view in TOAD. Also, if I add the table without browsing data, Microsoft
analysis services counts the rows.
--
Toni

Kind of confusing question.

Your post title says you have a problem "adding a fact table to a cube" but
you're saying here that you're trying to "browse the data." Does this mean
you can't build the cube off of that view? Or does it mean you can't add it
to the schema at all because you can't see it? Why would you need to browse
fact data in AS?

I'm guessing, correct me if I'm wrong, that you just can't see this view in
the list of tables and views from the datasource. If so, refresh the
datasource to get the most current list of tables and views from Oracle. If
you still can't, be sure the view is in that schema and be sure that the user
has permission to it.

If I misread your post, I apologize, you'll need to clarify what the problem
is.

- Phil


"ToniHelton" wrote:

Sorry for the confusion. Yes, I was able to add the table to the cube, but I
couldn't get any data. I tried to browse the fact table and realized that
was where my problem was. I finally figured out the problem. The issue is
that for some reason, Analysis Services does not like timestamp data type.
It works fine for date data type, so I'm changing those in my view.

Thanks so much for your help.
--
Toni


"SQL McOLAP" wrote: