Posts Tagged ‘Groovy’
Dimension Member Count Matrix
When managing a system it is useful to have a table of dimensions and the cubes that they are valid in like the example below. The numbers are a count of the members in the dimension that are valid for that cube. To get the grid, I have a groovy script to produce the CSV…
Read MoreASO Copy Actual to Forecast
In Planning a common requirement is to actualise the forecast with the latest actuals. This blog is a groovy script that will clear the Actual set of periods from the Forecast e.g. Jan to Jun for the current year and then copy the same periods from the Actual Scenario into the Forecast. It is an…
Read MoreCopy Version Snapshot in ASO model
Something that comes up regularly is creating a snapshot of Scenario & Version, often a copy of “Budget” “Working” into “Budget” “Final” and locking the data as read only. Data Copy in BSO In a BSO or Hybrid model it’s pretty straight forward and you’d do something as simple as this: It’s quick, simple and…
Read MoreData Extract with Ancestor Meta Data
From time to time requirements to publish meta data along with an extract come up. I recently had a requirement to produce an extract with column headers a bit like this: This was two dimensions, the bottom row is just level 0 members, the second row up is level 0 members with parents, grandparents &…
Read More