Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cat_jesus
Aged Yak Warrior
547 Posts |
 Posted - 2010-04-12 : 11:05:52
|
| I have a cube that I can deploy and process from BIDS. I have it processing on the server without error through a scheduled job. I can browse the cube from SSMS but I can't browse it from BIDS.Also some people can use Excel to view the cube while others cannot, even though both are defined in the read role.Any ideas on what to look for?An infinite universe is the ultimate cartesian product. |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-04-15 : 06:59:48
|
| When you say you cannot browse the cube in BIDS, what does that mean? Do you get an error message? Browsing a cube on a production server using BIDS requires you connect in "online" mode.What errors are your Excel users who cannot access the cube getting?______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2010-04-15 : 13:14:12
|
| I figured this out, somewhat. I had two different errors. One seems to be a meta data corrpuption in my project. The other was a lack of the OLAP OLE driver on the client machines.An infinite universe is the ultimate cartesian product. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-04-18 : 17:27:57
|
| On your meta data corruption issue, I seem to have a problem with an Analysis services installation on my laptop. Somehow the Adventure Works sample cube has some corruption issues on one of the dimensions. I cannot do anything with the Analysis Services component, nor deploy/process anything to the cube.______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
|
|
|
Can't browse cube from BIDS