June 21, 2005 at 2:46 am
This is my problem. I have an excel file (displaying data connected to a OLAP cube), which was created last year by my ex-colleague. Since then I have modifed the fact table to include 3 more measures. I have also updated my dimension data...(more divisions of my company). While I am able to view all the new data under my 'Division' dimension, I am unable to see the new measures added. Is there any other place besides the Excel wizard, or the 'Show fields list', where I get to see the fields after doing a 'Refresh Data'.
More importantly, where I can see in Excel the connectionstring to the cube? The data displayed for the other measures is the lastest updated figures...so then why am I not seeing the new added measures?
Please HELP ASAP
June 21, 2005 at 8:24 am
The connection string will be stored in a file named <something>.oqy, so if you earch on your drive/s (usually in the C:\documents and settings\<user>\... for *.oqy you should come up with one or more data sources for queries.
As to why they're not there, it could be that you're pointing to a different datasource (ie server), caching (maybe but unlikely) , visibility property on the emsures not correctly set, the role/s on the cubes not allowin viewing. Check some of these out and let us know how you get on.
Steve.
June 21, 2005 at 8:30 am
Thanks Steve. I'll check and get back definitely tomorrow.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply