I have a cube that builds perfectly on the desktop, but fails on our UNIX server - actually it still builds, but has not "connected" the data correctly.
A group of star-schema tables are used. Each dimension has a surrogate_key at its lowest level, and the fact table query for measures data includes all of the foreign surrogate_keys.
The server build opens in Upfront looking fine (all totals OK) but if you attempt to split the totals by the dimensions (eg. split total products by their product type) the detail area comes up all zeroes. It's as if the server build has not matched the keys correctly.
All queries deliver, all keys should find matches.
Access Manager security is built-in, but I have top-level access so should be able to see all data splits. We're using Transformer 7.0.
Your help would be a wonderful thing.
regards,
Doddy