I want to Create cube and dimension from SharePoint List and want to generate result using MDX on SharePoint List, so Please anyone can guide me how to import SharePoint 2010 List directly to SSAS ?

Please note : I don't want to use Custom Database e.g. import data from SharePoint List to Custom Database using SSIS using example of URL which are below.




Thanks In Advance

  • Did you explore using SharePoint List directly in SSRS? – Alok Kumar Gupta Apr 6 '17 at 5:20

You are mentioning "import" so by definition it means taking data over. On the other hand, except for the SSIS packages, I personally haven't heard of a capacity of SSAS to be able to define cube on volatile data - e.g. real-time feeds (but again, maybe I'm wrong!)

Are you aware that SharePoint server also has its own tools for business-intelligence, which allow direct building KPI, scorecards and dashboard with SharePoint lists? Have you looked at using PerformancePoint designer to directly build BI solutions ? Did you tried also using PowerPivot (http://technet.microsoft.com/en-us/library/gg413413.aspx), but in the context of a SharePoint ?

  • Hello Marius, Thanks for reply, I know PowerPivot, but I have to develop SSRS Report, SilverLight Dashboard and HTML5 + CSS3 lightweight web for portable devices for same SharePoint List with some complex output for which I have written MDX. and currently I am using SSIS package (dataqueen.unlimitedviz.com/2011/06/…) but not satisfied that much. so I am searching alternate tools – Kapil Dave Sep 30 '13 at 7:41

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.