I want to create a cube that encompasses all companies. But there is security concern about a user accessing data across companies when the users access the cube via excel etc...
Having a unified cube would greatly give us granularity across time. (some companies sell assets to other companies so this would make sense when slicing the data to get accurate numbers.
Would a feasible solution be to add a company dimension and somehow hide it..or implement some kind of partitioning?
Any general suggestions would be helpful.