The model contains the data source and it's location. If the cube has been
setup for incremental updates then only new data will be added to the
existing cube (this is all done in the model). If this is the case you need
to make sure that there is only new data in your source file, otherwise the
numbers in your cube will be incorrect.

If incremental updates are not specified the entire cube will be rebuilt
from scratch based upon the contents of your text file.

If you open up the transformer online help and search for "command line"
you'll see all of the available options. An example of a typical batch cube
build would be:

trnsfrmr.exe -c -m c:\mymodel.mdl

ya


<skeize (AT) gmail (DOT) com> wrote

My boss has assigned me to maintaining all of our companie's PowerPlay
cubes. They were already in existance, but the batch files that load
them are heavily modified and very confusing. There is one in
particular that needs to pull data from a text file and loads in into
the cube. I'm unable to find very much documentation on how to do that
at all. I understand that I need to define a data source in the
transformer, but as for what command line commands to use when actually
doing the update I am unsure. Does transformer automatically do the
updates, or is it soley the responsibility of the batch job running to
make sure that data is fed into powerplay on a regular basis?

Part of your batch script can be to enable and disable the cubes during the
build process. I can't remember the exact command line syntax but it is
something along the lines of :

../ppadmtool connect <server> <userid> <password>
enable <cube name>

There is also a GUI interface (PowerPlay Enterprise Server Administration)
that allows you to simply select the cube and click the start button.

Cubes are generally disabled during the cube build process in order to avoid
sharing violations. Hope this helps.

ya

<skeize (AT) gmail (DOT) com> wrote

ya,

Thanks for the help. I got my batch updates working. However, when I
copy the updated cube over to the web server that powerplay is on, the
cube is showing up as disabled in UpFront. After I copy it, do I have
to enable it on the powerplay server, or is it done automatically?

skeize (AT) gmail (DOT) com wrote:
My scripts usually stop virus checker, create cubes in a separate
staging directory, stop PPES using NET command, copy all files
to the production directory, start PPES and finally enable
virus checker.

HTH

Michael