Limitations of SQL Server Accelerator for BI

We are using BI Accelerator and we faced the problem that it is not possible
to insert new rows. We have some shared dimensions and when we define cubes
we also have to add list of dimensions. Very quickly we fill in the whole
space of the worksheet. The worksheet is protected and basically we do not
have any ability to have the whole Warehouse definition on one workbook. How
could we overcome this problem ?
There is not an easy solution to this.
In the latest version, there is a provision of controlling and invoking the
system via an XML file.
However, you will have to maintain the XML file yourself with your own XML
editor. Look in the 1.2 release notes and additional documentation.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"ksp" <ksp@.discussions.microsoft.com> wrote in message
news:FBB639F4-F70C-4756-AE17-2060DB3FC1C1@.microsoft.com...
> We are using BI Accelerator and we faced the problem that it is not
possible
> to insert new rows. We have some shared dimensions and when we define
cubes
> we also have to add list of dimensions. Very quickly we fill in the whole
> space of the worksheet. The worksheet is protected and basically we do not
> have any ability to have the whole Warehouse definition on one workbook.
How
> could we overcome this problem ?