Limitations of SQL Server Accelerator for BI

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ksp - 16 Dec 2004 14:35 GMT

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 ?

Reply to this Message

Dave Wickert [MSFT] - 16 Dec 2004 17:48 GMT

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.

Signature

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.

> 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 ?

Reply to this Message