My scenario is that I am attempting to build a single cube from a database that contains sets of data for different companies. I wish to provide each company with a distinct view of their data. I cannot use the user role security for this purpose as all the access to the DB is via a single user (web based app). I don't particularly wish to create a separate cube for each company as the number of companies can change, so I am trying to see if I could include a dimension (company) which would ultimately be hidden but usable as a filter in MDX. Based on the selection of a value in this dimension, filter the contents of other dimensions to those specific to the company selected.

Any and all suggestions gratefully received.