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?


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.

| 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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