OLAP Cube for Project Server 2016 On Premise and Power BI RRS feed

  • Question

  • Hello Everyone !!

    I am new to OLAP Cube.  I need to Create the power bi report for Project Server 2016 using OLAP Cube.

    I have installed the Analysis Service and configured.  When I check the database for Analysis server it has cubes for projects, task, assignment, resources, risk, issue, deliverable, Time sheet, 

    Now Sharepoint Content DB also have OLAP View for projects, resouces...etc

    1. Where from I should take the data, should be from View from content db or analysis server database created.

    2. If I need to build the custom cube then should i need to use the Analysis Service Project that comes from SQL Data Tools or from the OLAP management Database in central admin

    3. If any link for reference for creating and using cubes for project server in reporting. 

    Wednesday, October 4, 2017 11:32 AM