none
How to? OLAP Timesheet Cube reporting - Project server 2013 RRS feed

  • Question

  • Hi there, 

    I recently upgraded our sharepoint and project server from 2003 to 2013 SP1. After a lot of digging, searching and nerves consumend, i realized that the old Data Analysis is gone forever. On another post, i asked how i could report the timesheet, and i was told that the closest thing to Data Analysis is OLAP Cube Reporting. 

    Now i configured the OLAP Cube in Sharepoint, and it works on a daily basis without error, i also added the Business inteligence subsite, but i can't for the life of me find the OLAP Timesheet Reports anywhere, not in Data Connections, not in Reports, not anywhere. I couldn't find anything on Microsoft's websites or other forums, so i have no idea how to make these Timesheet reports function.

    Can someone show me step by step from the beginning how can i get reports on Timesheet using OLAP Cubes? (Work, Actual Work, etc.)

    Thank you in advance.

    Monday, August 31, 2015 6:09 AM

Answers

All replies

  • So you don't see the Project Server - Timesheet Data file in Data Connections?

    Here is where mine is located.

    PWA > Business Intelligence Center > Site Content > Data Connections > English > Project Server Timesheet Data

    Edit and open in Excel... Hope this helps a little. 

    Monday, August 31, 2015 6:56 PM
  • I ended up remaking the PWA site. Now i can see it.

    The problem is that now it says that i don't have access or the DB is not created. Any thoughts on the matter? I configured a PSDATAACCESS group in SQL and added my user but i think i may be missing something.....

    Tuesday, September 1, 2015 6:09 AM
  • Does your AD account have access to the OLAP cube with ProjectServerViewOlapDataRole role access? Typically you would add the Report Authors AD group to this role on the OLAP Cube database, for details see the two links below for setting up the reporting access in Project Server 2013:

    https://technet.microsoft.com/en-us/library/ee662106.aspx - SQL Server settings

    https://technet.microsoft.com/en-us/library/jj943761.aspx - SQL Analysis Server settings

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, September 1, 2015 7:07 AM
    Moderator
  • I made the exact same step by step options but to no avail. However check this out.

    In the Analysis Server there are no databases created at all. Even if it says build success in OLAP Database management. What should i do? In excel services i gave PSDataAccess the rights just like in that technet post, and i added my user to that group in AD. So whats going on?

    Tuesday, September 1, 2015 7:36 AM
  • Hello,

    If the cube has been built on that SQL AS server I'd say the account you are using to access SQL Management Studio does not have the correct access to see the cube database.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, September 1, 2015 7:44 AM
    Moderator
  • I doubt that, i am logging using a sysadmin account, that sysadmin account is in the PSDataAccess Group. Any thoughts? What should i try? Cause i'm out of ideas.
    Tuesday, September 1, 2015 9:04 AM
  • Hello,

    An account with Sysadmin in SQL Server doesn't always have admin access in SQL Analysis Services, they have different access models. What account has Admin access to SQL AS? Try using that account to see if you can see the cube database in SQL AS.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, September 1, 2015 9:09 AM
    Moderator
  • I used a "sqlserv" account. But wheter i use it or some other account that would have access, it just asks me for credentials in Multidimentional connection. Afterwards I get: " Errors in the OLE DB Provider. The integrated Security property cannot be set if a username and password is supplied".
    Tuesday, September 1, 2015 10:39 AM
  • When you installed the SQL AS server, you would have specified SQL Analysis server administrators users - one of these will have the correct access to set the permissions needed against the OLAP Cube database that Project Server creates.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, September 1, 2015 11:30 AM
    Moderator
  • As you can see, all are using the sqlserv account i mentioned. So i am thinking that is not it ?
    Tuesday, September 1, 2015 11:38 AM
  • Ok i entered SQL Managementu studio using the Run As SQLSERV user. And not i can see the Databases. What now?

    Tuesday, September 1, 2015 11:42 AM
    • Marked as answer by George Teodor Tuesday, September 1, 2015 12:07 PM
    Tuesday, September 1, 2015 11:44 AM
    Moderator
  • Ok, i was able to finally access the OLAP Timesheet report, but for some reason it only shows myself as a resource with hours. I have about 20 people in my Resource Center meaning it should show them all even if they have 0 hours and 0 assignments, so why does this report show only my hours? I'm pretty sure i haven't skipped any step. Is there something else for me to do? 
    Tuesday, September 1, 2015 11:57 AM
  • Hello,

    For the reporting schema to contain data the users would need to have created and saved the timesheets...

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, September 1, 2015 11:59 AM
    Moderator
  • Ok, i marked you for answer. I thought timesheets are created automatically since i added Resources in the Resource Center, but i guess not? Anyway, thank you. I will try to figure out how to create and save the timesheets like you said. If i can't find i wil make another post. Thx again.
    Tuesday, September 1, 2015 12:09 PM
  • Hello,

    Good to hear the report now works.

    Regarding timesheets - the users will need to login and access the timesheet page for the timesheet to create...

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Tuesday, September 1, 2015 12:11 PM
    Moderator