Script Extensions

Profitbase Studio supports adding Script Extensions via the [New Script] menu in the Navigator.

Scripts can be of type SQL, PowerShell or XMLA (SSAS modules only).

These scripts can for example be used to cleanse, validate or distribute data. Users should make sure the scripts are logically placed in the navigator tree.

Script Extensions can be executed ad hoc or scheduled to run as part of a data flow. 

Additionally one can attach a script as being part of processing of the following content types:

  • Data Source Table
  • Dimension
  • Sub Dimension
  • Time Dimension
  • Module
  • SSAS Database (XMLA)

Click here Tutorial for Using XMLA scripts.