Pivot Table Width on Cube View Admin page
There are a few things in the Project Web Access interface that initially bothered me that have faded with time, but the width of the Pivot table on the View design page continues to irk me.
The monitor I use is wider than average, but the page for creating or modifying Data Analysis views only provides a Pivot table that is not even half of the page width. An equal amount is allocated to instructions that do not come close to filling the space.
Today, I decided to hack it. And it is a hack. There is nothing elegant or clean or supportable about this. But if you are producing lots of Data Analysis views, perhaps you will want to do this too. But if you do, heed the following warnings:
This is not supported by Microsoft
This modification will impact all users regardless of their monitor size (or at least all users that can access the page)
Start on your server and navigate to the following file:
c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\Template\Layouts\CubeAdmin\CubeViewAdmin.aspx
Next, find the following code:
<!-- OWC section --> <div id="idPivotTableDiv" style="display:block;" > <asp:label ID="lbldivPivotTableLBL" text="<%$Resrouces:PWA,CUBEADMIN_CUBEVIEWADMIN_PIVOTTABLE_LABEL%>" runat="server" /> <div style="width:100%; height:300px; overflow:auto; border: 1px Solid Black;"> <object classid="clsid:0002E55A-0000-0000-C000-000000000046" id="idPivot"></object> </div> </div>
Do you see the width and height definitions for the DIV section? That's where we should make changes, but only after you backup this file.
Perhaps try setting the width to 1000 pixels and the height to 500 pixels as below. You will have to base this on your screen size (remembering that this change is at the server level so every other user of the page will be impacted as well.
<div style="width:1000px; height:500px; overflow:auto; border: 1px Solid Black;">
This results in something I find much more usable.