Can't browse fact table data

[foofer]

I have a problem building my cube. When I add the fact table and then try to browse data, I get an error 'Unable to retrieve data'. I am able to browse some other tables, just not the one I need.

 

[johnherman]

Two things come to mind. First, security - do you have read (select) access to the fact table? Second, your star schema model - are things joined correctly?

To verify the star, you could start by rebuilding it from scratch, starting with the fact table and a time dimension, then add the other dimensions one at a time.

-------------------------
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw

 

[foofer]

Thanks for your answer. Actually, I found that my problem was because my Oracle view had some TimeStamp fields. Apparently Analysis services doesn't like that field type.