SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are using a term store taxonomy for the company organisation and each user profile has been tagged to a organisation taxonomy item.

Now the demand is to view how many people are located in a department and all sub-departments.

Could you build a SQL Analysis cube based on a SharePoint term store taxonomy and user profile fields?

share|improve this question

You would have to develop a custom staging database with a star Schema and the do a timer job export or something. Do you really want a cube just for this one type of query? Unless you have other facets than just department, I would solve this a different way.

share|improve this answer
Thanks for your answer Chris. How would you solve it? The demand is that the data is dynamically updated and thath end users can view the data in an easy way. – Jonas F Sep 7 '11 at 11:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.