Filter for Multi-company Cube

• elliot@datahabitat.com

  Valued Member

  Points: 59

  More actions

  October 28, 2003 at 12:05 pm

  #107400

  I need to create a cube for a multi-company application, and make it available for use with Office Web Components Pivot Table and Pivot Chart via MS BI Portal. Now I need to restrict each user access according to company (fact and dimensions have data from several companies). Can I do that using a filter with MDX? Can I apply such a filter after the cube has been processed and communicate the results to Pivot Chart ?

• Keith Henry

  Hall of Fame

  Points: 3759

  More actions

  October 29, 2003 at 1:50 am

  #480022

  What version of OWC can you use? OWC XP can return results from MDX statements but earlier versions can't

  Keith Henry

  DBA/Developer/BI Manager

  
  
  
  Keith Henry
  

  ---

  
  According to everyone I know I "do something with computers?" for a living, so there you go.

• elliot@datahabitat.com

  Valued Member

  Points: 59

  More actions

  October 29, 2003 at 6:09 am

  #480074

  XP. Can you suggest where I can find documentation about this? Thanks.

• Keith Henry

  Hall of Fame

  Points: 3759

  More actions

  October 29, 2003 at 6:55 am

  #480091

  http://www.microsoft.com/downloads/details.aspx?FamilyId=BEB5D477-2100-4586-A13C-50E56F101720&displaylang=en

  Keith Henry

  DBA/Developer/BI Manager

  
  
  
  Keith Henry
  

  ---

  
  According to everyone I know I "do something with computers?" for a living, so there you go.

• elliot@datahabitat.com

  Valued Member

  Points: 59

  More actions

  October 29, 2003 at 8:13 am

  #480122

  Thanks!