Présentation

XML Builder allow you to automate administrative tasks on a MS OLAP Server without complex programming. XML Builder belongs to the OLAP WEBHOUSE™ Management Tools.

With XML Builder it is really easy to :
  • Script with XML an entire cube, a database or any single part of an existing MS OLAP Structure.
  • Create, modify, delete olap databases or single elements (cubes, dimensions, calculated members, roles...).
  • Automate the creation or maintenance process of the OLAP Databases you are in charge of whereever your OLAP Server is located.
  • Automatically generate a documentation of your MS Analysis Services structures.
  • Access features that are not directly accessible through MS Analysis Manager, for example: renaming a datasource.
Public
  • Developer/ VARS
  • Microsoft Analysis Services Databases Administrators
  • Independant Softwares Vendors (ISVS)
How It Works

With XML Builder you can easily generate an XML script of any element of a MS Analysis Services structure and redo the script (with or without modification) on another MS Analysis Server. XML Builder use a simple yet very effective XML schema to describe OLAP META-DATA and actions you want to operate.(such as CREATE, ALTER or DROP). An understanding of MS Analysis Services OLAP Structures is sufficient to leverage the power of XML Builder.

Example : Script that rename the datasource on the FoodMart 2000 sample database:

- <wsxmlbuilder>
 - <server name="WSLPLB" action="alter">
  - <Databases>
   - <Database subtype="0" name="FoodMart 2000" action="alter">
    - <DataSource type="object" name="FoodMart 2000" action="alter">< br>        <Description/><br>       <Name>MyDataSource</Name>
     </Datasource>
    </DataSources>
   </Database>
  </Databases>
 </server>
</wsxmlbuilder>

As you can see no development skill is needed, the previous script simply describes what we want to achieve.

A genuine set of tools completely integrated to Microsoft products . You can even extend them if you need to.

XML Builder is delivered as several different tools, to easily match your working habits :

-With the MS Analysis Manager Wizard, you can in a few clics :

a) generate the XML definition of the OLAP structure that you selected.

b) apply an XML Builder script to one or several existing MS Analysis Server.

- With the Command line tool, you can launch a whole set of modifications to a MS Analysis Services Server

- With the MS Data Transformation Services Custom Task, you can integrate your XML Builder scripts to your own MS DTS Package.

- A Retro-documentation feature that allows you to automatically generate an HTML documentation of your MS Analysis Structures.

- An extensible component you can use with every COM compliant programming language to integrate XML Builder to your own application.



Licensing modes


XMLBuilder Version - 2 licencing mode avalaibles :

  Standard Version :

Scripting supported: cube, dimensions, measures, calculated members, calculated members, actions, Data-mining
  

  Professional Version :

Includes Standard versions features and support partitions management, aggregation design, security, process

To Order, please contact our sales department :
All Our Products


This product interests you?

Send to us a request for information



 
Copyright Winsight 2004-2005 - Webdesign www.cubedesigners.com