Answer this SQL OLAP Cube Question
$10-30 USD
Paid on delivery
I have Project Server; navigating to "Server Settings" then "OLAP Database Management" shows me my default Cube. I have selected "Configuration" and added a custom field Dimension and successfully re-processed the OLAP database.
Within the Project BI Center I have a number of OOTB Excel files, each configured to use the default PS cubes. When opening"OlapTimesheet" I expected to see the new Dimension (added above) within my Pivot table - however this is not the case. Also, when opening the modified Cube with SQL Data Tools I cannot see the new dimension.
When I open the OOTB Excel file I expect to see the new Dimension for use in the Pivot.
First to provide me with the answer gets $30 :)
Project ID: #6088675