Home Forums Data Warehousing Analysis Services How can I have multiple cubes based on the same structure where the underlying data that is sub divided by company? RE: How can I have multiple cubes based on the same structure where the underlying data that is sub divided by company?

  • April 28, 2017 at 12:42 pm

    #1940431

    RonKyle - Friday, April 28, 2017 12:40 PM

    Use one cube and apply dimension permissions to each company for their data only.

    Given that the initial description has some ambiguity and certain details would need to be fleshed out, the risk here is that the companies don't have identical dimensions/products etc.  When the original poster said "and only see their data", I assumed that referred not only to fact table entries but also dimension information.  If it only refers to fact table entries, this is a good recommendation.  But if not, then securing the dimension information becomes complicated.

    Went on the assumption that OP will have one fact for all his companies, and all related dimensions will be the same. 
    Like you say, if it's not all structured the same, one cube might not be the best approach.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle