Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.